Today, my blog took it’s possession to a whole new level. I’ve already written about how my blog is possessed & seems to kill any desktop publishing application. However, the last two days I’ve been noticing that I’ve been getting a lot of comments on a post called #. I do not have a post called #. So I logged into wordpress & got this error “Can’t open file: ‘wp_comments.MYI’. (errno: 144)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_approved = ’spam’”.

I had a moment where I thought, “But I didn’t touch my blog, I promise”. It was the same feeling I had when I was in a store & a very ugly, very expensive garden cupid fell off the shelf behind me. I didn’t touch it, I swear. This was followed by a lot of “My blog is broken, my blog is broken panic”. Again, this was followed by, “I didn’t do anything, why did it just break?” Then I tried to reconcile myself to a life without this blog, which included me becoming a goat herder in Malaysia. Basically, I went through every step of grief.

After looking around, I found out that apparently Matt Cutts had the same problem on his blog in January, so at least I’m in good company. I then found an easy solution that had me repairing the wp_comments table in MYSQL. I’m afraid of MYSQL. I always feel like I’ve just walked into a new job & they have me perform brain surgery on the first day. I mean, I could really mess things up in there. However, it worked. If you commented on the post #, or at all in the last two days, I’m really sorry, my blog ate it. Today’s lesson was that I need to not freak out so much. Everything is fixable, one way or the other.

Technorati : blogging, make money blogging, mysql, technology, wordpress

This entry was posted on Wednesday, July 18th, 2007 at 7:20 am and is filed under Home Business. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.