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:21:45' 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





























November is…

It never fails to amaze me that the changing of the calendar brings with it new observances.  No, not talking about Thanksgiving, not talking about Veterans’ Day…I’m talking about the unusual observances that are assigned to each and every month of the year (and then every week of said month, and every day of said week).  Here’s what the month of November brings us:

  • National Fun with Fondue Month (um….no, ain’t gonna touch it!)
  • Georgia Pecan Month (hmmmm….won’t the pecans in other states feel discriminated against?)
  • National Peanut butter Lover’s Month (mmmm….peanut butter!)
  • National Impotency Month (eh….ain’t gonna touch that one either, although is it intended to celebrate impotency or make us aware of it?  Hmmmm….nope.  Ain’t gonna go there)

There are a few weekly and daily celebrations that I couldn’t pass up as well.  This week includes:

  • National Fig Week (YAY!  It’s National FIG week!)
  • Plan your Epitaph Day, Wednesday (I’m just not ready for that!)
  • National Men Make Dinner Day, Thursday (now THAT’s what I’m talkin’ about!)
  • National Sandwich Day, Thursday (hey…who decided to put SANDWICH day on the MEN MAKE DINNER DAY?  This should be National 7-course-gourmet-dinner-day!)
  • National Chicken Lady Day, Friday (whah?!?!?)
  • International Day for Preventing the Exploitation of the Environment in War and Armed Conflict, Sunday (okay, I put this one in for two reasons…1) it is the world’s longest title….how do you get this on a bumper sticker anyway? and 2) Read it again…yeesh!)

There you have it!  Be sure to mark your calendars and plan your celebrations and events for November!

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


The Cotillion - Portia Rediscovers Me!

So, we’ve been having a Cotillion each and every week, and I just haven’t been playing the past few weeks (for one reason or another…let’s leave it at "real life" getting in the way).  I did have a chance to get a post submitted this week, and it’s part of the great round up at Portia Rediscovered (you’ve just GOT to take a look at her new digs!).

As always, the post is also over at the Cotillion.  Many thanks to Portia for a great round up and to all of the fine ladies for many great posts!

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

    November 2005
    M T W T F S S
         
     123456
    78910111213
    14151617181920
    21222324252627
    282930  
    • 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:21:45' 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