Rukas
Fri 4th Apr '08, 12:21pm
Ive upgraded and in the process I got rid of some of the plug ins I had installed, one of them was the chat. Unfortunately even though it has been deleted the settings table is there at the bottom of the usergroup, even though it is blank, and when I save I get the following database error:
Database error in vBulletin 3.7.0 Release Candidate 2:
Invalid SQL:
UPDATE vbusergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`vbtube` = '0',
`forumpermissions` = '3928575',
`genericpermissions` = '1516770503',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '360',
`profilepicmaxheight` = '560',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '137215',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '2000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '31',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '375',
`mgccustomusergroupperms` = '64',
`nbmsgshowchatbox` = ''
WHERE usergroupid=2;
MySQL Error : Unknown column 'mgccustomusergroupperms' in 'field list'
Error Number : 1054
Date : Friday, April 4th 2008 @ 12:17:50 PM
Script : http://www.**************.com/forums/admincp/usergroup.php?do=update
Referrer : http://www.**************.com/forums/admincp/usergroup.php?do=edit&usergroupid=2
IP Address : **************
Username : **************
Classname : vb_database
MySQL Version : 4.1.22-standard
Database error in vBulletin 3.7.0 Release Candidate 2:
Invalid SQL:
UPDATE vbusergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`vbtube` = '0',
`forumpermissions` = '3928575',
`genericpermissions` = '1516770503',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '360',
`profilepicmaxheight` = '560',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '137215',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '2000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '31',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '375',
`mgccustomusergroupperms` = '64',
`nbmsgshowchatbox` = ''
WHERE usergroupid=2;
MySQL Error : Unknown column 'mgccustomusergroupperms' in 'field list'
Error Number : 1054
Date : Friday, April 4th 2008 @ 12:17:50 PM
Script : http://www.**************.com/forums/admincp/usergroup.php?do=update
Referrer : http://www.**************.com/forums/admincp/usergroup.php?do=edit&usergroupid=2
IP Address : **************
Username : **************
Classname : vb_database
MySQL Version : 4.1.22-standard