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 < '2024-04-25 09:01:20' 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





























December 19th, 2005

Christmas Musings….Again!

To my regular readers (heck, to anyone who will read this…hehehehe),

It’s the week of Christmas.  I don’t have the gifts wrapped yet and haven’t bought a number of them as of yet.  I still have Christmas cards to send out (beats last year - I didn’t send one out!).  Work is crazy with year-end stuff, including a change in bosses and management styles (gotta train another one, darn it!).  There have been parties, school is out and things are generally crazy.  I still have 2 batches of cookies to bake, grocery shopping to do and all that jazz. 

Which leads me to my little corner of the web.  I’m probably not going to be around too much this week (at least through Christmas).  There are few things to me as important as Real Life, this blog included.  But when I see how excited the kids get about Christmas, writing posts about idiots, thugs and recipes doesn’t quite hold a candle.  BUT, I will definitely stop by a couple of times.  One big piece of news, I’m celebrating my 1 year blogiversary on Friday!  I can’t believe it’s been a year!  So much has happened, and I’m amazed I’ve lasted this long.  It’s all because I have people reading my random thoughts and posts.  If they weren’t, I’d have closed the doors a long time ago!

Take care, and everyone have a joyous, Merry Christmas!  See you around!

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

So said Merri | Musings of Merri | Comments & Trackbacks (1) | Link

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

    December 2005
    M T W T F S S
         
     1234
    567891011
    12131415161718
    19202122232425
    262728293031  

    • 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 < '2024-04-25 09:01:20' 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



    •