Some of my users are getting this error after replying to a topic (although their replies are successfully posted despite the 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…

…and then it list the html of the first line of their reply. It looks like that usually contains an @mention if that makes a difference.

Any ideas on this?

[@johnjamesjacoby Keymaster 12 years, 10 months ago]

No idea what the error is to help.

[@highexistence Participant 12 years, 10 months ago]

@johnjamesjacoby – Here is the error, verbatim:

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 'http://hethens.com/people/jordan/' rel='nofollow'>@jordan</a>, <a href='http://h' at line 1]

SELECT ID FROM wp_posts WHERE post_type = 'reply' AND post_status != 'trash' AND post_author = 2382 AND post_content = '<a href='http://hethens.com/people/jordan/' rel='nofollow'>@jordan</a>, <a href='http://hethens.com/people/jaygran7/' rel='nofollow'>@jaygran7</a>, hello!' AND post_parent = '60294' LIMIT 1

Looks like an issue with using @replies?