Usernames with ' result in SQL error

zews · April 9th, 2009, 05:07 AM

I get these error mesages when one of my users, with the username Magnus'n tries to use PhotoPost Classifieds.

An error was encountered during execution of the query: 
 
SELECT userid,username,email,password,usergroupid,timezoneoffset,salt,lastactivity,membergroupids FROM user WHERE username='Magnus'n' 
 
The query returned with an errorcode of: 
 
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 ''' at line 1

Chuck S · April 9th, 2009, 08:57 AM

Under this in your integration file in the forums subdirectory

Code:

Content visible to verified customers only.

add this

Code:

Content visible to verified customers only.

zews · April 9th, 2009, 09:22 AM

Thank you

Chuck S · April 9th, 2009, 09:37 AM

have a good morning