When saving material, I am getting the error message below. I’ve tried optimizing and repairing databases, but the problem persists. Please help!
The site is at http://bizlawnews.com. We use Organics News Theme
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)
I don’t were the error is being thrown on your site, but it seems to be related to an error in a (custom?) SQL query.
Did the error appear from one day to the next? If so, try to remember what changes you made prior to that.
That’s pretty much all I got for now.