cant edit users profile in cp.

i get this:


Database error in vBulletin Control Panel 2.2.6:

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

mysql error number: 1064

Date: Wednesday 17th of July 2002 06:52:55 PM
Script: http://www.kousetsu.net/newforum/admin/user.php
Referer: http://www.kousetsu.net/mewforum/adm...edit&userid=54

[scsa20]

Quoted from another post I posted recently, should work with your problem cuz the guy I helped had that same problem

here, try this, do a search for "SELECT userid" tell you come to the second "SELECT userid" (it should get to the one that drops down)

replace SELECT userid down to AND userid <> with:

PHP Code:

SELECT userid
                    FROM user
                    WHERE username='".addslashes(htmlspecialchars($ausername))."'
                        AND userid <> $userid")) { 

plus, before replaceing, you should check to make sure the code is the same of above and if not, then replace it with that. hope this works

[Steve Machol]

Also make sure you are using the user.php file from 2.2.6. Reupload it and overwrite the one on the system.

[Brad]

re-uploaded a clean file from the 2.2.6 final zip, the problem is still their.

[Chris M]

I am getting this problem also...

Did you manage to fix it Anime-loo?

Satan

[Brad]

nope

[Dean C]

search for the code in the original php file and just replace that bit of code into your current user.php file... thats what i did

[DrkFusion]

Try running repair.php or something, if Mists suggestion didn't work.

Drk