WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'ros_wp.ros_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 ros_wp_posts WHERE post_date < '2024-03-29 07:28:10' 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

September 13, 2006

Filed under: Uncategorized — ros @ 5:03 pm

Well, I recovered all the posts but it seems like loads of the comments have gone for good. Ditto several recipes. Some I can do again, like the bolognese, but some I just don’t remember. This is all very sad. :cry:  

I know it is a long shot but if anyone has saved the recent recipes please let me know. It would be so good to have them back!

The good news is that this will never happen again. The site will be moved onto Andy’s server which will have three backups made daily.

I still have a lot of work to do to make the site look right. The template needs rewriting and a lot of photos are missing. I also still havea small backlog of posts to put up and recipes to copy and paste accross. For now I’ll leave you with what I had for dinner last night….

stilton stuffed steak

stilton stuffed sirloin with port and cranberry sauce and mashed potato. If you look very carefully you can see the stuffing. This worked well as cooking and resting the steak provided just enough heat for the stilton to soften but not melt completely. So it was warm and gooey but didn’t leak out everywhere.  I may not bother with a recipe for this, it all depends how long it takes to recover everything else.

2 Comments »

  1. Hi Ros,
    After your post on the mb just wanted to check your website/blog and see how you’re doing, so I’m glad to see a lot of it is back! BTW it’s v. interesting! And you have great and unusual taste/recipes! Now if I could just get my hands on some Kangaroo …. oh well, I’ll just have to make do with elk!! Warm regards, Odette

    Comment by Odette (AZCook) — September 14, 2006 @ 1:05 am

  2. Thanks for your support, Odette. :)

    If you post here again, why not link to your site? It would be good to see it!

    Comment by ros — September 14, 2006 @ 5:30 pm

RSS feed for comments on this post. TrackBack URI

Leave a comment

In the aid of defeating SPAM Comments, please follow these instructions: