I've got several users with an apostrophe in their name (e.g., O'Brien)-but in every case their login name is 100% numeric.
The apostrophe is inserting an error message in posts of apostrophised users - "right syntax to use near 'Connell, John'' at line 1]
SELECT * FROM wp_users WHERE user_login = 'O'Connell, John'". Here is an example url : http://writing.navyhistory.org.au/?p=39154
I can see it is have trouble parsing the nickname, but that is NOT the user_login and the error appears when the content is printed.
Any suggestions/solutions about fixing this cheering received.