Deleted Comments

What method did you use to delete the comments?

This just happened on Bayosphere too. Thousands of comments. We installed the spam module today and selected six caught spams in the list, then hit 'delete these'. The log shows the system deleting all valid comments in the system one at a time, starting with the lowest cid.

I restored using a combination of last night's backup and the output of a perl script run against the mysql logs for today's comments.

My first suspicion was that the bayes filter overreacted by deleting comments based on a too-small dictionary. But, that would just put them in the spam queue, according to our settings, not auto-delete them. Somehow the set of checkboxes got misinterpreted as 'delete everything'.

Ideas? We're under trackback spam attack (and are resorting to hardwired patches to trackback.module in the interim) but certainly can't turn the spam.module back on till we know what happened.

This just happened to me as well. Since I have the good fortune to have some poker spammers adding a new comment to my site every few seconds, I was able to reproduce the bug:

1. On the admin/comments screen, select a few of the top comments.
2. Select "Delete the selected comments (no confirmation)" from the drop-down list.
3. Click the "Update comments" button.
4. Press F5 to refresh the page.
5. Stupidly, click "OK" when the POST warning dialog pops up.
6. Wail, rend garments, beat breast, and tear hair.

This does not appear to happen with the built-in "Unpublish..." option, so it seems the bug is somehow in the comment deletion code.

(I'm using the 4.5.x version of drupal, but it looks like it's the same problem.)

That happened to my wife as well (similar incident with refresh). I had to restore the comments table from a backup.

I am unable to duplicate this in my rewritten version of the module. Please read the release announcement here. Download the new module here.

Please upgrade to the rewritten spam module to solve this problem (it will work with Drupal 4.5 and Drupal 4.6).

Updating status.

Closing manually. (I think the project module is broken, it keeps marking them updated when they should be closed.)