I don’t want to keep rattling on about spam but I got hit but a bunch of ugly trackback spam today so I’ll quickly report how I dealt with it in case it’s useful.
I have trackback switched off now (I don’t see the point) but I didn’t used to. This means that a whole bunch of old posts were vulnerable. I could go back, edit each one individually to disable trackback – or I could just run: update wp_posts set ping_status = “closed” (thanks to dasspunk for pointing this out).
The custom spambot IQ test seems to be working a treat but if you want a neat readymade plugin for WordPress you could try the SpamQuiz plugin.