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 < '2024-04-20 03:28:56' 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





























Hostage Roy Hallums is Free!

Excellent news over at Rusty’s site…Roy Hallums was rescued today! 

I cannot possibly articulate the relief and joy the Hallums are feeling, but Rusty sums it up nicely:

UPDATE from Rusty:Today is one of the happiest days of my life.  I’m literally crying.

And a brief statement from Roy:

I want to thank all of those who were involved in my rescue — to those who continuously tracked my captors and location, and to those who physically brought me freedom today.

To all of you, I will be forever grateful. Both of us are in good health and look forward to returning to our respective families. Thank you to all who kept me and my family in their thoughts and prayers.

Roy, you and your family are still in my thoughts and prayers.  Thank God you are coming home!

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='301' 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
Jay said:

Good news indeed, thank you for pointing it out for me. Oh, and I love the new look. Works fine from home.