closecomments

Yesterday I returned from spending the day with family to discover that I had been slammed with almost 350 comment spams from the same porn site.

Yesterday I returned from spending the day with family to discover that I had been slammed with almost 350 comment spams from the same porn site. Thankfully it was a quick fix. One entry into MT-Blacklist and I could delete the comments and rebuild the entries in just a few clicks. However, it was still frustrating to have to do this in the first place.

Last week, I discovered another MovableType plugin called CloseComments. You can set this to run everytime you re-build your main index, and it will close comments of older, inactive posts, depending on the variables you choose. I have mine set to close comments on posts older than 15 days and have been inactive for at least one day. I couldn’t get this to work at first, and last night gave me the motivation to figure it out.

The reason why it wasn’t working was that the database behind this blog was in the Berkeley DB format, and not the required SQL format. I didn’t know that there was an easy way to convert them until I did a few Google searches. I did the conversion process last night and in a few days, CloseComments should be doing its thing. Combine this with MT-Blacklist, and you’ll end up with very little comment spam.

Update 7/6/04: Make sure to check MT-Blacklist after the conversion process. I discovered this morning that my blacklist settings had been reset.