[wp-trac] [WordPress Trac] #2566: moderation may fail due to memory constraints

[WordPress Trac]

#2566: moderation may fail due to memory constraints
----------------------------+-----------------------------------------------
       Id:  2566            |      Status:  new                     
Component:  Administration  |    Modified:  Tue Mar 14 03:43:07 2006
 Severity:  normal          |   Milestone:                          
 Priority:  normal          |     Version:  2.0                     
    Owner:  anonymous       |    Reporter:  fimion                  
----------------------------+-----------------------------------------------
 In wp-admin/moderation.php on line 123,

 {{{
 #!php
 $comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE
 comment_approved = '0'");
 }}}

 can cause php to hit it's internal memory limit if there are too many
 comments in moderation (generally caused by spam). To remedy this, I
 suggest you add a limit to the number of results returned.

 so something like

 {{{
 #!php
 $comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE
 comment_approved = '0' ORDER BY `comment_date` ASC LIMIT 0 , 100");
 }}}

 This will sort oldest to newest and only return 100.

 This was brought up due to a case of a blog with 2000+ spam comments in
 moderation, and the guy couldn't moderate them.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/2566>
WordPress Trac <http://wordpress.org/>
WordPress blogging software