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.
Comment Spam Review Process was posted April 27, 2007 in Blog and has not been tagged yet.
AddedBytes.com is the online playground of Dave Child, an e-commerce manager and internet marketer from Brighton, on the south coast of the UK. More about Dave.
Email: dave@addedbytes.com.
Dave is the Head of Digital at Active Parity, where he spends his time developing and marketing websites.
Call Matt on 01273 201 348 to find out how we can help your online business.
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.