My spam prevention modules had to be disabled while I was fixing a problem. Meanwhile, I was attacked by numerous spam bots and now have thousands of published spam comments on my site.

Is there a way to detect these comments and unpublish and/or delete them?

I am using drupal 7.

1 Answer 1


I use a view, that shows me 200 comments at once with their body. So by quickly looking at the list of the comments, I can see which are span and checkmark them to delete.

You can copy this view from the gist here: https://gist.github.com/timonweb/5990901

Make sure you have Views Bulk Operations (https://drupal.org/project/views_bulk_operations) module installed, then import the view from the gist and go to: http://yoursite.com/admin/content/comment/moderate.

  • I was hoping for an automated method that could do the same for me. I have way too many spam comments to go through them by the hundreds or thousands. Plus performing a delete action on too many of them in one go causes the server to crash on a shared hosting environment.
    – bcosynot
    Jul 13, 2013 at 15:51
  • 1
    Automated solutions are part of services such as akismet and mollom, people build businesses on these solutions, so I don't think you can find something working out of the box. Try this class: phpclasses.org/package/…, uses Bayesian techniques to detect spam text messages. You could write a simple module that goes through all your comments and checks them with this algorytm.
    – timonweb
    Jul 13, 2013 at 19:04
  • I guess I will have to create my own solution. Thanks!
    – bcosynot
    Jul 14, 2013 at 9:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.