How do I delete unapproved comments?

Posted by themagicm on January 13, 2013 at 2:27pm

Before I put reCaptcha on my site, I had alot of spam comments. Now that I have it installed, I have about 3000 unapproved comments to delete.

How would I delete those faster than 50 at a time thru Drupal's existing comment manager?

Comments

VBO

Posted by yelvington on January 13, 2013 at 2:34pm

You could just ignore them, as they're unapproved and not published.

Easiest way to delete them is to make a bulk deletion tool using http://drupal.org/project/views_bulk_operations. It lets you apply a bulk operation to all matching rows. Just be sure to restrict access to the admin.

.

Posted by tryitonce on January 13, 2013 at 6:10pm

An expert in MySql DB might suggest to do it there.
But I would also suggest to use VBO - a very useful tool not just for deleting nodes, but many other admin tasks ...

-----------
_{Good luck .....

... more recent results of trying Drupal just once are -
www.native-power.de
Malls and More}

yea, I should have installed

Posted by themagicm on January 14, 2013 at 11:48pm

yea, I should have installed it in a MySQL db because then I could have done it that way. As far as VBO, I found it a while back but was confused as to how to use it to delete unapproved comments.