dhruv96
05-29-2011, 02:04 PM
Whenever i try to complete any sort of update within the admincp regarding usergroups , permissions, subscription addons and such, i get the following error :
Database error in vBulletin 4.1.3:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Premium Members',
`description` = '',
`usertitle` = 'WRM Supporter',
`opentag` = '<span style=\'color:#0066FF\'><b>',
`closetag` = '</span></b>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`dbtech_vbshoutpermissions` = '2',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_refreshrate` = '30',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = '',
`mgc_cb_evo_nbthreads_perday_show` = '0',
`mgc_cb_evo_max_chats_perday` = '0',
`forumpermissions` = '12317183',
`genericpermissions` = '1579685063',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '137215',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '55159',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535'
WHERE usergroupid=9;
MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Sunday, May 29th 2011 @ 10:55:28 AM
Error Date : Sunday, May 29th 2011 @ 10:55:28 AM
Script : http://streamsdirect.net/forums/admincp/usergroup.php?do=update
Referrer : http://streamsdirect.net/forums/admincp/usergroup.php?do=edit&usergroupid=9
IP Address : 173.32.120.22
Username : Matador
Classname : vB_Database
MySQL Version : 5.1.49-log
Any idea what exactly the issue is and how it can be fixed?
Thanks in advance.
Database error in vBulletin 4.1.3:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Premium Members',
`description` = '',
`usertitle` = 'WRM Supporter',
`opentag` = '<span style=\'color:#0066FF\'><b>',
`closetag` = '</span></b>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`dbtech_vbshoutpermissions` = '2',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_refreshrate` = '30',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = '',
`mgc_cb_evo_nbthreads_perday_show` = '0',
`mgc_cb_evo_max_chats_perday` = '0',
`forumpermissions` = '12317183',
`genericpermissions` = '1579685063',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '137215',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '55159',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535'
WHERE usergroupid=9;
MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Sunday, May 29th 2011 @ 10:55:28 AM
Error Date : Sunday, May 29th 2011 @ 10:55:28 AM
Script : http://streamsdirect.net/forums/admincp/usergroup.php?do=update
Referrer : http://streamsdirect.net/forums/admincp/usergroup.php?do=edit&usergroupid=9
IP Address : 173.32.120.22
Username : Matador
Classname : vB_Database
MySQL Version : 5.1.49-log
Any idea what exactly the issue is and how it can be fixed?
Thanks in advance.