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 15:43:40' 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





























What a Day!

Life has given me the royal finger today, I think.  Do you ever have one of those days that bad thing after bad thing happens and you just want to crawl under your rock until tomorrow?  Hello!  Today was my day!  My son has pneumonia (luckily caught early enough he didn’t get full blown illness and it is treatable with antibiotics!), a co-worker’s twin brother passed away (and way too young, I might add), I had to go to the doctor because of some pain I’m having and now have to have some more tests tomorrow, and so on, and so forth.  </whining>

I know there’s lots out in the news, so please visit my blogroll and read some newsworthy stuff.  I ain’t so newsworthy today.  BUT…as I tend to have an opinion on everything, I will point out a few things. 

I have to say that Cindy Sheehan is an idiot.  She doesn’t KNOW the meaning of the words "roughed up."  I had one tiny pin-head of sympathy for her - I mean, after all she did lose a child.  But she’s gone too far and I’m sick of hearing about her being a "Peace Activist."  She needs to shut the hell up and go home and get on with her life.  She’s even an embarassment to her peace-nik peers.  Sheesh.

Stoopid Hurricane Rita should get the hell away from the gulf!

…and my hubby should quit blogging about hairy, pasty men mowing lawns without shirts and with their man boobs hanging out (okay, logic tells me he should pay me back since I made him watch the men on Biggest Loser II taking off their shirts during weigh in - oh, and during dinner…sorry Honey!)! 

Anyway, like I said - there’s much talent and entertainment on my blogrolls - please stop over at their sites and tell them I said "Hi!"

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


Cotillion - Ladies Mas Fine!

It’s that day of the week again!  Please stop by the Cotillion and check out what the best female bloggers in the ’sphere have to say (certainly more than me lately!!!).  Thanks bunches to our hostesses this week:  Crystal Clear, Fistful of Fortnights, Soldiers’ Angel - Holly Aho and Knowledge Is Power - SondraK.com.

Update:  It appears that my post was missed in all the melee - all is good though.  You can read it here

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

    September 2005
    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-19 15:43:41' 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