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 [DATE]1216583670[/DATE] at [TIME]1216583670[/TIME] ---------------

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]

Originally Posted by Opserty

(You could have found this from a search).

And many, many times, as well.

[MalluCastle]

Thankyou verymuch guys really appreciate ur help