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-20 12:51:54' 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





























Hmmm…should I get a guest blogger for the guest blogger?

Some friends invited my daughter and I to go to St. Augustine for the weekend. So I’m leaving later this afternoon to go camping. Yes. Camping. In a tent. If you knew me, you would know to begin hysterical laughing right now… okay, enough already (I am not made of steel! sniff!).

I have my suspicions that they only invited me to go with them for purely comedy relief. You know the camping trip at the end of the Parent Trap movie (the good one, not the Lindsey Lohan one)? Where they take the witchy wannabe stepmom with them on their trip and she’s so clueless about outdoor life that she’ll believe anything they say? Yeah well that’s me minus the witchy wannabe stepmom part. Those FIVE years in Girl Scouts did nothing for me.

The funniest thing? I am going to take my three and half year old terror. When I told her we were going camping. Her big blue eyes widened and she smiled real big and said, “Yay! Camping! … What’s that?” (Yeah, that’s my girl.)

Who knows though? Ya’ll might not be done with me yet (so stop being relieved!). I might post something on Monday… if you’re lucky!

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


If you’re going to do a hunger strike…

Do it right! I’m sure you’ll all be relieved to know that Saddam Hussein has ended his hunger strike… after one meal. Turns out he just didn’t like the fish. Yes I am sure you were like me, waiting on pins and needles to see how long his strike would last. Would he make it for a week? Two weeks? Would he last a month?

Honestly the tension of thing was really getting too much for me.

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

    June 2006
    M T W T F S S
         
     1234
    567891011
    12131415161718
    19202122232425
    2627282930  
    • 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-20 12:51:54' 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