I get this MySQL error when I try to edit user group permissions to use it and try to uninstall it as a product.
Code:
Database error in vBulletin 3.6.0:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = '',
`opentag` = '<font color=\"red\"><b>',
`closetag` = '</b></font>',
`passwordexpires` = '180',
`passwordhistory` = '360',
`forumpermissions` = '1048575',
`genericpermissions` = '1073741759',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '7',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericoptions` = '55',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '245759',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '2000',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`adoptpermissions` = '15',
`maxadopted` = '50',
`hkc_competition_permissions` = '3',
`vbppermissions` = '65529',
`vbp_discountrate` = '5.00000',
`vbp_paycheckamount` = '500.00000',
`vbp_secondarycost` = '0.00000',
`vbp_primarycost` = '0.00000'
WHERE usergroupid=6;
MySQL Error : Unknown column 'adoptpermissions' in 'field list'
Error Number : 1054
Date : Saturday, August 5th 2006 @ 07:01:50 PM
Script : http://www.limeo.co.uk/community/admincp/usergroup.php?do=update
Referrer : http://www.limeo.co.uk/community/admincp/usergroup.php?do=edit&usergroupid=6
IP Address : 84.68.246.195
Username : Squashter
Classname : vb_database
Can someone help?