WordPress.org

Forums

SQL problem with comments (2 posts)

  1. carminecoyote
    Member
    Posted 7 years ago #

    The following message has suddenly begun to appear along with the comments on my blog.

    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 = 94)

    Can anyone please tell me how to correct the problem?

  2. Beau Lebens
    Member
    Posted 7 years ago #

    Is it remotely possible that your MySQL database was down-graded? That looks like a problem with an older version of MySQL (4.x?) that didn't support sub-SELECTs.

    Beau

Topic Closed

This topic has been closed to new replies.

About this Topic