vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   Some of my admins are seeing SQL errors (https://vborg.vbsupport.ru/showthread.php?t=258372)

optikalefx 02-05-2011 04:14 AM

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

al3bed 02-05-2011 12:34 PM

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!

MultiSync77F 02-06-2011 09:11 PM

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.


All times are GMT. The time now is 01:08 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01078 seconds
  • Memory Usage 1,706KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete