Remove Unapproved Comments
Categories
Component ID
2695817
Component name
Remove Unapproved Comments
Component type
module
Maintenance status
Development status
Component security advisory coverage
not-covered
Component created
Component changed
Component body
This is a Drush script for removing massive quantities of unapproved comments that have usually got into a site by spambot due to unprotected comment forms. The script backs up 4 comment tables, deletes unapproved records from field_data_comment_body, field_revision_comment_body, and comment tables, then rebuilds the node_comment_statistics table. It removes all currently unapproved comments from the Drupal database. It works only for Drupal 7 with a MySQL database. It tests for D7 and MySQL before proceeding.