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 < '2018-12-18 06:12:05' 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





























Meme Tag - Music!

LindaSoG over at Something…and Half of Something tagged me for a meme that’s all about music:

Total volume of music files on my computer:

511 MB (okay, so I still listen to lots of CD’s - but I’m getting my iPod loaded slowly but surely!

The last CD I bought was:

Soundtrack to "Madagascar."  The kids love the "We Got to Move It" track (and yes, there are Kids Bop CDs in my truck!  ACK!)

Last aquired:

A whole bunch of 80s songs (Blondie, songs from "The Wedding Singer" and much, much more!)

Five songs I listen to a lot, or that mean a lot to me (eclectic, I know):

"Out Here on My Own" - Irene Cara (from the movie Fame)

"Nothing Else Matters" - Metallica

"Break Stuff" - Limp Bizkit (a great song for the drive home from work!)

"Island of Life" - Kitaro with Jon Anderson

"Eyes Wide Open" - Creed

I have to add that I love 80s music (born and raised child of the 80s).  I have tons of 80s music!

Four people to whom I’m passing the baton (if they so desire to take it):

Beth at MY Vast Right Wing Conspiracy

The ‘wife at An American Housewife

Tammy at A Mom and Her Blog

Raven at And Rightly So!

These are merely some shameless linking to some of my favorite sites (and ladies, you don’t have to do anything if you don’t want to).  Wheeeeeeeee!

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


We’re Havin’ a Ball!

It’s party time again!  Please go visit us over at the Cotillion - and bring your dancin’ shoes! Er, seems as that’s too, well, nice.

As Beth might say:  Report at once to the mistresses (for your whippings?):

Crystal Clear
A Mom and Her Blog
Fistful of Fortnights

And don’t forget to stop over at the Cotillion website.  We have many new debutantes who have joined us - the party is even more exciting!

Update:  Beth…better?  I’m no chicken, dammit!

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


Bonfire of the Vanities

So - I couldn’t help but nominate myself for an entry in the Bonfire of the Vanities….Dirty Minute Meals is making history!  Check it out here and here and here!  Oh, and here, too!

Weeeeeeee!  Let the fun begin!

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='213' 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 < '2018-12-18 06:12:05' 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