Jet Packs and Time Machines – The Best Semi Sci Fi Comic Strip Out There.

I got an email a couple days ago from my comic compatriot Jarrett Osborne of The Pursuit of Mandy and Some Day Hero.com.  He was asking me how to get rid of an infestation of spam comments on a site.  I explained that he’d have to activate a spam blocker then manually delete the aforementioned spam.  What I didn’t realize at this point, was just what he meant by infestation.  Luckily, I have admin access to his site, so while I had some down time, I went to check it out… and I realized just what a problem he had… ALMOST 200,000 SPAM COMMENTS!

Now, wordpress lets you mark these suckers as spam manually, but only about 20 at a time, and it takes like 20 seconds or so to do each page…  OUCH.

Luckily, Jarrett isn’t the first person to ignore his website for a while.  After a quick google search, I found a solution that involves using phpMyAdmin and a simple SQL query (in jarrett’s case, two actually) that really helped out a lot, so I thought I’d better post it. Here’s the link: How to Mass Delete Unapproved WordPress Comments

Hopefully, in the future Jarrett will keep a better eye on his websites, but at least there is hope for anyone who hadn’t realized the importance of activation AKISMET and managing spam when administrating their sites.