PDA

View Full Version : Cant save Usergroup settings after upgrade to vB3.7.0 RC2



Rukas
Fri 4th Apr '08, 12:21pm
Ive upgraded and in the process I got rid of some of the plug ins I had installed, one of them was the chat. Unfortunately even though it has been deleted the settings table is there at the bottom of the usergroup, even though it is blank, and when I save I get the following database error:


Database error in vBulletin 3.7.0 Release Candidate 2:

Invalid SQL:
UPDATE vbusergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`vbtube` = '0',
`forumpermissions` = '3928575',
`genericpermissions` = '1516770503',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '360',
`profilepicmaxheight` = '560',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '137215',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '2000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '31',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '375',
`mgccustomusergroupperms` = '64',
`nbmsgshowchatbox` = ''
WHERE usergroupid=2;

MySQL Error : Unknown column 'mgccustomusergroupperms' in 'field list'
Error Number : 1054
Date : Friday, April 4th 2008 @ 12:17:50 PM
Script : http://www.**************.com/forums/admincp/usergroup.php?do=update
Referrer : http://www.**************.com/forums/admincp/usergroup.php?do=edit&usergroupid=2
IP Address : **************
Username : **************
Classname : vb_database
MySQL Version : 4.1.22-standard

Wayne Luke
Fri 4th Apr '08, 12:45pm
This is caused by a custom addon for additional permissions. You need to contact the author of that addon or delete its XML file from includes/XML.

Rukas
Fri 4th Apr '08, 10:12pm
or delete its XML file from includes/XML.

Perfect thats all I wanted to know is how to get rid of it.