Warning: PDOStatement::execute() [pdostatement.execute]: SQLSTATE[HY000]: General error: 145 Table './skippy_skippy/h_sessions' is marked as crashed and should be repaired in system/classes/databaseconnection.php line 269
skippy dot net

Non-Numeric Names feed icon

The only anti-spam software I use on my blog is Bad Behavior. That plus comment moderation has been sufficient for me for quite some time. I have qualms about both akismet and Spam Karma 2, and as such prefer not to use them.

Since upgrading to WordPress 2.0, I've been suffering a significant increase in the number of spam comments sitting in my moderaiton queue. I sent my Bad Behavior log off to io_error, who confirmed that they were all manually entered, and as such slip past his plugin. Most of the spam comments have Asian text in the body, and a lot of them link to .cn domains. So my first line of defense was to add .cn to my list of forbidden words (with the unfortunate side effect that no one with a blog in China can comment here, for the time being). That didn't really do much to help, though.

Looking through the spam comments, almost all of them have an all-numeric username supplied. So I cooked up Non-Numeroc Names, a plugin which will flag as spam any comment submitted with an all-numeric username. So far, so good: all of the spam has been flagged as such, and diverted from my moderation queue!

Chris' Spam Nuker plugin makes it possible to retreive any legitimate comments that may have been misclassified. After that, you can eliminate all the spam from your database with a single click of the mouse!


  • Michael Hampton
    Now cook up a spell chekor. :)
  • Chris J. Davis
    Very nice, this is a welcome addition to the spam fighting war. Thank a lot Skippy.
  • skippy
    Spell checking is highly overrated, Michael! ;)
  • Chris D.
    Curious as to why you don't like spam karma 2? I just had to install this last week as I was getting spam bombed all of a sudden (50-80 spam posts a night).
  • skippy
    Chris D.: It's hard to articulate. I admit that I've never used SK2, so it's certainly not any specific technical or operational consideration. To date I've been fortunate enough to not need anything more than Bad Behavior and my moderation queue; and as such I'm leery of more complex, heavy-weight solutions.
  • Matt
    Those Chinese spam were actually one of the reasons I started Akismet, I get a TON of them on my blog, and they're very hard to target since I don't speak Chinese. Akismet catches them almost all the time, but one sneaks through every couple of weeks or so.
  • mufasa
    Just learn to spell :P

About | Policies | skippy.net

Warning: PDOStatement::execute() [pdostatement.execute]: SQLSTATE[HY000]: General error: 145 Table './skippy_skippy/h_sessions' is marked as crashed and should be repaired in system/classes/databaseconnection.php line 269
Warning: PDOStatement::execute() [pdostatement.execute]: SQLSTATE[HY000]: General error: 145 Table './skippy_skippy/h_sessions' is marked as crashed and should be repaired in system/classes/databaseconnection.php line 269