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 < '2025-02-26 01:37:40' 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





























The Cotillion - Portia Rediscovers Me!

So, we’ve been having a Cotillion each and every week, and I just haven’t been playing the past few weeks (for one reason or another…let’s leave it at "real life" getting in the way).  I did have a chance to get a post submitted this week, and it’s part of the great round up at Portia Rediscovered (you’ve just GOT to take a look at her new digs!).

As always, the post is also over at the Cotillion.  Many thanks to Portia for a great round up and to all of the fine ladies for many great posts!

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='348' 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

Trackbacky badness

So, I have no idea what's going on with the trackbacks on my page. Like I said, we're still under construction. I feel terrible about them not showing up, so I thought I'd just list them all here: MerriMusings trackbacks...