Mysql error,help please

[Funkie]

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....

[Xenon]

seems like a php42x bug.

upgrade to version vb226 this should solve your problems

[Funkie]

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...

[Xenon]

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 ;)

[Funkie]

Thanx bud omw:):)