Blogging about scripts

Tired of spam, had to sacrifice the Pingbacks

It was so frustrating to review and moderate more than 300 comments a day containing 99.9% spam, only because of the possibility of losing a few real comments.
Since at least 95% of those spam comments were actually trackbacks and not comments, using CAPTCHA or other human confirmation methods didn’t help.
So the only way for me was to disable pingbacks and trackbacks in WordPress settings but it only works for the new posts and has no effect on the old ones which are the target of most attacks.
I had to edit all the posts, one by one and remove the check-mark beside “Allow Pings” which is just too much to do! So here is the tiny little MySQL query that does the magic:
UPDATE wp_posts SET `ping_status`='closed';
TADAAA! It disabled the ping_status for all the posts.

I know I won’t receive pingbacks but I think it worth an extra an hour a day I will save by not going through spam comments. Now I can spend more time doing something more creative on scriptbloggers.


No comments

No comments yet. Be the first.

Leave a reply