[wp-trac] [WordPress Trac] #21101: Allow get_comments() to query for explicit value of comment_approved

[WordPress Trac]

#21101: Allow get_comments() to query for explicit value of comment_approved
-------------------------+-----------------------
 Reporter:  nbachiyski   |       Owner:  westi
     Type:  enhancement  |      Status:  reopened
 Priority:  normal       |   Milestone:  3.5
Component:  Comments     |     Version:  3.4
 Severity:  blocker      |  Resolution:
 Keywords:  has-patch    |
-------------------------+-----------------------

Comment (by c3mdigital):

 Replying to [comment:17 Otto42]:
 > This seems to break the main listing on the edit-comments.php screen. It
 causes queries to be generated like this:
 >
 > {{{
 > SELECT * FROM wp_comments WHERE comment_approved = 'all' ORDER BY
 comment_date_gmt DESC LIMIT 28
 > }}}
 >
 > Naturally, there's no comments with comment_approved = 'all'.

 In 3.4.2 the query generated is:


 {{{
 SELECT * FROM wp_comments WHERE ( comment_approved = '0' OR
 comment_approved = '1' ) ORDER BY comment_date_gmt DESC LIMIT 28
 }}}

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/21101#comment:20>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software