Well before i updated to 3.8 i had an mgc evo chatbox. I uninstalled it , well at least i think i did and even then when i removed its files in my admin cp i still have a line with Chatbox and options which actually point to nothing. The thing that is most annoying is that i can't edit or create new usergroups because of it. When i try to save a new usergroup it gives me a database error which i can't really explain it to my puny brain...
This is a sample of the error when you change lets say Super moderators....
I see that what gives me problem is the former chatboxses options which now are not used , because it is uninstalled...
Anyways is there any way to fix excluding database backup , because that will set the forums months ago.
So maybe by a MySQL query or some edit? Honnestly i think it will have to do something with MySQL, but i have no idea how to use queries and anything about them, you can say im blind to mySQL. I would be very greatfull to anyhelp at all..
Anyone?
This is a sample of the error when you change lets say Super moderators....
Database error in vBulletin 3.8.0 Beta 4:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Super Moderators',
`description` = '',
`usertitle` = 'Super Moderator',
`opentag` = '<font color=\"lightgreen\">',
`closetag` = '</font>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '16777215',
`genericpermissions` = '1575966415',
`attachlimit` = '0',
`pmquota` = '100',
`pmpermissions` = '7',
`pmsendmax` = '0',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '15',
`adminpermissions` = '1',
`genericpermissions2` = '1',
`genericoptions` = '63',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '237567',
`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` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '65535',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = '',
`ms_vopt_permissions` = '3'
WHERE usergroupid=5;
MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Thursday, December 11th 2008 @ 11:52:33 AM
Error Date : Thursday, December 11th 2008 @ 11:52:33 AM
Script : http://*****/forum/admincp/usergroup.php?do=update
Referrer : http://*****/forum/admincp/usergroup.php?do=edit&usergroupid=5
IP Address : ******
Username : ShadoW
Classname : vB_Database
MySQL Version : 5.0.67-community-log
I see that what gives me problem is the former chatboxses options which now are not used , because it is uninstalled...
Anyways is there any way to fix excluding database backup , because that will set the forums months ago.
So maybe by a MySQL query or some edit? Honnestly i think it will have to do something with MySQL, but i have no idea how to use queries and anything about them, you can say im blind to mySQL. I would be very greatfull to anyhelp at all..
Anyone?