[wpmu-trac] [WordPress MU Trac] #193: Database Error displaying Recent Comments

[WordPress MU Trac]

#193: Database Error displaying Recent Comments
------------------------+---------------------------------------------------
 Reporter:  glenc       |       Owner:  somebody                      
     Type:  defect      |      Status:  new                           
 Priority:  normal      |   Milestone:  WPMU 1.0                      
Component:  component1  |     Version:  1.0                           
 Severity:  major       |    Keywords:  database error recent comments
------------------------+---------------------------------------------------
 Hi,

 I get the following error viewing a blog front page:


 {{{
 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 ' WHERE .ID=.comment_post_ID AND post_status = 'publish' AND
 comment_approved = ' at line 1]
 SELECT ID, comment_ID, comment_content, comment_author FROM , WHERE
 .ID=.comment_post_ID AND post_status = 'publish' AND comment_approved =
 '1' ORDER BY .comment_date DESC LIMIT 6
 }}}


 The system running the blog is Windows 2003 + Apache/2.0.58 (Win32) DAV/2
 mod_auth_sspi/1.0.2 SVN/1.3.2 PHP/5.2.0.  MySQL is version 5.0.27.

 Steps taken so far:

 Install WordPress MU[[BR]]
 Go into Site Admin and delete sample comment then sample post.[[BR]]
 As admin, create a new sub-blog.[[BR]]

 The sub-blog is using the ShadedGrey theme.  Note I've removed MySQL login
 information from the attached file.

 Cheers

 Glen

-- 
Ticket URL: <http://trac.mu.wordpress.org/ticket/193>
WordPress MU Trac <http://mu.wordpress.org/>
WordPress Multiuser