(fixed) edit usergroup = mysql error

[karlm]

Database error in vBulletin 3.6.7:

Invalid SQL:
UPDATE vbusergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    `title` = 'Comfirmed Members',
    `description` = '1+ posts',
    `usertitle` = 'MAF Member',
    `opentag` = '',
    `closetag` = '',
    `passwordexpires` = '0',
    `passwordhistory` = '0',
    `ispublicgroup` = '0',
    `canoverride` = '1',
    `forumpermissions` = '782463',
    `genericpermissions` = '44570307',
    `attachlimit` = '0',
    `pmquota` = '50',
    `pmpermissions` = '1',
    `pmsendmax` = '5',
    `calendarpermissions` = '55',
    `wolpermissions` = '1',
    `adminpermissions` = '0',
    `genericoptions` = '62',
    `profilepicmaxwidth` = '100',
    `profilepicmaxheight` = '100',
    `profilepicmaxsize` = '102400',
    `avatarmaxwidth` = '100',
    `avatarmaxheight` = '100',
    `avatarmaxsize` = '102400',
    `signaturepermissions` = '0',
    `sigpicmaxwidth` = '0',
    `sigpicmaxheight` = '0',
    `sigpicmaxsize` = '0',
    `sigmaxrawchars` = '0',
    `sigmaxchars` = '0',
    `sigmaxlines` = '0',
    `sigmaxsizebbcode` = '0',
    `sigmaximages` = '0',
    `profileviewpermissions` = '0'
WHERE usergroupid=25;

MySQL Error  : Unknown column 'profileviewpermissions' in 'field list'
Error Number : 1054
Date         : Thursday, June 7th 2007 @ 12:29:55 PM
Script       : http://antimisandry.com/xxx/usergroup.php?do=update
Referrer     : http://antimisandry.com/xxx/usergroup.php?do=edit&usergroupid=25
IP Address   : my.i.p.addy
Username     : admin
Classname    : vB_Database_MySQLi

This occurs on any attempt to edit a usergroup.

[karlm]

resolved... looking at the above, I realised it was from a plugin I'd been using - yet I hadn't installed it on this installation. I guess it was pulled over during the impex transfer. weird.
Anyway, all sorted