Mysql error,help please
 

Hi All,

When i try to change a users usergroup all i get is this error:(:(

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


Iam as thick as a brick when it comes to sql errors.some please help:):)


Thanx in advance....

seems like a php42x bug.

upgrade to version vb226 this should solve your problems

Hi again,

what is php42x bug.......

It was all fine and dandy last night,and now this morn its messin about:(:(

Thanx for the info...

it means, your host has updated to php version 4.2.x, and older vb versions have problems with this php-version

you have to upgrade, or at least have to install the 3 patched files, you can find in the vbulletin.com announcement forum

if you have problems seeing the names of your templates you can be sure it is the php42x bug ;)

Thanx bud omw:):)