Break in

While I was mowing the grass on Saturday, I managed to notice that both the passenger side doors on Laura’s car were unlocked, and the front one was actually ajar. Since both Laura and Stevie were known to not lock their doors when they were passenger’s in Vicki’s or my cars (in much the same manner that fish are known to like to swim in water), I assumed that she or her friends had just been careless the night before. I somehow managed to miss noticing that the back window was smashed. Somebody evidently broke into her car and found nothing worth stealing.

I guess I should probably stop leaving my GPS, digital camera, film camera, kayak paddle, and flight bag with 3 expensive headsets, portable transciever and my worthless but irreplaceable log book in the trunk of the car any more. Not sure about the XM radio – yeah, it’s supposedly portable but that would be such a hassle to drag in and out of the car every night. The CDs can probably stay – they’ve all been ripped to MP3 anyway, and besides they’re all obscure crap that nobody would steal.

Back when I worked for GeoVision we had a tradition in the winter that the night of the full moon, we’d go cross country skiing in the dark up to one of the lodges there, cook some dinner, hang out for a while, then ski home. It was extremely cool. One day at work, the day after one of these ski trips, I noticed that there was no money in my wallet. No matter, I thougth, I’ll just head over to the Toronto Dominion next door. But somebody else who had been skiing with us asked if my car had been broken into last night. I said I didn’t think so, so they asked me if there was any money in my wallet. They suggest that I go down to my car and look for a small hole beside the keyhole. Sure enough, there was one. Evidently somebody had gone around to all the cars, punched a hole in the door panel near the keyhole and opened the door somehow, and stolen any money he could find in the car, but only money.

The next full moon came, and this time I decided to be one step up on the theif. I put my wallet in my bum bag so it would come with me when I went skiing, and left the doors unlocked so I wouldn’t get another hole in my door. However, I stopped for gas on the way to the parking area, and so my wallet made its way from my bum bag to my work pants, so didn’t come with me on the ski. I came back to find my wallet had been emptied once again. Buggeration.

Ok, that was getting ridiculous

After getting that error on the pt_comments table again, I went into mysql and tried a

check table pt_comments;

and it found an error, so then I did a

repair table pt_comments;

and it said it repaired it, but another

check table pt_comments;

found the same damn error again. So I shut off the web server (so I wasn’t getting hit with comment spams) and did a backup and restore of the entire mysql database, and the problem seems to be gone. For now. Maybe. We’ll see.

I don’t think MySQL liked the upgrade very much

Every time I go into my WordPress SpamKarma page, I get the following error:

Failed to purge comment spam entries.
Query: DELETE `pt_comments`, `pt_sk2_spams` FROM `pt_comments` LEFT JOIN `pt_sk2_spams` ON `pt_sk2_spams`.`comment_ID` = `pt_comments`.`comment_ID` WHERE (`pt_comments`.`comment_approved` = ‘0’ OR `pt_comments`.`comment_approved` = ‘spam’) AND `pt_comments`.`comment_date_gmt` < DATE_SUB('2006-08-14 11:36:26', INTERVAL 2 HOUR) SQL error: Incorrect key file for table './wordpress/pt_comments.MYI'; try to repair it

So then I go into mysql, do a “repair table pt_comments”, and repeat the purge operation and it’s fine. But some hours later, when I go back to the page, I get the same error. How do I repair this damn table so it stays repaired? Would doing a full mysqldump and restore fix it?