Cannot create/edit Usergroups

[Ayien]

For some reason, I cannot edit user groups or create new ones. I always get a database error within the frame of the user group manager.

Anyone know what could be wrong? (DB Error report on request)

Thank you

[Zachery]

Whats the database error?

[Ayien]

Database error in vBulletin 3.6.7:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO usergroup
(`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `nbmsgshowchatbox`, `mgccustomusergroupperms`, `forumpermissions`, `genericpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `calendarpermissions`, `wolpermissions`, `adminpermissions`, `genericoptions`, `profilepicmaxwidth`, `profilepicmaxheight`, `profilepicmaxsize`, `avatarmaxwidth`, `avatarmaxheight`, `avatarmaxsize`, `signaturepermissions`, `sigpicmaxwidth`, `sigpicmaxheight`, `sigpicmaxsize`, `sigmaxrawchars`, `sigmaxchars`, `sigmaxlines`, `sigmaxsizebbcode`, `sigmaximages`)
VALUES
('t3t', '3t3t', '', '', '', '', '', '0', '0', '', '0', '651271', '2626563', '1000000', '0', '0', '5', '0', '1', '0', '41', '100', '100', '25000', '50', '50', '20000', '0', '', '', '', '', '', '', '7', '');

MySQL Error : Unknown column 'nbmsgshowchatbox' in 'field list'
Error Number : 1054
Date : Tuesday, July 10th 2007 @ 02:04:27 AM
Script : http://*********.com/forums/admincp/....php?do=update
Referrer : http://*********.com/forums/admincp/...oup.php?do=add
IP Address : **.**.**.***
Username : ************
Classname : vB_Database

[Zachery]

Youve got an addon causing the error, there is no nbmsgshowchatbgox permission in vBulletin.

Try removing all of the files from includes/xml and reuploading the default ones from the vfBulletin zip.

[Ayien]

Worked like a charm. Thanks Zach.

[forohosting]

Youve got an addon causing the error, there is no nbmsgshowchatbgox permission in vBulletin.

Try removing all of the files from includes/xml and reuploading the default ones from the vfBulletin zip.

thanks for this

[smokering]

I get this error tried the above fix did not help me


Database error in vBulletin 3.5.4:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Unregistered / Not Logged In',
`description` = '',
`usertitle` = 'Visitor',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '655361',
`pmquota` = '0',
`pmpermissions` = '0',
`pmsendmax` = '0',
`calendarpermissions` = '32',
`wolpermissions` = '0',
`genericpermissions` = '0',
`genericoptions` = '0',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '100000',
`avatarmaxwidth` = '150',
`avatarmaxheight` = '150',
`avatarmaxsize` = '400000',
`photoplogpermissions` = '0',
`photoplogmaxfilesize` = '512000',
`photoplogmaxfilelimit` = '100',
`usmilie_permissions` = '0',
`adminpermissions` = '0'
WHERE usergroupid=1;
MySQL Error : Unknown column 'usmilie_permissions' in 'field list'
Error Number : 1054
Date : Sunday, October 14th 2007 @ 05:08:19 PM
Script : http://www.xxxx.xxxx/xxxxxxx/admincp/usergroup.php
Referrer : http://www.xxxx.xxxxxx/xxxxxxxxx/adm...&usergroupid=1
IP Address : xxxxxxxxx
Username : SmokeRing
Classname : vb_database

[smokering]

fixed it it was an xml file still there from a hack i uninstalled

[Steve Machol]

There is no 'usmilie_permissions' field in the default vB usergroup table. This is from an add-on you installed. To fix this reupload the original vB files and/or remove your add-ons.