PhotoPost Community - View Single Post

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

April 9th, 2009, 05:07 AM	#1 (permalink)
zews Member Verified Customer Join Date: Sep 2005 Posts: 144	Usernames with ' result in SQL error 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:<br /> <br /> SELECT userid,username,email,password,usergroupid,timezoneoffset,salt,lastactivity,membergroupids FROM user WHERE username='Magnus'n'<br /> <br /> The query returned with an errorcode of: <br /> <br /> 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<br />