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





























Sweet Pie Pastry Recipe

This pie crust is AWESOME for fresh strawberry pie, or for a multitude of other pie recipes that contain sweet filling (apple, pumpkin, etc.). This recipe will make a top and bottom crust.

Ingredients

2 1/2 cups all purpose flour
3/4 c + 2 tbsp butter, chop into very small pieces
1/4 c + 3 tbsp granulated sugar
1 large egg

Instructions

Cut butter into flour with fork or pastry cutter. Lightly mix in sugar and egg to get smooth dough. Put ball of dough into plastic wrap and chill in the fridge for 2 hours.

You will want to follow the pie recipe’s instructions for baking time/temp. If you are blind baking (baking the pie with no filling) you will want to preheat your oven to 425 degrees (put a cookie sheet in while preheating). Place the rolled out dough into the pie pan. You will want to add a piece of parchment paper and pie weights (I use a bag of kidney beans and fill it approximately 1/3 of the way up). Bake for 20 minutes. When done, remove crust from the oven, pull weights and parchment paper out of the pie shell. Prick the pie all over the bottom and the sides with a fork. Bake an additional 5-10 minutes, or until pale golden brown. Cool before filling.

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


It’s Berry Pie Time!

I love this time of year! One of my absolute favorite fruits is the strawberry, and they are now in season - and awesome!

Ingredients

1 baked pie shell (I recommend a sweet pie pastry - I will post this recipe as well!)
1/2 quart fresh slice strawberries (I used two plastic containers full)
1 cup sugar
1 cup boiling water
3 1/2 tbsp corn starch
4 tbsp strawberry Jello

Instructions

Place strawberries in the pie shell. Mix sugar, water, corn starch and jello over low heat until it boils. Remove mixture from heat and cool 15 - 20 minutes. Pour mixture over berries and chill 4 - 6 hours.

I serve it with a spoon (or two!) of Cool Whip. YUMMMMMMMY!

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


Carnival of the Recipes #40

Please be sure to visit this week’s host of Carnival of the Recipes, Jordana at Curmudgeonry

My recipe for Stuffed Steak is out in the carnival.

This shameless plug brought to you by Merri @ Merri Musings.  Have a great day! 

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

    May 2005
    M T W T F S S
         
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  
    • 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 16:21:44' 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