Errr. DB Error

[Symbian Galaxy]

I get this while changing the Usergroup Settings


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

[Colin F]

This is caused by one of your addons. Disable plugins globally and then see if this still occurs.

[Symbian Galaxy]

I have many addons.. isnt is possible to check which is doing it ?

[Colin F]

It's likely some sort of chat.

[Symbian Galaxy]

just have shoutbox...

[Colin F]

Try disabling that. If it's not that then you'll need to disable all the plugins.

[Symbian Galaxy]

Dsiabled Hooks and tried it gave me new error



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',
`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'
WHERE usergroupid=12;

MySQL Error : Unknown column 'mgccustomusergroupperms' in 'field list'
Error Number : 1054
Date : Wednesday, August 29th 2007 @ 05:53:09 AM
Script :
Referrer :
IP Address : 221.135.222.106
Username : Rishabh
Classname : vb_database

[Colin F]

This is still due to addons or code modifications. Please reupload all the default vBulletin non-image files in ASCII mode, overwriting your current files.

[Symbian Galaxy]

okay will try this..

[Symbian Galaxy]

Mate tried reuploading..still same DB error

[Wayne Luke]

You'll have to talk to who ever wrote the Custom Usergroup Permissions addon you're using and have them write it correctly so it can be disabled.

mgccustomusergroupperms

[Symbian Galaxy]

I dont have any usergroup addon...

[lilsalmon]

I am having the exact same error...

-Lil'

[Steve Machol]

That error is definitely from an add-on because there is no 'mgccustomusergroupperms' field in the default vB usergroup table.

To fix this, you need to reupload all the vB files and disable or remove your add-ons.