syntax error

[hassnetwork]

hi,
please help

i managed to get the mysql version sorted according to the same version the previous webhost had

i restored the db using telnet
but on VBulletin on memberlist.php i get the error:


Invalid SQL: SELECT uploaded, downloaded,ulspeed,dlspeed FROM users WHERE username='A'isha'
mysql 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 'isha'' at line 1

i realised when i delete the account the error goes off but when i click on a letter like S which has a user like 'S'ad'
because of the user having a ' in its username i believe thats causing the error

what do you guys think?

thanks

[Izzee]

Either change the user name to remove that ' or use the escape character to fix in the script a\'isha.

IMO obviously the best solution is to not allow username a'isha but to allow aisha.

[hassnetwork]

but it will be a pain going around all 5000 members changing that

what was the escape code you were on about

[Izzee]

The escape character is the back slash \ as I have shown quite clearly in the above post.

A good explanation can be seen here:
http://www.noviceforms.com/beginners.phtml

and you can see its use here:
http://www.htmlgoodies.com/beyond/ja...le.php/3470891

Also this is a vBulletin issue and you should be addressing your questions to their forums as this is not a Cpanel/WHM problem.