Madbatty
09-06-2009, 12:06 PM
I recieve the following error message when I try to updated a user group
Database error in vBulletin 3.8.2:
Invalid SQL:
UPDATE vb_usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Crew',
`description` = 'Design Group',
`usertitle` = '',
`opentag` = '<b><span style=\'color:Blue\'>',
`closetag` = '</span></b>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`forumpermissions` = '16777207',
`genericpermissions` = '2112749567',
`attachlimit` = '0',
`pmquota` = '200',
`pmpermissions` = '3',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '29',
`adminpermissions` = '1',
`genericpermissions2` = '1',
`genericoptions` = '56',
`profilepicmaxwidth` = '500',
`profilepicmaxheight` = '300',
`profilepicmaxsize` = '80000',
`avatarmaxwidth` = '150',
`avatarmaxheight` = '150',
`avatarmaxsize` = '30000',
`signaturepermissions` = '235775',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '300',
`sigpicmaxsize` = '0',
`sigmaxrawchars` = '500',
`sigmaxchars` = '300',
`sigmaxlines` = '3',
`sigmaxsizebbcode` = '5',
`sigmaximages` = '0',
`albumpermissions` = '255',
`albumpicmaxwidth` = '1024',
`albumpicmaxheight` = '1024',
`albumpicmaxsize` = '1000000',
`albummaxpics` = '120',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '47',
`socialgrouppermissions` = '65535',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '80000',
`profileviewpermissions` = '0',
`fcpermissions` = '4',
`minpoststoplay` = '0',
`minreptoplay` = '-1000',
`minreglengthtoplay` = '0'
WHERE usergroupid=10;
MySQL Error : Unknown column 'profileviewpermissions' in 'field list'
Error Number : 14
Request Date : xxxxxxxxxxxxx
Error Date : xxxxxxxxxxxxx
Script : /admincp/usergroup.php?do=update
Referrer : /admincp/usergroup.php?do=edit&usergroupid=10
IP Address : xxxxxxxxxxxxxx
Username : xxxxxxxxxxxxxx
Classname : vB_Database
MySQL Version : 5.0.67-userstats-log
Can someone please tell me how to get rid of that? Thx!
Database error in vBulletin 3.8.2:
Invalid SQL:
UPDATE vb_usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Crew',
`description` = 'Design Group',
`usertitle` = '',
`opentag` = '<b><span style=\'color:Blue\'>',
`closetag` = '</span></b>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`forumpermissions` = '16777207',
`genericpermissions` = '2112749567',
`attachlimit` = '0',
`pmquota` = '200',
`pmpermissions` = '3',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '29',
`adminpermissions` = '1',
`genericpermissions2` = '1',
`genericoptions` = '56',
`profilepicmaxwidth` = '500',
`profilepicmaxheight` = '300',
`profilepicmaxsize` = '80000',
`avatarmaxwidth` = '150',
`avatarmaxheight` = '150',
`avatarmaxsize` = '30000',
`signaturepermissions` = '235775',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '300',
`sigpicmaxsize` = '0',
`sigmaxrawchars` = '500',
`sigmaxchars` = '300',
`sigmaxlines` = '3',
`sigmaxsizebbcode` = '5',
`sigmaximages` = '0',
`albumpermissions` = '255',
`albumpicmaxwidth` = '1024',
`albumpicmaxheight` = '1024',
`albumpicmaxsize` = '1000000',
`albummaxpics` = '120',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '47',
`socialgrouppermissions` = '65535',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '80000',
`profileviewpermissions` = '0',
`fcpermissions` = '4',
`minpoststoplay` = '0',
`minreptoplay` = '-1000',
`minreglengthtoplay` = '0'
WHERE usergroupid=10;
MySQL Error : Unknown column 'profileviewpermissions' in 'field list'
Error Number : 14
Request Date : xxxxxxxxxxxxx
Error Date : xxxxxxxxxxxxx
Script : /admincp/usergroup.php?do=update
Referrer : /admincp/usergroup.php?do=edit&usergroupid=10
IP Address : xxxxxxxxxxxxxx
Username : xxxxxxxxxxxxxx
Classname : vB_Database
MySQL Version : 5.0.67-userstats-log
Can someone please tell me how to get rid of that? Thx!