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 00:41: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





    • Design by





























The Canning Green Beans Experience

What, might you ask, has Merri been doing all day?

Well….this.

…and this.

Twenty pint jars of freshly grown green beans. All nicely packed and sealed into jars for the dead of winter. YUM!

Next on the canning list for summer? Tomatoes and catsup. The first is simple, the catsup is a 2-day job (and takes a LOT of tomatoes to do!). Is it worth it? My kids sure think so! :-)

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

7 Comments »
Jeff H said:

Why no pickled beets?



Merri said:

Well, no one in my house would eat them...so no sense canning them. ;)



Vinnie said:

Pickled beets are to our household what pork chops, with bacon wrapped hot dogs with a side of pork rinds are to Osama's household.

It's all about the haram.



ptg said:

One particularly nasty winter I had nothing to eat but pickled beets for several weeks. My wife had moved out, and I was too lazy to can anything. By February, beets were all that was left. It was grim. I don't have beets at home either.



Merri said:

I think that would have been the best diet I had ever had, PTG...in other words, I would have starved. :-D



ptg said:

I was ducking creditors from a failed business, and one of my cousins, who found himself in even more dire circumstances, had moved in with me. We ate them cold, hot, sugared, souped and mashed. My cousin found a place to get old bread, so we had beet sandwiches. There must have been 100 jars of them in the cellar. We didn't gain any weight.

I'll spare you the gastric distress we suffered and how it was made worse by the failure of the indoor plumbing. Don't eat red snow!



Chris said:

The green beans look great but PTG? Beets? Dayum......yuck.....gross. I'm with Merri, I'd have starved.



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

    December 2018
    M T W T F S S
         
     12
    3456789
    10111213141516
    17181920212223
    24252627282930
    31  
    • 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 00:41:01' 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