Fallen Out of Favor: AVG
Once upon a time, AVG was one of the best free anti-virus programs available. It was fast, thorough, and had a small footprint. Somewhere around version 7 or 8, however, AVG took a turn for the worst—that is to say, it started to turn into what is (unaffectionately) called “bloatware.” It quickly became clear that [...]
Closing Comments to Control Spam
About a week ago, I set WordPress to automatically close comments on posts over 90 days old on my Reclaimer website. Spam comments over there have become completely unreasonable lately, with Akismet catching and filtering out upwards of 300 spam a day. The vast majority ended up going into the Pending queue rather than the [...]
MediaTemple (dv) and suPHP
A while back I switched my web hosting from Bluehost to MediaTemple. Basically, I needed the additional bandwidth and the ability to have full control over my server setup. MediaTemple came highly recommended, and I’ve never been sorry I switched. The downside was that the ability to easily upgrade plugins and the core software in [...]
HowTo: Install Ghostscript on MediaTemple
This is a repost of my original writeup over on Shamus Writes. I thought I’d go ahead and describe the process for installing Ghostscript on a MediaTemple (dv) server, especially since I’ve already got one reader who would like to see it. Use your favorite shell client to log on to your (mt) account as [...]
Borrowing from Other Cartoonists
I‘ve been doing a lot of drawing in my sketchbook recently. I try to do at least a little bit every day. I’m told that the best way to hone one’s craft is to practice daily, and I’m finding that this wisdom seems to be true. The more I draw, I more comfortable I become [...]
AHA Jack Monroe Benefit Ride, Myrtle Beach
Over this past weekend, my wife, sister-in-law, and I took a couple of horses down to Myrtle Beach, SC, for the annual American Heart Association Jack Monroe Benefit Ride.
Breakfast Delight
I just made myself a most tasty breakfast and had to share it. I’ve been on a diet for several weeks now (28lbs. lighter!), and I discovered a couple of weeks ago that I can have a couple of eggs for breakfast and only take in 140 calories. This morning, I decided to mix things [...]
Geocities Goes Dark
Yahoo! flipped the switched today, and their Geocities services found it’s final rest today. It’s a little nostalgic for me, since I spentĀ my formative web design years with Geocities. My first (admittedly garish) website was built using their services, and I think I threw every single bell and whistle into it that I could [...]


Bulk Clean-up of ‘Approved’ Spam Comments
By Jim on December 5, 2009
I recently had to clean up the database for a WordPress installation where several thousand spam comments had managed to slip by the filters and get themselves approved. Naturally, going through and marking each individual one as spam would have been a mind-numbing and infuriating process, and there is no ‘Check for Spam’ button in [...]
Posted in WordPress | Tagged comments, moderation, MySQL, spam | Leave a response