Support » Fixing WordPress » WordPress database error:

  • I am getting this error message when I save or update material. How do I correct 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 ‘GROUP BY YEAR(post_date_gmt),MONTH(post_date_gmt)’ at line 1]
    SELECT DISTINCT YEAR(post_date_gmt) AS year, MONTH(post_date_gmt) AS month, MAX(post_date_gmt) as last_mod, count(ID) as posts FROM wp_posts WHERE post_date < ‘2013-01-26 00:48:35’ AND post_status = ‘publish’ AND post_type = ‘post’ ORDER BY post_date_gmt DESC GROUP BY YEAR(post_date_gmt),MONTH(post_date_gmt)

  • The topic ‘WordPress database error:’ is closed to new replies.