« What Government and Content Have in Common via WikiLeaks | Alex Halderman's DC Council Testimony » |
Bulk Deletion of Spam Comments...
system, blogging, hacks, chilling effects, educationApologies for the silence here... I've been busy and mostly posting short thoughts and such on Twitter.
The comment spammers seem to love a few of my posts... and moderating all the comment spam is a bit of a pain. Frankly, here's what I've been doing lately:
- Check my email for comment moderation emails from my blog software, quickly look through them to see if any are seriously humans with something to say. Moderate those as published.
About once a month, issue the following SQL command on the database (through phpMyAdmin... note that your table name is probably different from mine as I made mine up):
DELETE FROM `b2evo_blog_db`.`evo_comments` WHERE `evo_comments`.`comment_status` = "draft";
- This drops all the rows in the db where the comment isn't yet moderated (
published
).