~<< Help >>~

im getting this error when i try to save a change to a user in the admin cp ...

PHP Code:

Database error in vBulletin Control Panel 2.2.6:

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

mysql error number: 1064

Date: Saturday 06th of July 2002 02:27:17 PM
Script: [url]http://www.theironmic.com/board/board/admin/user.php[/url]
Referer: 


I will attach my admin/user.php file below so someone can have a look at it

Hopefully someone can fix it !

Thanks in Advance

[Steve Machol]

It is against the license agreement to post vB files. I suggest you reupload the original user.php file from the 2.2.6 zip file and see if that fixes the problem. Make sure you upload in ASCII and overwrite the existing file.

[Dean C]

im sorry... i didn't realise... ive installed lots of hacks ... so i dont kno which one has caused it... and i dont want to go installing all the hacks again...

what can i do?

if ure on AIM at the moment smachol i can send u the file over there if you would be willing to fix it....

AIM = XSMCOG

[Steve Machol]

Sorry I don't fix hacked files. IMO it's never a good idea to install a lot of hacks without first making sure that each hack works and doesn't cause problem before moving on to the next one. Good luck!

[Dean C]

i did do that... but what i normally do iwhen i edit a file is go to an instance of that file and see if the page loads... and it did up to now... the page loads fine... but im getting that error when i try to change a user ...

[scsa20]

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

[Dean C]

THANKYOU !!!

it fixed it

[scsa20]

your welcome

[Dean C]

UPDATE:

im getting this errror again whenever i try to edit a profile thru the admin cp:

PHP Code:

Database error in vBulletin Control Panel 2.2.6:

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

mysql error number: 1064

Date: Monday 15th of July 2002 08:28:43 AM
Script: [url]http://www.theironmic.com/board/board/admin/user.php[/url]
Referer: 


[Dean C]

sorry to bump but i need to fix the problem

Thanks