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 RONIN ON EMPTY.
Archive for the ‘Funny Tagline of the Week’ Category
WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'webkozo_wordpress.roe_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 roe_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
