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-03-29 00:37:59' 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





























I’m Back…for Now!

I arrived safe and sound back home on Saturday, only to be welcomed by a slight ear injury from the flight (pressure trauma, according to the urgent care doc), darn it, as well as a number of crazy things in REAL LIFE.  I just wanted to let you know that I’m alive, and indeed will probably post some things this week before hubby and I go on our trip to Vegas (my first time!).  I’m looking forward to it!

Many thanks to my partner in crime, Raven, for doing a TREMENDOUS job filling in for me in my absence.  I can only hope she got some good traffic from it!

I’m Back

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

2 Comments
Raven said:

Your welcome Merri. Sorry it has taken me all darn week to get back over here too...LOL...Been a little busy. I can cover for you when you go to VEGAS too!! (Even though I would MUCH rather be with you there...)



Janette said:

Congratulations to you and Vinnie on your anniversary! Have a great trip!