Today's comment spam review process:
delete FROM comments WHERE moderation_required = 1;Deleted rows: 9699 (Query took 2.0489 sec)
Apologies to anyone whose comment ended up in the moderation queue. I normally keep on top of it, but a couple of weeks of putting it off and what started as a small pile of comments to manage has quickly ballooned into a 10,000 comment monster. Time for a comment spam prevention rethink, I reckon.
AddedBytes.com is the online playground of
Might be time to look at a system similar to wp-gatekeeper by Eric Meyer. A captcha system without the accessibility problems of using images. I've been using it for a while now, and while Askimet still has to block some spam messages its not as bad as it could be.
The only problem I have is from actual people submitting comments which *could* be valid but are most likely just looking for a link back. They're always along the lines of 'X is great, thanks for posting about it!'
I know they don't add any additional information to the post, but I don't like to remove them incase it is a genuine show of appreciation, cause that would somehow seem rude(!?)
And of course I don't want to scare people away from telling me how great I am ;)
What I might end up doing is marking those types of comments as 'temp' and then run a cron job or something every week to remove any which are over X days old. Leaving only comments that add additional relevant information in the archive.