WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'merri_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_date < '2019-01-15 21:35:02' 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





    • Design by





























Sick…Again…Ugh!

So, I woke up sick again.  Decided to go to work anyway.  Stuck it out most of the day, albeit miserable.  Came home, took a couple of hours nap thinking it would make me feel better.  And I did feel better…for a bit.  I hate being sick.  I just want to get two productive days at work this week so I don’t feel so behind after all the sickness last week.  And I want to have fun with the kids and their new toys.  And I want to find something to post about…nothing I read tonight sticks out for me.

New Year’s Resolution?  Trade this sick body in for one that works.  Dammit.

WordPress database error: [Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'merri_wrdp1.wp_comments.comment_type' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
SELECT comment_author, comment_author_url, comment_type, MAX(comment_ID) as comment_ID, SUBSTRING_INDEX(comment_content,'strong',2) as trackback_title, SUBSTRING_INDEX(comment_author,' » ',1) as pingback_blog, SUBSTRING_INDEX(comment_author,' » ',-1) as pingback_title FROM wp_comments WHERE (comment_post_ID='396' AND comment_approved = '1') AND (comment_type = 'trackback' OR comment_type = 'pingback') GROUP BY comment_author, comment_author_url ORDER BY comment_ID DESC LIMIT 50

1 Comment

It hit me Tuesday afternoon. Still home sick. May not make it in tomorrow, either. And, being a contractor, no work no pay.