Log in

View Full Version : Database error affecting usergroup 2 permissions


iNRoC
08-02-2008, 01:55 PM
I need some help with this error.

It happened after I uninstalled the MGC Chatbox.

https://vborg.vbsupport.ru/external/2008/08/76.jpg

Heres the error code..


Database error in vBulletin 3.7.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '3928575',
`genericpermissions` = '1579685063',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`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',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '31',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '375',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = ''
WHERE usergroupid=2;

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Saturday, August 2nd 2008 @ 08:54:16 AM
Error Date : Saturday, August 2nd 2008 @ 08:54:16 AM
Script : http://www.uwhack.com/forum/admincp/usergroup.php?do=update
Referrer : http://www.uwhack.com/forum/admincp/usergroup.php?do=edit&usergroupid=2
IP Address :
Username : iNRoC
Classname : vB_Database
MySQL Version : 5.0.45-community-log

nexialys
08-02-2008, 02:04 PM
you have MGC Chatbox installed, it's clear if you read the error...

if you did not intalled OR uninstalled ALL THE FILES from this hack, the error will continue to occur...

read the documentation for that addon.

(it's actually the bitfield file from that addon that need to be removed)

Opserty
08-02-2008, 02:15 PM
Did you use the search feature?

Here is what I found:
Adding New user group (https://vborg.vbsupport.ru/showthread.php?t=185864&highlight=mgc_cb_evo_permissions)
Cant Edit UserGroups :( (https://vborg.vbsupport.ru/showthread.php?t=185839&highlight=mgc_cb_evo_permissions)
Database Error in usergroup manager (https://vborg.vbsupport.ru/showthread.php?t=171950&highlight=mgc_cb_evo_permissions)
Usergroup Addition issue (https://vborg.vbsupport.ru/showthread.php?t=173009&highlight=mgc_cb_evo_permissions)
Modifing User Group Error (https://vborg.vbsupport.ru/showthread.php?t=172878&highlight=mgc_cb_evo_permissions)
Weird problem (https://vborg.vbsupport.ru/showthread.php?t=171933&highlight=mgc_cb_evo_permissions)
Error updating usergroups? (https://vborg.vbsupport.ru/showthread.php?t=171797&highlight=mgc_cb_evo_permissions)
problem.. (https://vborg.vbsupport.ru/showthread.php?t=171305&highlight=mgc_cb_evo_permissions)

iNRoC
08-02-2008, 02:30 PM
Ok i fixed it. I removed the mgc bitfield