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-10-20 17:09: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





    • The 2006 Weblog Awards



      Design by





























Slacker Blog Hostess Returns

Well, I kinda return.

Things have been crazy in the House of Musings, so I apologize for my time away. Unfortunately, I do have a “day job” so it has taken much of my time.

I promise I’ll be around more. I did get to watch ‘24′ tonight, plus the Super Bowl (way to go COLTS!) and American Idol is on tomorrow night. Whee…..I have plenty to write about, huh? Don’t even get me started on kidnapping child abusers or murderers or the ACLU.

In the meantime, please stop by Beth’s and read this post. While her angst is much more pronounced than mine, I do share in her sentiment about blogging. Not that I’m saying that this is good-bye. Just that I’m a bit bored with it currently and the media and the politics are pissing me off as of late, so I’m at a loss of what to really say (I should post a picture of me throwing my hands up in disgust, but eh…I’m too lazy to drag out the damn camera to do it at this point!). But there will always be something that pulls me back. …and that’s not a threat! Heh.

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


    WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list, references column 'merri_wrdp1.wp_posts.post_date' which is not in SELECT list; this is incompatible with DISTINCT]
    SELECT DISTINCT MONTH(post_date) AS month, YEAR(post_date) AS year FROM wp_posts WHERE post_date < '2007-02-01' AND post_status = 'publish' ORDER BY post_date DESC LIMIT 1

    WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list, references column 'merri_wrdp1.wp_posts.post_date' which is not in SELECT list; this is incompatible with DISTINCT]
    SELECT DISTINCT MONTH(post_date) AS month, YEAR(post_date) AS year FROM wp_posts WHERE post_date > '2007-02-01' AND MONTH( post_date ) != MONTH( '2007-02-01' ) AND post_status = 'publish' ORDER BY post_date ASC LIMIT 1

    February 2007
    M T W T F S S
         
     1234
    567891011
    12131415161718
    19202122232425
    262728  
    • 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-10-20 17:09: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