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

Dream if you dare!

About

Welcome to Today in my dreams!

My name is Dru. Like everyone, I have dreams. Here is my disciplined attempt to daily allow breath into my dreams, so that one day my dreams and today will be one.

You are invited to read my dreams. You are also invited to request to also participate in this discipline. I will support the realization of your dreams as you support the realization of mine. If you pray, I ask that you remember my dreams in your prayers.

Sincerely,

Dru

Leave a Reply

You must be logged in to post a comment.

  • Search

  • Pages

  • Categories

  • Archives

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

  • Meta