When i am in my admin control panel, and i make changes to the usersgroup and then i save them, i get this Error below, can anyone tell me why this is happening? Database error in vBulletin 3.8.6: Invalid SQL: UPDATE usergroup SET ### UPDATE QUERY GENERATED BY fetch_query_sql() ### `title` = 'Juniors', `description` = '', `usertitle` = '<b><font color=\"#00b4ff\">Probationr</b></font>', `opentag` = '<span style=\"color:#00b4ff;\">', `closetag` = '</span>', `passwordexpires` = '0', `passwordhistory` = '0', `ispublicgroup` = '0', `canoverride` = '0', `forumpermissions` = '655363', `genericpermissions` = '0', `attachlimit` = '1000000', `pmquota` = '0', `pmpermissions` = '0', `pmsendmax` = '5', `pmthrottlequantity` = '0', `calendarpermissions` = '0', `wolpermissions` = '0', `adminpermissions` = '0', `genericpermissions2` = '0', `genericoptions` = '32', `profilepicmaxwidth` = '100', `profilepicmaxheight` = '100', `profilepicmaxsize` = '25000', `avatarmaxwidth` = '50', `avatarmaxheight` = '50', `avatarmaxsize` = '20000', `signaturepermissions` = '0', `sigpicmaxwidth` = '0', `sigpicmaxheight` = '0', `sigpicmaxsize` = '0', `sigmaxrawchars` = '0', `sigmaxchars` = '0', `sigmaxlines` = '0', `sigmaxsizebbcode` = '7', `sigmaximages` = '0', `albumpermissions` = '0', `albumpicmaxwidth` = '0', `albumpicmaxheight` = '0', `albumpicmaxsize` = '0', `albummaxpics` = '0', `albummaxsize` = '0', `usercsspermissions` = '0', `visitormessagepermissions` = '16', `socialgrouppermissions` = '0', `maximumsocialgroups` = '0', `groupiconmaxsize` = '0', `dbtech_vbshoutpermissions` = '0', `akvbghsfs_akismet_permissions` = '0' WHERE usergroupid=12; MySQL Error : Unknown column 'akvbghsfs_akismet_permissions' in 'field list' Error Number : 1054 Request Date : Monday, October 25th 2010 @ 11:48:15 AM Error Date : Monday, October 25th 2010 @ 11:48:15 AM Script : http://spiderswc.com/admincp/usergroup.php?do=update Referrer : http://spiderswc.com/admincp/usergroup.php?do=edit&usergroupid=12 IP Address : 120.18.53.19 Username : SᴩiDᴇЯ Classname : vB_Database MySQL Version : 5.0.91-community-log PHP:
It looks as though your admin panel is trying to update a column named "akvbghsfs_akismet_permissions" which doesn't exist on the usergroup table.
Thank you Bigcats82 you were right we created the column and now all is fixed, thank you for your input.