WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'ros_wp.ros_wp_posts.post_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM ros_wp_posts WHERE post_date < '2024-04-26 22:06:47' AND post_date != '0000-00-00 00:00:00' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
| |
Apparently my anti-spam images were causing some issues. The pictures have gone now so you can comment again.
Thanks to Scott at Real Epicurean for pointing this out.
RSS feed for comments on this post. TrackBack URI
WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'ros_wp.ros_wp_posts.post_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM ros_wp_posts WHERE post_date < '2024-04-26 22:06:47' AND post_date != '0000-00-00 00:00:00' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
| Blog: |
| Living to Eat |
Topics: |
| Food, Wine |
I just had to test it out to see if the comments are now working : p
Comment by Scott at Real Epicurean — January 10, 2007 @ 1:05 pm
Convinced?
Comment by ros — January 10, 2007 @ 4:13 pm