Everything I used to bore people on newsgroups and mailing lists with, now in one inconvenient place.
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.
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?
I upgraded my server from Fedora Core 4 to Fedora Core 5 using yum. After going through all the .rpmnew and .rpmsave files and fixing configuration files, most things are working. A couple of annoyances:
So far, knock wood, those are the only issues. The PostgreSQL one is, to me, indicative that the Fedora Core team don’t really care about preserving data. I haven’t tried, but I bet you anything the Debian people don’t just say “oh well, if you didn’t back up you’re screwed.”
I got a phone message asking if I was “Paul Tomblin, the Rochester blogger”, and if so, could I please call WHAM News. I phoned the number back, and it was somebody doing a story about a new law in New York that requires library and other public internet access sites to block access to MySpace and Facebook and other “social networking sites”, and they wanted a blogger to talk about whether private blog sites also would be affected by this law.
I know bugger all about this law, and while I’m usually willing to spout off about any subject any time, I didn’t really think I should be the one they talk to. Maybe if I didn’t think the story would interfere with tomorrow’s Pilots Picnic, I would have volunteered.
I decided to do the Ellison Park Shuttle again, this time without Vicki. The weather was perfect, and because of that there were a lot of people out. While I was waiting for the shuttle to leave, a large group left including a woman with a dog in her kayak. The dog had on a life jacket, which is just as well because they weren’t more than 20 feet from the dock when the dog decided to jump out, and the woman had no idea how to get the dog back in. By the time we left she was coming back to the dock with the dog swimming along side. I have no idea whether they got sorted out or not.
On the shuttle with me there were two tandem kayaks, two canoes with two people in them, and one other solo kayak, none of them looking very experienced. I helped the driver get them launched, and left after them. By the time I caught up to them (at the next bend), they were all over the river and pointing in random directions. Two women in one of the canoes rammed me as they spun around and flailed at the water, bringing back some bad memories from when I hurt my wrist last year. I hope they got settled down and pointing in the right direction eventually, because there were some snares later on.
I brought my GPS along as an experiment. The manual says it’s waterproof and floats so I thought that I’d be safe. The idea was to get a better idea of the real length of the course, and also the speed I maintain. But it was kind of a waste – during the twisty part at the top of the course, it kept losing signal, often for long stretches. So distance was even less accurate than my previous attempt using the Google Maps Pedometer.
The river was pretty high after the rain, and moving pretty fast. But the recent storms also left some traps for the unwary. There was a downed tree that blocked most of the river leaving a very fast passage along one side. And then not too much later just past Browncroft Avenue there was another tree that had fallen all the way across, but it’s actually not in the water but above it. There was a group coming upstream under it when I got there, and I was able to also duck under it in one part.
There wasn’t a lot of wildlife out today unless you count hordes of inexperienced paddlers. I saw kingfishers in the twisty wooded bit at the top, and some barn swallows under the bridges, and a few ducks, but that’s about it. I didn’t see the usual swans or geese.
Back at Baycreek, there were a couple of guys paddling around with Greenland paddles and kayaks. That looks like something I’d like to try out some time. I’ve heard they’re better on your elbows and shoulders.