WordPress.org

Support

Support » How-To and Troubleshooting » Comment Database Error

Comment Database Error

  • Since I’ve updated to 2.3 I have had an error message in my comments. I just 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)

    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 am not sure why I get this error and or how to fix it so any help will be greatly appreciated.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Any ideas anyone?

    The error doesn’t effect the posting of comments except for the error message being printed before and after each comments post which is very annoying and has reduced my average amount of comments from 20 to none.

    In have search on the site for the answer but everyone else who asked this same question also didn’t get any answers. Is that because there is no answer to this question? If that is the case I will have to downgrade to WordPress 2.2.3, since that was the last time it worked correctly. Which will be a pain since I just finally got all my tags set up on 4 years of blogging.

    I just realized that my other blog which is 2.3 has no error messages. It’s using the same hosting so it’s not a host problem. Do I need to clean my database or something? I am at a lost why I am getting this error.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Comment Database Error’ is closed to new replies.
Skip to toolbar