Well, I’ve been spending some time deleting spam comments from this blog, which have piled up over the last year. I was doing it 20 at a time from the admin area, then I edited the .php file and told it to show me 500 at a time and did a few that way. Then I just went into the database and found the date of the last real comment, looked at the ID of that, and mass-deleted all comments newer than that comment. I’d already deleted a couple thousand manually at least, but the automatic cleanup deleted another 11,839 comments!!
There shouldn’t be a single spam comment left now, but they keep trying to post more ever minute or less so some will probably get through even though I have a ton blacklisted. I’m working on upgrading to WordPress 2.0.3 (this is 1.2.1) and we’ll see if it has better anti-spam built in. If not, I’m going to implement a Captcha solution where you type a number from an image to post a comment and see if that stops the spam, but it will be stopped, someway, somehow!
I’ll probably be doing the upgrade over the next few days, not sure when specifically (have in-laws coming over tonight though Tuesday), but this site will probably go down for a while while I complete the upgrade. Don’t worry…I’ll be back!! :-)
Married life is good, by the way…since I haven’t posted since my marriage announcement :-)