NoKSouLz
02-27-2009, 12:23 PM
For some unknown reason over the last week or so i have been recieving the same error messages when trying to update certain settings.
For example i was creating a new usergroup and i recieve the following error:
Database error in vBulletin 3.8.0:
Invalid SQL:
### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO usergroup
(`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `mgc_cb_evo_permissions`, `mgc_cb_evo_refreshrate`, `mgc_cb_evo_nbmsg_show`, `mgc_cb_evo_nbmsg_perday_show`, `mgc_cb_evo_max_chats_perday`, `radiotvpermissions`, `forumpermissions`, `genericpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `pmthrottlequantity`, `calendarpermissions`, `wolpermissions`, `adminpermissions`, `genericpermissions2`, `genericoptions`, `profilepicmaxwidth`, `profilepicmaxheight`, `profilepicmaxsize`, `avatarmaxwidth`, `avatarmaxheight`, `avatarmaxsize`, `signaturepermissions`, `sigpicmaxwidth`, `sigpicmaxheight`, `sigpicmaxsize`, `sigmaxrawchars`, `sigmaxchars`, `sigmaxlines`, `sigmaxsizebbcode`, `sigmaximages`, `albumpermissions`, `albumpicmaxwidth`, `albumpicmaxheight`, `albumpicmaxsize`, `albummaxpics`, `albummaxsize`, `usercsspermissions`, `visitormessagepermissions`, `socialgrouppermissions`, `maximumsocialgroups`, `groupiconmaxsize`, `arcadepermissions`, `minpoststoplay`, `minreptoplay`, `minreglengthtoplay`, `unreq_perms`, `postsforurls`, `vbimghost`, `vbimghost_upslots`, `vbimghost_files`)
VALUES
('XL Staff', '', 'XL Staff', '<font color=\"#CCCC00\">', '</font>', '', '', '0', '0', '0', '', '', '', '', '0', '8126455', '1827149443', '1000000', '500', '0', '5', '', '63', '1', '0', '0', '41', '100', '100', '25000', '50', '50', '20000', '245759', '', '', '', '', '', '', '7', '', '0', '', '', '', '', '', '0', '0', '0', '', '', '255', '', '', '', '3', '', '3', '', '');
MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Friday, February 27th 2009 @ 08:21:52 AM
Error Date : Friday, February 27th 2009 @ 08:21:52 AM
Script : http://www.gow2forum.co.uk/admincp/usergroup.php?do=update
Referrer : http://www.gow2forum.co.uk/admincp/usergroup.php?do=add
IP Address : 90.198.81.199
Username : SouLz
Classname : vB_Database
MySQL Version : 5.0.67-community
Any idea whats wrong?
Alec
--------------- Added 1235744898 at 1235744898 ---------------
Problem solved, i removed the bitfield XML out of the XML folder on my forum.
Anyone else having the same problem, then its your XML folder
For example i was creating a new usergroup and i recieve the following error:
Database error in vBulletin 3.8.0:
Invalid SQL:
### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO usergroup
(`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `mgc_cb_evo_permissions`, `mgc_cb_evo_refreshrate`, `mgc_cb_evo_nbmsg_show`, `mgc_cb_evo_nbmsg_perday_show`, `mgc_cb_evo_max_chats_perday`, `radiotvpermissions`, `forumpermissions`, `genericpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `pmthrottlequantity`, `calendarpermissions`, `wolpermissions`, `adminpermissions`, `genericpermissions2`, `genericoptions`, `profilepicmaxwidth`, `profilepicmaxheight`, `profilepicmaxsize`, `avatarmaxwidth`, `avatarmaxheight`, `avatarmaxsize`, `signaturepermissions`, `sigpicmaxwidth`, `sigpicmaxheight`, `sigpicmaxsize`, `sigmaxrawchars`, `sigmaxchars`, `sigmaxlines`, `sigmaxsizebbcode`, `sigmaximages`, `albumpermissions`, `albumpicmaxwidth`, `albumpicmaxheight`, `albumpicmaxsize`, `albummaxpics`, `albummaxsize`, `usercsspermissions`, `visitormessagepermissions`, `socialgrouppermissions`, `maximumsocialgroups`, `groupiconmaxsize`, `arcadepermissions`, `minpoststoplay`, `minreptoplay`, `minreglengthtoplay`, `unreq_perms`, `postsforurls`, `vbimghost`, `vbimghost_upslots`, `vbimghost_files`)
VALUES
('XL Staff', '', 'XL Staff', '<font color=\"#CCCC00\">', '</font>', '', '', '0', '0', '0', '', '', '', '', '0', '8126455', '1827149443', '1000000', '500', '0', '5', '', '63', '1', '0', '0', '41', '100', '100', '25000', '50', '50', '20000', '245759', '', '', '', '', '', '', '7', '', '0', '', '', '', '', '', '0', '0', '0', '', '', '255', '', '', '', '3', '', '3', '', '');
MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Friday, February 27th 2009 @ 08:21:52 AM
Error Date : Friday, February 27th 2009 @ 08:21:52 AM
Script : http://www.gow2forum.co.uk/admincp/usergroup.php?do=update
Referrer : http://www.gow2forum.co.uk/admincp/usergroup.php?do=add
IP Address : 90.198.81.199
Username : SouLz
Classname : vB_Database
MySQL Version : 5.0.67-community
Any idea whats wrong?
Alec
--------------- Added 1235744898 at 1235744898 ---------------
Problem solved, i removed the bitfield XML out of the XML folder on my forum.
Anyone else having the same problem, then its your XML folder