Database error in vBulletin Control Panel? 2.03

[Cary]

It looks like your host just upgraded their version of PHP to 4.2.3 - To fix the problem, you need to upgrade your version of vBulletin to 2.2.8 or 2.2.9

http://www.vbulletin.com/forum/showt...threadid=50098

[funnsun]

How can I fix this? Whenever I try to update some members(from "member waited activation" to registered member) I get this.. It doesnt happen to all but some.. Odd.

If anyone can help, that can put it in plain english I'd really appreciate it!

Here is the error:

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: Saturday 23rd of November 2002 08:39:53 PM
Script: /forums/admin/user.php