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?
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.
(@carminecoyote)
18 years, 8 months 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?