SQL problem with comments

  • 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?

Viewing 1 replies (of 1 total)

  • 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

Viewing 1 replies (of 1 total)
  • The topic ‘SQL problem with comments’ is closed to new replies.