Log in

View Full Version : Help Please


Shane_2k
05-02-2003, 01:46 PM
hi i recentley found out i cnt save changes in the admin cp any more

i get this error when everi click save changes

Database error in vBulletin Control Panel 2.2.2:

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

mysql error number: 1064

Date: Friday 02nd of May 2003 03:44:01 PM
Script: http://www.nok-forums.co.uk/vb/vb/admin/user.php
Referer: http://www.nok-forums.co.uk/vb/admin/user.php?action=edit&userid=1696

PLEASE HELP

Thanks

Boofo
05-02-2003, 01:52 PM
Make sure you have this in that query:

WHERE username='".addslashes(htmlspecialchars($ausername))."'

Shane_2k
05-02-2003, 01:55 PM
hi could u tell me how im going add tht
thanks again

Boofo
05-02-2003, 01:59 PM
Download user.php from your admin dir and edit the file. ;)

Shane_2k
05-02-2003, 01:59 PM
where bout do i add it
sorry for asking all these questions

Thanks

Boofo
05-02-2003, 02:05 PM
Look for this:

AND userid <>

and replace the line above it. ;)

Shane_2k
05-02-2003, 03:39 PM
ive just tryed tht and the line i add is the same as i have in there

thanks

Shane_2k
05-03-2003, 08:24 AM
So i still get the same error

Please help
Thanks

Shane_2k
05-03-2003, 05:54 PM
bump