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-19 08:12:25' 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





























A Proud Moment

I have been officially banned from the MLive Grand Rapids Forum: http://www.mlive.com/forums/grandrapids/index.ssf

I had been posting under the name given to me by Merri’s husband, the Stroosinator. I fit in pretty well amongst the numerous liberals, and I held my own with them. I believe they respected me for that!

But it wasn’t my political comments that got me canned for a day. Nor was it filthy language, which I would not use on that Forum (TOA).

Nope it was my three posts regarding Rosie O’Donnell (of all things). I simply stated that her FAT mouth finally did her in. (She’s no longer with The View as of June). After my first post was deleted, I posted again. And then a third time. Shame on me for being so insensitive (not like Rosie herself at the Ladies Awards Dinner where “Eat me”, and “F this, F that” was spewed forth with young adult women in the crowd)

Somebody there at the forum surely loves Rosie, but not me.

That’s fine. I’ll do my time in the slammer. But like most hardened criminals, I feel I’ll be back with a vengence.

Or my name isn’t STROOSINATOR!

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='684' 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-04-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-04-01' AND MONTH( post_date ) != MONTH( '2007-04-01' ) AND post_status = 'publish' ORDER BY post_date ASC LIMIT 1

    April 2007
    M T W T F S S
         
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    30  
    • 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-19 08:12:26' 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