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.
Tags
Sorry, but no tags found yet.
Syndication
If you like this post, subscribe to my full feed or partial feed.
ILoveJackDaniels.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.