Some of my admins are seeing SQL errors
 

I keep getting this error when some of my administrators log in. I get the same error when i made a new user manually in admincp and tried to login for the first time. I just upgraded from 3.8 to 4.08 then 4.1.1

Database error in vBulletin 4.1.1:

Invalid SQL:
SELECT vbcmspermissions FROM administrator WHERE userid =;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error Number : 1064

I have killed myself trying to find out whats going on. any suggestions would be extremely helpful

you seems have problem with vb cms permissions .. check out your configuration for each section ..

go to phpmyadmin and browse administrator table to see if there are any vbcmspermissions field have null value!

That looks like some of the Admins don't have user ID's assigned and that wouldn't make any sense.

If you made modifications to the code, find that file putting the error and figure out what you did. You may have removed a condition or something.

But do as suggested above but also check the users table and see if those admins have a null value for the user id... that shouldn't make sense because they are primary keys, so it must be that someone removed or added a syntax error in the code.