So after updating the software, I thought I’d go through and just remove some of the bogus Trackback entries that .Text apperars to be dropping in my comments lately. So I pull up a query of comments and start deleting entries. Then I start getting an error about “the row has already been deleted.” Huh? Oh, yeah, my query included a join into the table of blog entries, so when I deleted the comment, I deleted the entry it was commenting on! Which cascaded into the comments table, etc.
The worst part? This is the second time I’ve done something stupid like this.
Thankfully, I have regular backups and everything appears to be restored. But this is definitely one of those “learn it the hard way” kind of things…
That reminds me… I should schedule a regular backup. 🙂