Small problem, anyone able to help?

  • threevisual

    (@threevisual)


    16 years, 6 months ago

    When I edit a wordpress post or page I get the following error, however it still publishes the post without any problems, it’s just annoying to see this error each time.

    Anyone have any ideas on how to solve this?

    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 <> 2 AND p2c.category_id <> 5 AND p2c.category_id <> 12 A’ 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 <> 2 AND p2c.category_id <> 5 AND p2c.category_id <> 12 AND p2c.category_id <> 16 AND p2c.category_id <> 18 AND p.post_date_gmt < ‘2007-10-15 09:09:26’ ORDER By p.post_date DESC

Viewing 2 replies - 1 through 2 (of 2 total)
  • oddb

    (@oddb)

    15 years, 11 months ago

    The only thing that i don’t kind of understand is the A just before ` at line 5] in the last line of the SQL syntax error.

    Hope this helps

    robin

    sabinou

    (@sabinou)

    15 years, 11 months ago

    Have you tried to open your database with phpmyadmin, check all tables, and do “repair” ?

    Backup first, anyway 😉

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Small problem, anyone able to help?’ is closed to new replies.