WordPress database error: [Got error 28 from storage engine]
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (119) ORDER BY t.name ASC

wordlog.com » Delete Comment Spam Automatically

A weblog authored by Carthik about the latest in the WordPress world.

Friday, September 24, 2004

Delete Comment Spam Automatically

Filed under: Uncategorized — Carthik @ 1:04 pm

I use thunderbird for reading my email. Most of the moderation notification, or even comment notifications for new comments which are spam are marked correctly as spam by the spamassassin on my mail server, and as junk mail by my Thunderbird.

Just this morning I was thinking of how neat it would be if I could use SpamAssassin, or something like Thunderbird’s Junk Mail Filter to deal with comment spam on my blogs.

Looks like someone’s heard my prayer after all. Mark releases the Three Strikes Plugin and explains the rationale behind it :

This plugin is designed to prevent comment spam from even hitting your system and leaving you with a flood of approval requests and a bunch of comments to be deleted. While dealing with some moderated comments on my system, I started to realize that most of the REAL Spam could easily be categorized as delete fodder by a “fuzzy” points system. In toying with the idea and testing the various scenarios, I have put together a plugin that keeps tracks of the “strikes” of a comment and then prevents the comment from ever getting into your database and making more work for you.

Kind of like how SpamAssassin assigns scores. Very neat, and of course, if I know Mark well enough, he won’t stop here – he’ll make it a lot better, if need be. I can see how a whitelist with trusted IPs, URLs and authors can be a useful addition.

The best spam filter would be one that makes sure you never get to see the spam, or know that someone spammed you, so you don’t waste any time dealing with spam.


  1. [...] ighted high can be prevented from ever hitting your site at all (even for moderation) [via wordlog] Import Blogger posts to Wordpress A tutorial by BlueChronicles [via wordlog] [...]

    Pingback by scriptygoddess — 9/25/2004 @ 2:49 am

  2. [...] 11:51 pm

    Damn. So, answering my call for convenience from the other day, via Wordlog, comes the plugin that I’ve been looking for: the Three Strikes plugin [...]

    Pingback by Team Murder » Thank You Tony, Mark, And MooKitty. — 9/27/2004 @ 5:52 am

  3. I use this hack for wpblacklist, and I don’t see most of the spam, as it is blocked before it ever gets to me. It works very well, and you can still use wpblacklist’s interface to update the blacklist.

    Comment by Kerim Friedman — 9/24/2004 @ 8:11 pm

  4. I tried to use the Three Strikes Plugin for spam..but for some reason when someone tries to submit a comment on my website..it gets redirected to http://www.fbi.gov page. so i had to deactivate the plugin….i think there is a bug in it.

    Comment by Poonam — 10/31/2004 @ 7:16 am

RSS feed for comments on this post.

Sorry, the comment form is closed at this time.


Powered by WordPress

eXTReMe Tracker