[wp-trac] [WordPress Trac] #5256: Ambiguous column in query.php method get_posts()

WordPress Trac wp-trac at lists.automattic.com
Thu Oct 25 06:57:03 GMT 2007


#5256: Ambiguous column in query.php method get_posts()
-------------------------+--------------------------------------------------
 Reporter:  lawrence123  |       Owner:  anonymous
     Type:  defect       |      Status:  new      
 Priority:  normal       |   Milestone:  2.5      
Component:  General      |     Version:  2.3      
 Severity:  normal       |    Keywords:           
-------------------------+--------------------------------------------------
 Using v2.3, line 871 should be:

 $where = " AND $wpdb->posts.ID = " . $q['p'];

 and line 876 should be:

 $where = " AND $wpdb->posts.ID = " . $q['page_id'];

 Background: My plugin uses the posts_where and post_join filters. When you
 join with another table that also has an ID column the query will fail,
 because above lines currently show: ' AND ID = '

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


More information about the wp-trac mailing list