chozoicgod
09-09-2007, 12:05 AM
I think the following database error is caused by MGC Chatbox, i can't edit any usergroups because of this.
Database error in vBulletin 3.6.8:
Invalid SQL:
UPDATE vb_usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Unregistered / Not Logged In',
`description` = '',
`usertitle` = 'Guest User (Restricted Access)',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`arcadepermissions` = '1',
`minpoststoplay` = '0',
`minreptoplay` = '-1000',
`minreglengthtoplay` = '0',
`credit_induction` = '100',
`credit_referral` = '100',
`credit_refbonus` = '0.05',
`credit_daily` = '0',
`credit_active` = '10',
`credit_birthday` = '100',
`credit_repgive` = '0.1',
`credit_reppos` = '10',
`credit_repneg` = '-15',
`credit_thread` = '20',
`credit_threadrate` = '5',
`credit_post` = '5',
`credit_ownthreadpost` = '3',
`credit_postsize` = '0.1',
`credit_pollmake` = '10',
`credit_pollvote` = '3',
`credit_unthread` = '-20',
`credit_unpost` = '-5',
`creditpermissions` = '0',
`mgccustomusergroupperms` = '0',
`nbmsgshowchatbox` = '',
`forumpermissions` = '655367',
`genericpermissions` = '0',
`pmquota` = '50',
`pmpermissions` = '0',
`pmsendmax` = '0',
`calendarpermissions` = '1',
`wolpermissions` = '0',
`genericoptions` = '32',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '0',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`adminpermissions` = '0'
WHERE usergroupid=1;
MySQL Error : Unknown column 'mgccustomusergroupperms' in 'field list'
Error Number : 1054
Date : Saturday, September 8th 2007 @ 07:41:07 PM
Script : http://forsakenlegend.net/forum/vbtn_admincp/usergroup.php?do=update
Referrer : http://forsakenlegend.net/forum/vbtn_admincp/usergroup.php?do=edit&usergroupid=1
IP Address : 58.105.105.244
Username : Lord of the Twilight
Classname : vb_database
Can anyone help, cause this is serious
Database error in vBulletin 3.6.8:
Invalid SQL:
UPDATE vb_usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Unregistered / Not Logged In',
`description` = '',
`usertitle` = 'Guest User (Restricted Access)',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`arcadepermissions` = '1',
`minpoststoplay` = '0',
`minreptoplay` = '-1000',
`minreglengthtoplay` = '0',
`credit_induction` = '100',
`credit_referral` = '100',
`credit_refbonus` = '0.05',
`credit_daily` = '0',
`credit_active` = '10',
`credit_birthday` = '100',
`credit_repgive` = '0.1',
`credit_reppos` = '10',
`credit_repneg` = '-15',
`credit_thread` = '20',
`credit_threadrate` = '5',
`credit_post` = '5',
`credit_ownthreadpost` = '3',
`credit_postsize` = '0.1',
`credit_pollmake` = '10',
`credit_pollvote` = '3',
`credit_unthread` = '-20',
`credit_unpost` = '-5',
`creditpermissions` = '0',
`mgccustomusergroupperms` = '0',
`nbmsgshowchatbox` = '',
`forumpermissions` = '655367',
`genericpermissions` = '0',
`pmquota` = '50',
`pmpermissions` = '0',
`pmsendmax` = '0',
`calendarpermissions` = '1',
`wolpermissions` = '0',
`genericoptions` = '32',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '0',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`adminpermissions` = '0'
WHERE usergroupid=1;
MySQL Error : Unknown column 'mgccustomusergroupperms' in 'field list'
Error Number : 1054
Date : Saturday, September 8th 2007 @ 07:41:07 PM
Script : http://forsakenlegend.net/forum/vbtn_admincp/usergroup.php?do=update
Referrer : http://forsakenlegend.net/forum/vbtn_admincp/usergroup.php?do=edit&usergroupid=1
IP Address : 58.105.105.244
Username : Lord of the Twilight
Classname : vb_database
Can anyone help, cause this is serious