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-15 20:51:19' 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





























Stream-of-Bloggingious

A few random thoughts are going through my head and thought I’d throw them in a post.

Spring is here! We spent a nice part of the day raking (4 lawn bags just from the front yard!) and getting ready for the “big improvement.” Our back yard has sucked for quite some time. We recently had a tree removed and now we’re taking the plunge….new front deck and patio, new big patio in the back, actual *landscaping* and a new privacy fence. Needless to say our back yard looks like the badlands at the moment, but the improvements commence this week! And other than some scratches and burning nose (damn allergies), we had a nice outdoor day!

Easter is coming. Got the required eggs and dye. Woot! We’re ready to go!

The Sopranos is on tonight…and 24 is on tomorrow night. That likely means I won’t be blogging until Tuesday. Heh.

The man and I went out and had some adult time Saturday night. A great meal, and a couple of drinks. We didn’t know what this whole “dating” thing was all about so we picked up the kids and went home. ;-)

Hubby’s evil boss comes back tomorrow and my new boss is supposed to get us all in a room and tell us about the “great secret” he has been working on all week. I brace myself. Between wiping away my hubby’s tears (and hiding his guns) and spending hours and hours trying to figure out this new boss, I may not blog until *next* week. Between all of that and my extreme lack of creativity lately.

Saddam is bad, Osama is bad, murders, child abusers and molesters are all bad, too. The weather is good, except for those tornadoes in Tennessee, I was basically told today that I’m evil (along with a few of my friends) and I need to cook dinner. Wow….that was a bit streamy, wasn’t it?

Take care and see you all 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='462' 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-04-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-04-01' AND MONTH( post_date ) != MONTH( '2006-04-01' ) AND post_status = 'publish' ORDER BY post_date ASC LIMIT 1

    April 2006
    M T W T F S S
         
     12
    3456789
    10111213141516
    17181920212223
    24252627282930
    • 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-15 20:51:19' 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