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-12 11:02:11' 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





























Sunday’s Ramblings

I always sit on a Sunday night and dread the proverbial Monday. Tonight is no different - other than the fact that I had a great weekend. Here’s what is flying around in my head…

It was good having a weekend off with the hubby. We don’t always see much of one another, and I really enjoyed being with him!

I had a stupid CT scan on Friday to see if I have kidney stones. I am supposed to find out tomorrow. Keep your fingers crossed! If they are there, perhaps they are only small ones!

We took full advantage of our new backyard Saturday night - and my new smoothie maker (yes, it does make alcohol-laden fruity drinks…just the way I like it!). We grilled great steaks, had potatoes on the grill, corn on the cob and smores by the fire pit. We were in heaven!

We started adding color to the yard today, with a full host of bushes, flowers and plants added to our ever improving landscape. It was so nice planting some living things and beautifying our yard! It will only get better!

We grilled burgers tonight…even though it was cloudy and in the low 60s, we couldn’t help but sit out on the patio and eat dinner. Did I tell you that we love our new yard? HA!

Hubby picked out some pepper plants to grow - only one isn’t hot (my red bell peppers…yum!). The rest…wow…all I gotta say is that I need to pick up some Tums! :-)

Lastly, I do dread going into work tomorrow. I work for a great company, don’t get me wrong, but I just don’t want the weekend to end. But there’s light at the end of the tunnel. I will be off work for a month in less than a month now! The kids are out of school soon and we’re going to have plenty of time to play!

Tomorrow night is Bauer night! I can’t believe the final show of the season is coming this month (whahhhhhhhh!)!!! I LOVE MONDAYS!

Anyway….blah blah blah. I just had to ramble on for a bit…now I feel normal again! BWHAHAH!

UPDATE: So, according to my CT scan, I don’t have kidney stones and everything appeared to be normal. So why is it that my kidneys hurt now? I’m sure it’s psychological. Time will tell! :-)

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

    May 2006
    M T W T F S S
         
    1234567
    891011121314
    15161718192021
    22232425262728
    293031  
    • 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-12 11:02:11' 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