vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Hell! , DB error! (https://vborg.vbsupport.ru/showthread.php?t=156702)

Symbian Galaxy 08-31-2007 12:46 PM
Hell! , DB error!
 
I get this while changing the Usergroup Settings


Code:
Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    `title` = 'Team Leader',
    `description` = '',
    `usertitle` = 'Team Leader',
    `opentag` = '<b><font color=\"#33ccff\">',
    `closetag` = '</font></b>',
    `passwordexpires` = '0',
    `passwordhistory` = '0',
    `ispublicgroup` = '0',
    `canoverride` = '0',
    `advanced_bbcode_usergroup_on` = '1',
    `nbmsgshowchatbox` = '',
    `mgccustomusergroupperms` = '0',
    `forumpermissions` = '1048575',
    `genericpermissions` = '1073741823',
    `attachlimit` = '0',
    `pmquota` = '200',
    `pmpermissions` = '0',
    `pmsendmax` = '5',
    `calendarpermissions` = '63',
    `wolpermissions` = '31',
    `adminpermissions` = '1',
    `genericoptions` = '63',
    `profilepicmaxwidth` = '150',
    `profilepicmaxheight` = '150',
    `profilepicmaxsize` = '25000',
    `avatarmaxwidth` = '50',
    `avatarmaxheight` = '50',
    `avatarmaxsize` = '20000',
    `signaturepermissions` = '237567',
    `sigpicmaxwidth` = '0',
    `sigpicmaxheight` = '0',
    `sigpicmaxsize` = '0',
    `sigmaxrawchars` = '0',
    `sigmaxchars` = '0',
    `sigmaxlines` = '0',
    `sigmaxsizebbcode` = '7',
    `sigmaximages` = '0',
    `displayorder` = '3',
    `advanced_bbcode_permissions` = 'core||allow_bbcode_basic||1|||core||allow_bbcode_color||1|||core||allow_bbcode_size||1|||core||allow_bbcode_font||1|||core||allow_bbcode_align||1|||core||allow_bbcode_list||1|||core||allow_bbcode_url||1|||core||allow_bbcode_code||1|||core||allow_bbcode_php||1|||core||allow_bbcode_html||1|||non_core||imgreflect||0|||non_core||marq||0|||non_core||hl||1|||non_core||button||1|||non_core||blink||1|||non_core||hide||1|||non_core||s||1'
WHERE usergroupid=12;

MySQL Error  : Unknown column 'nbmsgshowchatbox' in 'field list'
Error Number : 1054
Date        : Wednesday, August 29th 2007 @ 04:09:01 AM
Script      :
Referrer    :
IP Address  :
Username    :
Classname    : vb_database

Tried disabling Hooks too + Uploaded vBulletin once more!

Mean 08-31-2007 12:49 PM
nbmsgshowchatbox encourages the problem. Try to delete all codes and files about that.
And delete the Team Leader group.

Marco van Herwaarden 08-31-2007 03:19 PM
That is not the best advice to give. Why delete the usergroup? I see absolutly no reason to do so.

To solve your problem: When installing that modification (chatbox??) you have also uploaded a ./includes/xml/bitfield_XXXX.xml that belongs to this modification. You have later uninstalled the modification, but left this file on the server. Remove the file ad edit any usergroup and all should be back to normal.

Symbian Galaxy 08-31-2007 03:49 PM
Marco you rock! Thanks Mate.. I tried on vb.com nobody was able to help me out..

Thanks a Ton!:)


All times are GMT. The time now is 03:29 AM.

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.00939 seconds
  • Memory Usage 1,718KB
  • 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)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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