Thread: any ideas?
-
February 14th, 2002, 07:15 PM #1Junior Member
- Join Date
- Dec 2001
- Posts
- 29
any ideas?
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
-
February 14th, 2002, 08:17 PM #2Not Really a Member
- Join Date
- Oct 2001
- Posts
- 27,879
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.
-
February 15th, 2002, 01:03 PM #3Administrator
- Join Date
- Sep 2001
- Location
- USA
- Posts
- 5,011
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.
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)



LinkBack URL
About LinkBacks



Reply With Quote

my lights are flashing Morse code, I translated it and it said "Help I'm trapped in a Light bulb"
Is It Just Me? v233893843