#1 (permalink)  
Old 01-17-2006, 04:30 PM
Registered User
 
Join Date: Jan 2006
Posts: 4
hassnetwork is on a distinguished road
syntax error

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

Last edited by hassnetwork; 01-17-2006 at 04:37 PM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 01-17-2006, 04:58 PM
Registered User
 
Join Date: Feb 2004
Posts: 469
Izzee is on a distinguished road
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.


Last edited by Izzee; 01-18-2006 at 10:02 AM. Reason: Fixed typo.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 01-17-2006, 05:01 PM
Registered User
 
Join Date: Jan 2006
Posts: 4
hassnetwork is on a distinguished road
but it will be a pain going around all 5000 members changing that

what was the escape code you were on about
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 01-18-2006, 10:09 AM
Registered User
 
Join Date: Feb 2004
Posts: 469
Izzee is on a distinguished road
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.


Last edited by Izzee; 01-18-2006 at 10:12 AM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 02:43 PM.


Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
© cPanel Inc