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 21:31:16' 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





























Hmmm…should I get a guest blogger for the guest blogger?

Some friends invited my daughter and I to go to St. Augustine for the weekend. So I’m leaving later this afternoon to go camping. Yes. Camping. In a tent. If you knew me, you would know to begin hysterical laughing right now… okay, enough already (I am not made of steel! sniff!).

I have my suspicions that they only invited me to go with them for purely comedy relief. You know the camping trip at the end of the Parent Trap movie (the good one, not the Lindsey Lohan one)? Where they take the witchy wannabe stepmom with them on their trip and she’s so clueless about outdoor life that she’ll believe anything they say? Yeah well that’s me minus the witchy wannabe stepmom part. Those FIVE years in Girl Scouts did nothing for me.

The funniest thing? I am going to take my three and half year old terror. When I told her we were going camping. Her big blue eyes widened and she smiled real big and said, “Yay! Camping! … What’s that?” (Yeah, that’s my girl.)

Who knows though? Ya’ll might not be done with me yet (so stop being relieved!). I might post something on Monday… if you’re lucky!

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

2 Comments »
Beth said:

:razz:
OK, I'll be here. But AUGHHH! Weekend blogging! I'm having a hard enough time getting anything on my own crappy site!



mithglin said:

I can relate to the three year old terror thing. My daughter (through the grace of God) has survived to the ripe old age of 4. I told her that we were going to visit family in NC. All I heard for the two weeks before our trip was "Are we going to Nort Cantolina after dinner (lunch, nap, now) Fortunatly for me, now that we are on the road there hasn't been any "Are we there yet" garbage.



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.

Back To Main


    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-15 21:31:17' 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