Database error when changing usergroup

[MaSTaKiLLaH]

Hello,

I tried to change to usergroup of a member in the Admin-CP and got following database error :

Database error in vBulletin Control Panel 2.2.1:

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: Sunday 07th of July 2002 11:02:31 PM
Script: http://board.pc-helpnet.de/admin/user.php
Referer : ...

Does anyone have a clue ?

[Marshalus]

It looks like the same error that I was having with PHP 4.2.0. John has some patches out that fix them though.

Run a PHPInfo on your server, if it's 4.2.0 then that is your problem.

[MaSTaKiLLaH]

Thank you for your help. I will try the PHP 4.2 Update