A few days ago I mentioned to Jason that at long last, comment spam is a thing of the past (hey, that rhymes). The same is true on his blog thanks to WP Hashcash. It’s such a relief to be notified of new comments without the dread of having to clean up hundreds of spam comments.

But the end of the battle is by no means the end of the war. The comment spammers have moved on to trackback spam. Matt Mullenweg, lead developer of WordPress, got hit by them today. The good news is he’s already discussing ways to resolve the problem, namely being able to disable trackbacks without disabling pingbacks.

In the interim, here’s a simple way to turn off trackbacks on all posts if you’re using WordPress. I don’t receive many of them anyway, so it’s a minimal loss with a significant gain.

This SQL query will turn off the ability to ping all posts. (Note: You’ll have to change the table name (wp_posts) if you changed your table prefix)

UPDATE wp_posts SET ping_status = ‘closed’;