Log in

View Full Version : I Keep getting this error when i try to edit the usergroups


Mancunian_Red
10-30-2008, 09:58 PM
Database error in vBulletin 3.7.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Subscriber',
`description` = 'Site Supporter',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = '',
`forumpermissions` = '3928575',
`genericpermissions` = '1579687875',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '120',
`avatarmaxheight` = '120',
`avatarmaxsize` = '20000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '65535',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '31',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '375'
WHERE usergroupid=11;

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Thursday, October 30th 2008 @ 05:53:26 PM
Error Date : Thursday, October 30th 2008 @ 05:53:26 PM
Script : http://www.techwars.co.uk/admincp/usergroup.php?do=update
Referrer : http://www.techwars.co.uk/admincp/usergroup.php?do=edit&usergroupid=11
IP Address : 217.171.129.68
Username : Mancunian_Red
Classname : vB_Database
MySQL Version : 5.0.51a-community




I do not know anything about MySQL how do i go about getting this fixed anyone know?

Dismounted
10-31-2008, 06:00 AM
You have recently uninstalled a modification and have not removed its files, specifically, a bitfield_*.xml inside the /includes/xml directory.

Mancunian_Red
10-31-2008, 03:56 PM
Thanks for the pointer worked a treat i deleted some left over files from the xml folder and presto it worked thank you once again eternally grateful