[wp-trac] Re: [WordPress Trac] #5185: SQL Error on feeds for invalid posts

[WordPress Trac]

#5185: SQL Error on feeds for invalid posts
-----------------------------------------+----------------------------------
 Reporter:  robertaccettura              |        Owner:  pishmishy
     Type:  defect                       |       Status:  assigned 
 Priority:  normal                       |    Milestone:  2.4      
Component:  General                      |      Version:  2.3      
 Severity:  major                        |   Resolution:           
 Keywords:  sql, error, feed, query.php  |  
-----------------------------------------+----------------------------------
Changes (by pishmishy):

  * status:  new => assigned

Comment:

 I can't replicate this problem in exactly the same way but the problem
 does appear to still exist. Requests such as
 http://www.mywpblog.com/?feed=rss2&p=666 causes an SQL error.

 {{{
 WordPress database error: [You have an error in your SQL syntax; check the
 manual that corresponds to your MySQL server version for the right syntax
 to use near 'AND comment_approved = '1' ORDER BY comment_date_gmt DESC
 LIMIT 10' at line 1]
 SELECT wp_comments.* FROM wp_comments WHERE comment_post_ID = AND
 comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 10
 }}}

 (See http://www.securityfocus.com/archive/1/484608/30/0/threaded, although
 it's not believed to be the security problem claimed, and the new password
 hashing makes acquiring the hash less useful.)

-- 
Ticket URL: <http://trac.wordpress.org/ticket/5185#comment:9>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software