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 07:01:27' 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





























Ah….Vacation: Add Water, Sun and Fun!

I can smell it - vacation!  My last day of work was today - we leave Saturday for a week of fun involving a jet ski, a boat, some water tubes and tons of sunscreen!

I can hardly wait!  I can already feel the sunburn, the windburn and a tall cool one in my hand!

So far, I have the housewife from An American Housewife guest blogging (she has already put up a GREAT post - and a must read).  I also have Beth from MY Vast Right Wing Conspiracy signed up as well.  She promised to only post about virtuous things (yeah, right!). 

Update:  I’ve got a few new guest bloggers I’ve invited, and who have accepted!  Jane from Armies of Liberation,  Janette from Common Sense Runs Wild, E.M. Zanotti from The American Princess, Jody from Steal the Bandwagon and the ever wise, ever funny Preston Taylor Holmes from Six Meat Buffet, who has to hold his own amidst all of these fine women.  Good luck, Preston - watch out for the estrogen!

Thanks to everyone!  Knowing you all are here in da house I have no worries!  On to the fun and the sun!

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

    June 2005
    M T W T F S S
         
     12345
    6789101112
    13141516171819
    20212223242526
    27282930  
    • 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 07:01:27' 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