Since I've updated to 2.3 I have had an error message in my comments. I recently upgraded to 2.3.1 hoping that maybe that would fix it and it hasn't.
Here is the error message:
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 'select comment_author_email from wp_comments where comment_ID =]
select count(*) as comments from wp_comments where comment_author_email = (select comment_author_email from wp_comments where comment_ID = 508)
Visitors can still post comments, just the error message post before and after each comment which makes reading comments difficult.
I am using a theme I created but I am using the default comment template. My blog is hosted at 1and1.com which has PHP 4.4.7 and MySql 4.0.25.
I have another blog that is the same version and on the same host that is not getting this error.
You can see the error message on my site at http://blog.spot-design.net/2007/12/01/kristy-valshan/#comments
I am not sure why I get this error and or how to fix it so any help will be greatly appreciated.