Andrew Connell

Cleaning up unmoderated comments / trackbacks in SubText quickly

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...

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!

Andrew Connell
Developer & Chief Course Artisan, Voitanos LLC. | Microsoft MVP
Written by Andrew Connell

Andrew Connell is a web developer with a focus on Microsoft Azure & Microsoft 365. He’s received Microsoft’s MVP award every year since 2005 and has helped thousands of developers through the various courses he’s authored & taught. Andrew’s the founder of Voitanos and is dedicated to delivering industry-leading on-demand video training to professional developers. He lives with his wife & two kids in Florida.