Archives for February 2009

WP_Posts database crashed – HELP!

February 28, 2009 by Tricia

I need some help fixing my husbands blog – Guitar Licks. Today when he visited the site (while I was still sleeping) the blog had error messages stating that the WP_posts database had crashed.

When you visit his site it loads with the WP theme and sidebars, but there’s error messages at the top and a “post cannot be found” message where current posts should be listed on the index page.

Some of the errors state:

ALTER TABLE wp_posts ADD FULLTEXT `yarpp_title` ( `post_title`)

ALTER TABLE wp_posts ADD FULLTEXT `yarpp_content` ( `post_content`)

So I’m assuming this error has something to do with the Yet another related post plugin that I’m using on most of my blogs. This blog is using the plugin version 2.16 and is using WP 2.62.

In the Yet another related posts plugin admin area there was a message that said:

YARPP’s “consider titles” and “consider bodies” relatedness criteria require your wp_posts table to use the MyISAM storage engine, but the table seems to be using the engine. These two options have been disabled.
To restore these features, please update your wp_posts table by executing the following SQL directive: ALTER TABLE `wp_posts` ENGINE = MyISAM; . No data will be erased by altering the table’s engine, although there are performance implications.
If, despite this check, you are sure that wp_posts is using the MyISAM engine, press this magic button:

I clicked on the “magic button” as the plugin seems to be working just fine in all of my other blogs and I ended up with even more errors!

Help!

I’ve looked at the WP database for this blog and the WP_posts table says “in use” and I can’t browse it. I also can’t use the backup plugin in Guitar licks – it’s there and functioning but just hung when I tried to do a back up.

I’ve backed up the whole database using PHPmyAdmin so I have a copy in case something goes terribley wrong. Now I just need to know how to fix it.

Should I just place a check mark on WP_posts and then click the repair function at the bottom of the structure screen in PHPmyAdmin and see if that repairs the problem?

I’m nervous about attempting to fix this as I’ve never had to try to repair a database error before. Any help would be appreciated.

Grilling in my kitchen

February 27, 2009 by Tricia

Earlier this evening, when Chris came home from work, I suggested to Chris that we get a Foreman Grill. I’d got a notice from a department store in our area that the G 2 EZ Broil grill was on sale.

We’ve been eating a lot of boneless Skinless chicken breasts lately and I’ve been getting kind of tired of baking them in the oven so I thought the grill might be a great addition to our kitchen appliances and I was fairly certain that I’d use it just about every day.

So when Chris got home from work I told him about the grill. I’d also looked up some reviews on that particular model to see how others liked it and it had good reviews, so we went out to the store to get one. We also stopped by a grocery store to pick up some salad making supplies and some hamburgers.

After getting the new grill out of the box and setting it up we grilled two hamburgers on it. man is that thing fast! Only five minutes and our burgers were done. Yummy!

Along with our hamburgers in Pita buns we had steamed veggies (carrots, broccoli and cauliflower) and I made a salad with baby mixed greens, grape tomatoes (none of the regular sized tomatoes were ripe enough in the store), cucumber, green pepper and a little feta cheese. We haven’t actually had a salad with our meals for quite a while so it was a very nice addition. Plus I made us each a big salad so it was filling too.

I already have some thawed chicken breasts in the fridge, so tomorrow we’ll have grilled chicken. Sunday perhaps we’ll have some of the Sole Fillets I bought last weekend. Hopefully everything cooks nicely on the grill!

Now if only I’d remembered to look for compact flash cards while we were in the store earlier I’d be set. I need a new one for my camera. Oh well … we still have the rest of the weekend.

A lovely day for a walk

February 26, 2009 by Tricia

Midnight, my Labrador Retriever, and I took advantage of the nice weather earlier today and took a long long walk.

We were supposed to have a warmer than normal day that was filled with snow, rain and then showers, but to my surprise we didn’t get the bad weather – only the nice warmer than average temperatures. Not that 6 Celsius (42 F) is all that warm, but for February, especially after a very cold January, it sure felt nice … Spring-like even.

