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:14:59' 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





    • Design by





























24….the Reason for Heart Problems

Soooo….the most important thing to say here is that my HUBBY FELL ASLEEP ON BAUER NIGHT! Oh, and the second most important thing to say is that I can’t wait to get to work tomorrow so I can TALK to someone about this episode. ARRRRGHHHHHHHHHHH!

So….not to spoil anything should hubby hop over to my blog, but I do have a couple of things I *have* to say….

I TRULY hate that weasel Homeland Security Guy…who does he think he is?

…and Audrey…..whaaaaah? …and Chloe….yeah! …and Bill. Well, and Bill….

…and Jack…and Wayne….and ole Red….oh, and the VEEP….and that one girl….and…..DAYUM!

GAH….I give up. I’m going to go count cracks on the ceiling as I *try* to get to sleep without TALKING about this episode! GAHHHHHHHHHHHHHH!

UPDATE: Whew, so hubby watched the episode tonight (Tuesday). Thank GOD! I watched it with him (so what…Jack would *demand* I watch it twice, right?) - mostly so I could watch his reaction at the end. “WTF? Logan???” (okay, something like that…maybe not exactly, but close).

All I gotta say is that next week will be a good one, I’m sure of it!

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

1 Comment »
Ith said:

My reaction: ARGH!!!!!!!!!!!!!!!!!!! I hate them!!



Leave a Comment!

:mrgreen: :neutral: :twisted: :arrow: :shock: :smile: :???: :cool: :evil: :grin: :idea: :oops: :razz: :roll: :wink: :cry: :eek: :lol: :mad: :sad: :!: :?:

Please note: Comments may be moderated. It may take a while for them to show on the page.


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

    January 2019
    M T W T F S S
         
     123456
    78910111213
    14151617181920
    21222324252627
    28293031  
    • 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:15:00' 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