MySQL Error when deleting posts/pages – Something to do with ELA

  • faustina

    (@faustina)


    17 years, 3 months 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

Viewing 3 replies - 1 through 3 (of 3 total)
  • drmike

    (@drmike)

    17 years, 3 months ago

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

    pawoodster

    (@pawoodster)

    17 years, 2 months 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.

    JaneLitte

    (@janelitte)

    17 years, 2 months ago

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘MySQL Error when deleting posts/pages – Something to do with ELA’ is closed to new replies.