By Protoactive on

I let a drupal site go on for a around a year without any spam comment module installed; the end result are blog posts with, "51328 comments 11033 new comments" all of which are for viagra and other nonsense. The comment numbers are higher on other posts and I only discovered this when the site exceeded its bandwith.

I perused the forums here and see lots of ways to defeat this but I need to delete these comments and doing it the traditional way in admin is tedious when you have hundreds of thousands (the comments admin only lists around 20, I have pages and pages though)

Any advice greatly appreciated.

Gabe

⋅ Categories: Drupal 5.x

Comments

Protoactive’s picture

Protoactive commented

I did it, fyi if anyone find this in the future, just empty out 'comments' table in database (use phpmyadmin). You'll still have 'x amount of comments' listed in your posts but nothing will show and when a new comment is posted the number changes to one.

foxtrotcharlie’s picture

foxtrotcharlie commented

Install the views bulk operations module, create a page view of comments, and choose "Bulk Operations" as the view style. Make sure you select "Delete comment" as one of the selected operations. When you view the view page you created, you'll be able to bulk delete comments.

Charles

Drupal development, Cape Town, South Africa