PDA

View Full Version : Error updating usergroups?


steven1091
03-01-2008, 12:15 PM
When i try updating a usergroup i get this database error:

Database error in vBulletin 3.7.0 Beta 5:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Community Director',
`description` = 'Community Director',
`usertitle` = 'Community Director',
`opentag` = '<b><font color=\"#FF3300\">',
`closetag` = '</font></b>',
`passwordexpires` = '72',
`passwordhistory` = '365',
`ispublicgroup` = '0',
`canoverride` = '1',
`awardpermissions` = '1',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = '',
`forumpermissions` = '8126455',
`genericpermissions` = '1089025739',
`attachlimit` = '1000000',
`pmquota` = '100',
`pmpermissions` = '0',
`pmsendmax` = '15',
`calendarpermissions` = '31',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '45',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '25000',
`avatarmaxwidth` = '50',
`avatarmaxheight` = '50',
`avatarmaxsize` = '20000',
`signaturepermissions` = '237563',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '1000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '1000',
`sigmaxlines` = '7',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '127',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '31',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '255',
`unreq_perms` = '0'
WHERE usergroupid=9;

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Date : Saturday, March 1st 2008 @ 02:12:47 PM
Script : http://habbovalley.com/admincp/usergroup.php?do=update
Referrer : http://habbovalley.com/admincp/usergroup.php?do=edit&usergroupid=9
IP Address : 82.2.137.98
Username : Blured
Classname : vb_database
MySQL Version : 4.1.22-standard

Would be much appreciated if someone could tell me how to fix this

Paul M
03-01-2008, 03:23 PM
Remove the bitfield file from your xml folder that belongs to the mgc mod you have removed.

Marco van Herwaarden
03-02-2008, 07:16 AM
Also asked and answered here: https://vborg.vbsupport.ru/showthread.php?t=171797

Please don't start duplicate threads. Closing this one.