Forums

MySQL Error when deleting posts/pages - Something to do with ELA (5 posts)

  1. faustina
    Member
    Posted 5 years ago #

    I get this error whenever I delete a page/post. The thing actually gets deleted but this shows up.

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND p2c.category_id <> 1 AND p2c.category_id <> 18 AND p.post_date_gmt ' at line 5]
    SELECT DISTINCT MONTH(p.post_date) AS
    month FROM wp_posts p INNER JOIN wp_post2cat p2c ON (p.ID = p2c.post_id ) WHERE YEAR(p.post_date) = AND p2c.category_id <> 1 AND p2c.category_id <> 18 AND p.post_date_gmt < '2007-01-17 10:46:13' ORDER By p.post_date DESC
    Warning: Invalid argument supplied for foreach() in /home/.greer/myworld/gollygolly.com/wp-content/plugins/af-extended-live-archive/af-extended-live-archive-include.php on line 294
    Warning: Invalid argument supplied for foreach() in /home/.greer/myworld/gollygolly.com/wp-content/plugins/af-extended-live-archive/af-extended-live-archive-include.php on line 461
    1

  2. drmike
    Member
    Posted 5 years ago #

    Try turning off the af-extended-live-archive plug in and see if that helps.

  3. pawoodster
    Member
    Posted 5 years ago #

    I'm also getting the same error. It occurred with 2.05 and currently with the upgraded 2.1.

    Turning off ELA solves the problem, but I obviously don't want to turn off ELA if I can help it.

    Unfortunately, the ELA support forums aren't of any use.

  4. JaneLitte
    Member
    Posted 5 years ago #

    I had the same error. I changed the permissions on my cache folder in the af-extended-live-archives folder to 777.

Topic Closed

This topic has been closed to new replies.

About this Topic