Error if edit any user

[Habib]

salam ..

i get problem when i try to edit any user info or leavl.

i get this msg:

Database error in vBulletin Control Panel: Invalid SQL: SELECT COUNT(*) AS users FROM user,usergroup WHERE user.usergroupid=usergroup.usergroupid AND usergroup.cancontrolpanel=1 AND user.userid<>
mysql error: You have an error in your SQL syntax near '' at line 1
mysql error number: 1064
Date: Thursday 01st of August 2002 06:38:29 AM
Script: /vb/admin/user.php
Referer: http://xxxxxxxxxxxx.net/vb/admin/user.php?s=&action=edit&userid=77



this Error comes after i update Mysql & php
and i delete old mysql data base and i add backup copy i have but still get same error :mad:


my Copy 2.0.3

[WingMan]

SELECT COUNT(*) AS users
FROM user,usergroup
WHERE user.usergroupid=usergroup.usergroupid
AND usergroup.cancontrolpanel=1
AND user.userid<>


The error is because the SQL command is not correct.
The last line 'AND user.userid<>'
should read something like 'AND user.userid<> nn' where nn is an integer number. If you don't want to exclude certain users from the count then you don't need the last line.

[Steve Machol]

Your host has probably upgraded to PHP 4.2.x. The onmly way to fix thins (and other problems) is to upgrade to vB 2.2.6:

http://www.vbulletin.com/forum/showthread.php?s=&threadid=46938

[Habib]

yes thats right they upgraded the PHP ..

so there is no way to fix it if i didn't upgrad to 2.2.6 !!

[Steve Machol]

If you are running 2.2.5 you *might* be able to get away with uploading the patched files in freddie's post here:

http://www.vbulletin.com/forum/showthread.php?s=&threadid=44820

Otherwise the only way to fix this is to upgrade to 2.2.6.