any ideas?

[mav]

i run vbulletin
Im experienced with installing hacks
but i have this error and i dont know how to fix-maybe someone can give me a start?

Database error in vBulletin Control Panel 2.2.2:

Invalid SQL: SELECT cancontrolpanel FROM usergroup WHERE usergroupid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

this occurs when trying to update a profile in admin cp

tx in advance

[vass0922]

Well unfortunately I dont know vBulletin database structure, so I'll wing it based on my sql exp.

My guess is one of several things.

1. cancontrolpanel (Column) doesn't exist or is misspelled
2. WHERE usergroupid= is not getting a value

the SQL is expecting a value to be specified here, it should be something like WHERE usergroupid= 'vass0922' or WHERE usergroupid=21244 depending on how vbuelletin stores usergroupids

If its possible, put in a debug statement somewhere so you can see in the webpage the value that is supposed to be there. I dont know PHP so dont know the exact code to do this (man I gotta work on that lol). Maybe (in vb it would be like) debug.print usergroupid

basically what I"m getting at, is try to find out if its getting a value or not.

[ScottW]

Look in whatever script updates the user's profile (functions.php, I don't really know) and find the line that looks like "select cancontrolpanel", and make sure that SQL line is valid - check the DB and make sure cancontrolpanel exists in table usergroup,etc.