Hell! , 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||allo w_bbcode_font||1|||core||allow_bbcode_align||1|||c ore||allow_bbcode_list||1|||core||allow_bbcode_url ||1|||core||allow_bbcode_code||1|||core||allow_bbc ode_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|||n on_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]

nbmsgshowchatbox encourages the problem. Try to delete all codes and files about that.
And delete the Team Leader group.

[Marco van Herwaarden]

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]

Marco you rock! Thanks Mate.. I tried on vb.com nobody was able to help me out..

Thanks a Ton!:)