Make WordPress Core

Opened 19 years ago

Closed 19 years ago

#1067 closed defect (bug) (wontfix)

"spam" comments are kept forever, could hugely bloat the database

Reported by: mc_incubus's profile MC_incubus Owned by: skippy's profile skippy
Milestone: Priority: normal
Severity: minor Version: 1.5
Component: General Keywords: bg|2nd-opinion
Focuses: Cc:

Description (last modified by markjaquith)

Although I'm all for keeping spam comments in the database so that plugins can use them for some sort of ham/spam analysis, the comments table could get massively bloated eventually. I know WordPress installs that put hundreds of spam comments away a day. In a year, they could have close to 100,000 spams in there! There really needs to be a limit. Perhaps it could be trimmed to X (dropping the oldest spams) every time a blog entry is published.

Change History (5)

#1 @MC_incubus
19 years ago

  • Patch set to No

#2 @skippy
19 years ago

  • Keywords bg|2nd-opinion added
  • Owner changed from anonymous to skippy
  • Status changed from new to assigned

Chris J. Davis' Spam Nuker handles this very well.

http://www.chrisjdavis.org/2005/03/05/spam-nuker-151/

Should we ask Chris if we can fold this into core, or should this remain the domain of a plugin?

#3 @markjaquith
19 years ago

  • Description modified (diff)

The code for putting comments into 'spam' is in the core, so there should probably be code to flush it out. I'm loathe to add an option for this, but I can't help but think that the spam plugins could be put to good use by some sort of bayesian filter... you need a good collection of ham/spam for that. The other option is integrating this plugin, which allows viewing and deletion of "spam" comments as well as adding really cool paging. Essential plugin for me, I think everyone could benefit from it.

http://www.coldforged.org/paged-comment-editing-plugin/

#4 @markjaquith
19 years ago

Okay, I definitely hit the wrong button there. I was thinking A = <a href=></a>... silly me:

http://www.coldforged.org/paged-comment-editing-plugin/

#5 @matt
19 years ago

  • Resolution set to wontfix
  • Status changed from assigned to closed
Note: See TracTickets for help on using tickets.