I haven’t been walking Midnight as often as I should since I haven’t been feeling all that well the last several months. Oh, Chris walks her – usually twice a day, but if I can walk her at least once a day as well all the better for her. It makes our evenings much more peaceful if we have a well exercised and tired dog!

For my own sake I should be out walking her every day as well! It’s good exercise and Midnight tends to pull on the leash (although she’s getting a little better and not dragging us around as much lately) so it’s a fast paced walk if I want to keep up with her!

We walked for 45 minutes this afternoon and then when Chris came home from work we all took another 35 minute walk.

Midnights still up and begging for a rawhide chew, but I expect that she’ll be tired out and want to sleep soon …

I took this photo a few weeks ago when Midnight was napping on her favorite chair … I don’t think she liked being woken up to a camera in her face.

So … fellow dog owners, do you walk your dog several times a day or have a yard that your dog can get burn some of it’s excess energy off in?

Cold or allergies?

February 24, 2009 by Tricia

Sniffle, sniffle, sniffle … cough, cough … That’s what my days been like. I think I might either be coming down with a cold or else my sniffles and coughing are remnants of the allergic reaction I had on Saturday night thanks to the shrimp that I ate. I’m still patting my self on the back for that great addition to our meal (NOT).

I still have some hives on my face and neck, and I noticed today that the area above and below my eyebrows is a little puffy and red … kind of like I just plucked my eyebrows.

So as I said I’m not sure whether I’m getting a cold or it’s still my allergic reaction that’s making me feel yucky today. Either way, I think that by the time Chris comes home tonight he’s going to find me curled up in our new Sferra sheets that I just put on our bed. All warm and cozy and trying to recover from whatever my body has decided to do to me today.

Hmmm maybe I’ll make myself a hot Toddy later … yeah that will make my raw throat feel better and make me sleepy too.

I hope that you guys are having a better day than I am!

I’m tired of freezing when I go to bed

February 22, 2009 by Tricia

I’m starting to get sick and tired of our bedroom being freezing cold when I go to bed. Our master bedroom is the coldest room in the house in the winter. Changing into my PJ’s each night is quite the experience as I end up covered in goose-pimples! LOL

We live in an older house. It was build in 1927 and as a result it’s probably not quite as warm as newer homes. Our bedroom is upstairs at the end of a long hallway so that likely makes it harder for the cold air that builds up in the room to escape. Remember cold air goes down (as in down a staircase) and warm air goes upward.

When we moved in we had some duct work done including adding a cold air vent in the master bedroom. I’m sure this has helped to make the room warmer than it would have been without the cold air return vent, but it’s still pretty darn cold in the dead of winter.

We did have an electric heater that we’d use in the bedroom for the first hour or so after we went to bed, but it stopped working in early December and we haven’t replaced it yet. After suffering through a very cold January (February has been warmer here, but it will get colder soon) I think it’s time to buy a new heater.

I’m going to watch for an electric heater to go on sale and hope that I can get one for a good price soon.

Our last electric heater was a tall standing one that oscillated to move the warm air around the room, but I’ve been look at this Honeywell Cool Touch heater and it looks like it might fit the bill. The description says it will heat a large living space so it might be too powerful for our small master bedroom.

What we’d normally do with our old electric heater would be to turn it on when we’d come upstairs to use the washroom and wash up before bed so that it would take a bit of the chill out of the room before we’d have to go in there to get changed. It also had a timer on it so we could set it to run for only an hour or so. That would ensure that the room was warm as we were trying to fall asleep, but we usually didn’t need it to run all night. Not once the bed was warmed up anyway.

Do you find the the upstairs of your house is a lot cooler in the winter than the rest of your home? Do you use a heater in your bedroom or do you just suffer the cold?

WP_Posts database crashed – HELP!

Grilling in my kitchen

A lovely day for a walk

Cold or allergies?

I’m tired of freezing when I go to bed

Meta

Search this site

Blogs I Visit

Archives for February 2009

Meta

Search this site

Tags

Blogs I Visit