Hi, my site (www.churchexperiment.com) has been up for quite a while with no real problems. Then I tried to set up an alternate background for comments as explained here: http://gfmorris.org/archives/2004/07/29/alternating-comment-classes/
Everything went fine until we decided to ditch the backgrounds and removed it from the CSS. I was wary of taking out the wrong bits from wp-comments.php, so I just uploaded the original version from the initial installation. Now it's gone bezerk!
Now no comments appear - though they are listed in the recent comments on the right and the comments will say something like "2 comments" but then not actually show any. There is also this error message which I assume refers to wp-comments:
Database error: [You have an error in your SQL syntax near 'WHERE comment_post_ID = '33' AND comment_approved = '1' ORDER BY comment_date' at line 1]
SELECT * FROM WHERE comment_post_ID = '33' AND comment_approved = '1' ORDER BY comment_date
See, for example: http://www.churchexperiment.com/archives/2004/07/11/scaling-down/#comments
Nothing I try (including uploading different versions of wp-comments.php) seems to solve the problem. Any ideas?