I recently found that I get database errors anytime I attempt to make usergroup permission changes on all users Here is the error listed below.. Anyone one know what is causing this and how to fix it ?
HTML Code:
Database error in vBulletin 3.5.3:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Moderators',
`description` = '',
`usertitle` = 'Moderator',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`anymediapermissions` = '3',
`ecdownloadpermissions` = '2527',
`ecexcludecatlist` = '',
`ecdownloadsmaxuploadtotal` = '10',
`ecdownloadsmaxdailydl` = '-1',
`ecdownloadsmaxdailyfiles` = '-1',
`ecdownloaddelaygrp` = '-1',
`glossarypermissions` = '1',
`itraderpermissions` = '3',
`forumpermissions` = '1074790399',
`attachlimit` = '3145728',
`profileviewpermissions` = '0',
`vbarticles` = '511',
`pmquota` = '300',
`pmpermissions` = '1',
`pmsendmax` = '10',
`calendarpermissions` = '63',
`wolpermissions` = '11',
`adminpermissions` = '0',
`genericpermissions` = '204060631',
`genericoptions` = '15',
`profilepicmaxwidth` = '200',
`profilepicmaxheight` = '250',
`profilepicmaxsize` = '25600',
`avatarmaxwidth` = '90',
`avatarmaxheight` = '90',
`avatarmaxsize` = '20000'
WHERE usergroupid=7;
MySQL Error : Unknown column 'profileviewpermissions' in 'field list'
Error Number : 1054
Date : Friday, July 4th 2008 @ 03:29:40 PM
Script : http://www.mysite.com/forums/admincp/usergroup.php
Referrer : http://www.mysite.com/forums/admincp/usergroup.php?do=edit&usergroupid=7
IP Address : 67.59.x.x
Username : Admin
Classname : vb_database