Adding New user group

[MalluCastle]

We are faceing a big probleam.we can't make a new User group it's showing data base is Error.

[snakes1100]

Post the mysql error from the page, right click and view source to copy the entire error.

[MalluCastle]

Its showing like this Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Rising Star',
`description` = '',
`usertitle` = 'Rising Members',
`opentag` = '<strong><font color=\'darkviolet\'>',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`icashpermissions` = '7',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = '',
`forumpermissions` = '783359',
`genericpermissions` = '472462987',
`attachlimit` = '1000000',
`pmquota` = '50',
`pmpermissions` = '0',
`pmsendmax` = '5',
`calendarpermissions` = '31',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '46',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '25000',
`avatarmaxwidth` = '125',
`avatarmaxheight` = '125',
`avatarmaxsize` = '20000',
`signaturepermissions` = '245759',
`sigpicmaxwidth` = '0',
`sigpicmaxheight` = '0',
`sigpicmaxsize` = '0',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`albumpermissions` = '0',
`albumpicmaxwidth` = '0',
`albumpicmaxheight` = '0',
`albumpicmaxsize` = '0',
`albummaxpics` = '0',
`albummaxsize` = '0',
`usercsspermissions` = '0',
`visitormessagepermissions` = '0',
`socialgrouppermissions` = '0'
WHERE usergroupid=10;

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Sunday, July 20th 2008 @ 02:47:22 PM
Error Date : Sunday, July 20th 2008 @ 02:47:22 PM
Script : http://www.mallucastle.com/forum/admincp/usergroup.php?do=update
Referrer : http://www.mallucastle.com/forum/admincp/usergroup.php?do=edit&usergroupid=10
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.51a-community-log

[EagleNick]

It is from a Modification you have installed.

"mgc_cb_evo_permissions" is not a default column in vBulletin.

You need to uninstall whatever plugin that is.

--------------- Added 1216583670 at 1216583670 ---------------

My reply at vbulletin.com shows what you normall would do though:
http://www.vbulletin.com/forum/showthread.php?t=279305

[Opserty]

A bitfield_*.xml file in includes/xml directory, which belongs to whichever modification you recently uninstalled, needs to be removed.

(You could have found this from a search).

[Dismounted]

(You could have found this from a search).
And many, many times, as well.

[MalluCastle]

Thankyou verymuch guys really appreciate ur help