[wp-trac] [WordPress Trac] #17556: PHP Errors on the media page in 3.1.3

[WordPress Trac]

#17556: PHP Errors on the media page in 3.1.3
--------------------------+---------------------
 Reporter:  philipwalton  |       Owner:
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:  3.1.4
Component:  Query         |     Version:
 Severity:  major         |  Resolution:  fixed
 Keywords:                |
--------------------------+---------------------

Comment (by nacin):

 For the record, the 3.1.2 query:

 {{{
 SELECT SQL_CALC_FOUND_ROWS wp31clean_posts.* FROM wp31clean_posts WHERE
 1=1 AND wp31clean_posts.post_type = 'attachment' AND
 (wp31clean_posts.post_status = 'inherit') ORDER BY
 wp31clean_posts.post_date DESC LIMIT 0, 20
 }}}

 The 3.1.3 query:

 {{{
  SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND
 wp_posts.post_type = 'attachment'  ORDER BY wp_posts.post_date DESC  LIMIT
 0, 20
 }}}

 The 3.1.4 query:
 {{{
 SELECT SQL_CALC_FOUND_ROWS wp31clean_posts.* FROM wp31clean_posts WHERE
 1=1 AND wp31clean_posts.post_type = 'attachment' AND
 (wp31clean_posts.post_status = 'inherit' OR wp31clean_posts.post_status =
 'private') ORDER BY wp31clean_posts.post_date DESC LIMIT 0, 20
 }}}

 They're all equivalent except for the private posts check now in 3.1.4,
 which is expected.

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