Make WordPress Core

Opened 10 years ago

Closed 10 years ago

#2261 closed defect (bug) (wontfix)

akismet plugin does not display all spam comments in 'Last 15 days' summary

Reported by: schuhfits Owned by:
Milestone: Priority: normal
Severity: normal Version: 2.0
Component: Administration Keywords:
Focuses: Cc:


in wp-plugins/akismet/akismet.php The 'COUNT(*) and GROUP BY' bits of this SQL query will cause Akismet to skip additional comments posted from the same IP address. While not necessarily a problem (it's probably spam anyways) this creates a disparity between the number of spam comments reported and the number of spam comments displayed in the summary.

Around line 244 in wp-plugins/akismet/akismet.php:

$comments = $wpdb->get_results("SELECT *, COUNT(*) AS ccount FROM $wpdb->comments WHERE comment_approved = 'spam' GROUP BY comment_author_IP ORDER BY comment_date DESC LIMIT 150");

Change to:

$comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE comment_approved = 'spam' ORDER BY comment_date DESC LIMIT 150");

Change History (1)

#1 @markjaquith
10 years ago

  • Resolution set to wontfix
  • Status changed from new to closed

I think the current behavior is good because it "compresses" the view. Many posts by the same IP are probably spam... and it makes "skimming" the list much faster.

Reopen if you want to discuss further!

Note: See TracTickets for help on using tickets.