Considering the volume of spam comments that ends up on sites, it'd be nice to delete them all at once, instead of having to go through delete process for each item individually.

Comments

jeremy’s picture

It is not advised that you delete comment spam. As I improve the spam module's tokenizer logic, the only way you will be able to upgrade w/o loosing what you've taught the filter so far is by re-reading in old spam messages. (This is automated at 'admin/spam/rebuild/all')

Thus, it is highly recommended you unpublish spam rather than deleting it.

teradome’s picture

Ah ok, that makes sense! I think I just found the idea that the spam was still semi-active on my site a little disturbing, but now I get it. :)

Could there be an archive feature? What might be nice is to separate the spam lists into two tables: one for spam that's caught and is ready for review, published or not, and one that has been reviewed but tucked away where you don't see it in context. This way you can have extra copy at the head to describe that keeping them "archived" allows the spam tokenizer to be improved throughout development.

I'm just a heavy organizer and seeing the old spam while trying to look through new items that were caught kind of throws me off -- I'd love to tuck them away to another deeper level I don't need to look at unless absolutely necessary. :)

garym@teledyn.com’s picture

Title: Add delete comments to list of batch actions » Keeping spam is not an option

Keeping spam is not an option. I post to my blog at most once a day, my busiest maybe gets two a day. Compare that to 28 spams a day and rising. I do not intend to pay for webhosting tens of thousands of invisible viagra ads.

teradome’s picture

Well, as he said, there's no reason you can't delete it. But if the module is improved, or the tokenizer changes, there's no way for the module to relearn... You'd have to start from scratch.

Jeremy has added an optional patch to comment.module that adds bulk deletion which you can use if you still feel the need to delete.

jeremy’s picture

Status: Closed (works as designed) » Fixed

The 2.0 rewrite of the spam module supports bulk deletion of spam content. You can also configure it to auto-expire (delete) spam content after a certain amount of time.

boris mann’s picture

Title: Keeping spam is not an option » Need "select all" to effectively delete comments a page at a time
Status: Fixed » Active

Jeremy -- I'm re-opening this issue because without a "select all" button, it still means having to do an unreasonable amount of manual labour.

I'd actually prefer a big giant "nuke all comments" button that lets me delete them all. Right now, I'm back to doing this in MySQL because it takes too long to check the box on all comments, hit delete, and repeat 10 - 20 times (that is, I have 10 - 20 pages of spam, and have to click the select checkbox for each one).

Also, need a mass "mark as spam" -- I got 100s of spams that snuck through my filters and got published, and I again have to go to each one directly and "mark as spam". The admin/comment/list/spam page should list *all* comments, and let me bulk mark as spam selectively.

Did I mention I'm grateful for blocking 30,000 spam comments since Aug. 15th of this year?

jeremy’s picture

Status: Active » Fixed

> I'm re-opening this issue because without a "select all" button,

Grab the latest release. It _does_ have a "select all" link. Any place where you have the ability to select more than one thing at a time, there is now a "select all" and a "select none" javascript option.

> I'd actually prefer a big giant "nuke all comments" button that lets me
> delete them all. Right now, I'm back to doing this in MySQL because it
> takes too long to check the box on all comments, hit delete, and
> repeat 10 - 20 times (that is, I have 10 - 20 pages of spam, and have
> to click the select checkbox for each one).

Sorry, but I currently have no intention to add a "delete all spam comments" button. You can manually delete them 50 at a time (that's how many are displayed on a page at a time), or you can let the auto-expiration option do it for you after they have been in your database for a configurable amount of time. If you want comments deleted quicker, decrease the time it takes for comments to auto-expire.

> Also, need a mass "mark as spam" -- I got 100s of spams that snuck
> through my filters and got published, and I again have to go to each
> one directly and "mark as spam". The admin/comment/list/spam page
> should list *all* comments, and let me bulk mark as spam selectively.

No, the whole idea behind that page is to only show spam content. It would become very confusing if it showed both spam comments and non-spam comments. Additionally, you want to be careful mass-marking comments as spam, as you might "over train" your bayesian filter that way.

Instead, what I would do is to define a custom filter for the comments that slipped through, then click "scan" on the custom filter page. That will show you all comments that match the filter, and will allow you to mass-mark them as spam, or better to mark a few as spam and then to mass-delete the rest of them.

> Did I mention I'm grateful for blocking 30,000 spam comments since Aug. 15th of this year?

Glad to hear it.

I believe all of your concerns are handled by the current spam module. I'm re-marking this as fixed.

boris mann’s picture

Yep, I must have missed one of your point releases -- select all handles this great, and auto-deletion after a time period is great, too.

We should probably privately send you updates to the default poker and medicine regex's -- out of the box, you'll immediately get hammered.

Abalieno’s picture

It would be appreciated to have an option to PREVENT spam from being stored. So parse it before it enters the database.

I moderate the comments on my site, but the constant spam is pushing the count as high as 3000+, which wouldn't be much for the database but that I'd like to avoid.

jeremy’s picture

New requests should be made in new isses, not in old closed issues

> .It would be appreciated to have an option to PREVENT spam from being
> stored. So parse it before it enters the database.

Go to administer >> settings >> spam and set "Detected spam postings before blacklisting IP" to a low value such as 2. Now, once the same IP address is caught posting spam it will be blocked from posting any more content to your site. The block will be in affect as long as the spam remains in the database. (Thus, if you auto-expire your spam every 7 days, the IP will only be blocked for 7 days.)

jeremy’s picture

BTW: The latest revision of this patch blocks most spam from ever getting to your database. I have been using it very succesfully on my website.

jeremy’s picture

Status: Fixed » Closed (fixed)

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

sillygwailo’s picture

There has been some work on getting a "select all" function in comments & trackbacks, though the code needs to be re-submitted in the form of a patch.