Cleaning up unmoderated comments / trackbacks in SubText quickly

Sunday, August 12, 2007 6:33 AM
Microsoft MVP Logo

Get a lot of crap through your comments, trackbacks and pingbacks on your SubText blog? The support added for Akismet rocks and has cut down on the number of amount crap that makes it through, but no system is foolproof. I've noticed after ignoring the unmoderated stuff for a while and as the quantity slowly grows, the loading of the feedback page in the admin section gets slower and slower. Not only that, but I don't care to have all that crap in my blog DB.

Unfortunately the admin screens only show 10 items per page… and when you've got 1000+ unmoderated pieces of crap content you want to get rid of, well, 10 at a time stinks.

So here's what I do to clean it up…

Connect to your DB using SQL 2005 Studio / Enterprise Manager and run the following query:

select count(*) from subtext_feedback where statusflag=2 and feedbacktype=2

If the count number that comes back is the same as the number of unmoderated items shown in the feedback page, then you're in good shape (never had it not be, but better to be safe than sorry).

Now, clean it up running this query:

delete from subtext_feedback where statusflag=2 and feedbacktype=2

Late-summer blog cleaning complete. Enjoy!

comments powered by Disqus