webmaster

Drupal Tip

Deleting masses of unapproved spam comments in Drupal

I originally set this site up with anonymous comments enabled and a CAPTCHA-type module to prevent spam. Well, it failed. It seems that spambots have crossed some lesser Turing threshold, or at least been hard-coded to answer simple mathematical questions. That left me with over 10,000 unapproved comments in the queue, and the Drupal 7 interface lets you delete them 50 at a time, with a few clicks. You can do the math...