WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'oldsite_dcvwp.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 YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC

 
|

WorldCupFan-03

Nuthin' Like a Dane
An Australia supporter readies for the start of a first round World Cup match against Germany
Tip of the Hat From a Netherlands Fan
Korea Yes
All for Paraguay
Sun Goddess
She Hearts the Netherlands
She Reigns in Spain
Ahh, Spain
All the Way From Paraguay
Let's be Free
Argentina's Back
Nigeria-A-Go-Go
Portugal Rising
South Korea's Little Devil
Germany, Ja!
Up With Honduras
Hello, Portugal
Rising Sun
Sweet Smile

Phản hồi