Note: This blog expresses only the opinions of the blog owner, and does not represent the opinion of any organization or blog that is associated with The Golden Rock.
WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'webkozo_wordpress.gr_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 gr_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list, references column 'webkozo_wordpress.gr_posts.post_date' which is not in SELECT list; this is incompatible with DISTINCT] SELECT DISTINCT MONTH(post_date) AS month, YEAR(post_date) AS year
FROM gr_posts
WHERE post_date < '2012-04-01'
AND post_type = 'post' AND post_status = 'publish'
ORDER BY post_date DESC
LIMIT 1
WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list, references column 'webkozo_wordpress.gr_posts.post_date' which is not in SELECT list; this is incompatible with DISTINCT] SELECT DISTINCT MONTH(post_date) AS month, YEAR(post_date) AS year
FROM gr_posts
WHERE post_date > '2012-04-01'
AND MONTH( post_date ) != MONTH( '2012-04-01' )
AND post_type = 'post' AND post_status = 'publish'
ORDER BY post_date ASC
LIMIT 1
