Joe Pietruch's Blog

I just did the whole Askimet SPAM filter thing. I kinda feel behind the times on a lot of things, SPAM detection being one of them.

I let my moderating go for a little over 3 weeks, and come back to find 8429 comments in moderation. That’s fine with me, because none of them made it to my visible pages. It was not fine, however, because that many posts cannot be edited all at once (the page times out before they are all loaded, and the moderate button is at the BOTTOM! of the page), nor is it desirable to go through them 20 at a time.

Fortunately I’m a New Media student, and New Media students know MySQL. I went in to my database and removed all comments received since the last time I moderated. It took about 3 seconds.

Askimet requires comment-makers register. On your first comment I approve or deny you, which affects how your subsequent comments are handled.

I apologize if you had made a legitimate comment during the last 3 weeks. Your comment was a casualty of SPAM. The future is brighter, though. (spam Spam SPAM spammity SPAM Spam spam spam *operatically* Lovely Spam! Wonderful Spam… )