I tired to uninstall, it left behind the blank tables in the usergroup permissions page along with this error when I try to update any permissions:
Database error in vBulletin 3.5.4:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '782591',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '49',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions` = '2799583',
`genericoptions` = '30',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '100000',
`avatarmaxwidth` = '150',
`avatarmaxheight` = '150',
`avatarmaxsize` = '25000',
`arcadepermissions` = '15',
`vbppermissions` = '30097',
`vbp_discountrate` = '0.00000',
`vbp_paycheckamount` = '1.00000',
`vbp_secondarycost` = '0.00000',
`vbp_primarycost` = '0.00000',
`vbspacecomments` = '0'
WHERE usergroupid=2;
MySQL Error : Unknown column 'vbspacecomments' in 'field list'
Error Number : 1054
Anyone know how to fix this?
|