Stan’s Obligatory Blog


Human Ingenuity

Filed under: — site admin @ 9:49 am

We haven’t had any comment spam since I implemented my home-made CAPTCHA some time ago. But last night we got hit by TrackBack spam. 293 separate spam trackbacks. Sheesh. So I went in and deleted them by hand in MySQL:

mysql> delete from wp_comments where comment_content like ‘%poker%’;

Then I implemented the ‘moderate-trackbacks’ plugin from

If it wasn’t so annoying, it would be funny…

2 Responses to “Human Ingenuity”

  1. cindy Says:

    you can block them in your htaccess too:

    RewriteCond %{HTTP:VIA} ^.+pinappleproxy
    RewriteRule .* – [L,F]

  2. Stan Says:

    Interesting. I checked my logs and I don’t see the ‘pinappleproxy’ string in there. I don’t see any ‘HTTP:VIA’ entries either. And the spam trackbacks are all coming from different IP addresses. I got another 193 of them last night. Fortunately, doing a mass delete from the MySQL command line is pretty easy.

Leave a Reply


Powered by WordPress