Log in

View Full Version : strange SQL Error


Big J
01-07-2003, 06:59 PM
i am getting this mysql error when i try to update the custom user title for moderators and admins. What ia m trying to do is what you told me...i go to the user and do the following...

Moderator<br><img src="images/5stars.gif" width="55" height="12">

When i go to update it it gives me this error...

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: SELECT userid
FROM user
WHERE username='Jimmy'
AND userid <>
mysql error: You have an error in your SQL syntax near '' at line 4

mysql error number: 1064

Date: Monday 06th of January 2003 06:37:35 PM
Script: http://www.maxis-media/forum/forum/admin/user.php
Referer: http://maxis-media.com/forum/admin/...n=edit&userid=2

------

This could be the problem where it says script: http://www.maxis-media/forum/forum/admin/user.php i believe it should read http://www.maxis-media/forum/admin/user.php How could i fix this problem?

Steve Machol
01-07-2003, 07:08 PM
Reupload the original user.php file from the 2.2.9 zip file. Make sure you upload in ASCII and overwrite the one on the server.