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:50:41' 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





























A New Favorite: License to Grill

A few weeks ago, I was surfing channels on the tube and found a show called “License to Grill.” The show is on the Discovery Home Channel and is hosted by Rob Rainford.

I didn’t post about it previously, because I didn’t know whether I truly liked the show or not. At least not right away. It’s definitely grown on me. Rob Rainford hails from Canada, and his backyard plethora of grills makes a girl like me wanna go get more than one. He’s got an amazing outdoor kitchen, too. But who knew a guy from Canada could grill so good?

I haven’t found a show that I didn’t like at least one of the items he was cooking. Sometimes when you watch cooking shows you just *know* something doesn’t sound good. All of his grilled meals make my mouth water. And the other thing I like about his show is something that I equally like about Rachael Ray. I’ve learned a few tips and tricks from him (as I did from watching her show).

The one thing I need to do is 1) find some good wood chips here and 2) plan meals a bit better. He does a lot of dry rubs, marinades and smoking. I can’t seem to plan so far ahead, but he’s basically convinced me in a few short half hour shows that I should reconsider.

Check him out. He’s a bit quirky with a strange sense of humor (probably why I like the show!), and you’ll get jealous when you see his yard, his outdoor kitchen and his grills (hey…I did!), but you’ll drool and want to go invest in, like, 8 grills and a bunch of wood chips.

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

    August 2006
    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 20:50:41' 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