[Ranger187]

Originally Posted by angeljs

Hi, not sure where I should be posting this, so feel free to point me to the correct forum.

I've recently upgraded to vBulletin 4. I uninstalled all plugins beforehand and everything seemed to go well. However, now when I try to update the usergroups, I receive the following message (see the error marked in red):

Database error in vBulletin 4.0.1:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    `title` = 'Administrators',
    `description` = '',
    `usertitle` = 'Administrator',
    `opentag` = '',
    `closetag` = '',
    `passwordexpires` = '180',
    `passwordhistory` = '360',
    `mgc_cb_evo_permissions` = '0',
    `mgc_cb_evo_refreshrate` = '30',
    `mgc_cb_evo_nbmsg_show` = '',
    `mgc_cb_evo_nbmsg_perday_show` = '',
    `mgc_cb_evo_nbthreads_perday_show` = '0',
    `mgc_cb_evo_max_chats_perday` = '0',
    `ecs_amazon_store_permissions` = '0',
    `ms_imageshack_upload_permissions` = '0',
    `vbblog_general_permissions` = '524286',
    `vbblog_customblocks` = '10',
    `vbblog_custompages` = '10',
    `vbblog_entry_permissions` = '24575',
    `vbblog_comment_permissions` = '990',
    `forumpermissions` = '16777215',
    `genericpermissions` = '2147483583',
    `attachlimit` = '0',
    `pmquota` = '50',
    `pmpermissions` = '7',
    `pmsendmax` = '5',
    `pmthrottlequantity` = '0',
    `calendarpermissions` = '63',
    `wolpermissions` = '31',
    `adminpermissions` = '3',
    `genericpermissions2` = '1',
    `genericoptions` = '55',
    `profilepicmaxwidth` = '100',
    `profilepicmaxheight` = '100',
    `profilepicmaxsize` = '65535',
    `avatarmaxwidth` = '80',
    `avatarmaxheight` = '80',
    `avatarmaxsize` = '20000',
    `signaturepermissions` = '245759',
    `sigpicmaxwidth` = '500',
    `sigpicmaxheight` = '100',
    `sigpicmaxsize` = '10000',
    `sigmaxrawchars` = '0',
    `sigmaxchars` = '0',
    `sigmaxlines` = '0',
    `sigmaxsizebbcode` = '7',
    `sigmaximages` = '0',
    `albumpermissions` = '255',
    `albumpicmaxwidth` = '600',
    `albumpicmaxheight` = '600',
    `albummaxpics` = '100',
    `albummaxsize` = '0',
    `usercsspermissions` = '63',
    `visitormessagepermissions` = '63',
    `socialgrouppermissions` = '262143',
    `maximumsocialgroups` = '5',
    `groupiconmaxsize` = '65535',
    `addonchat_general` = '18427',
    `addonchat_ugp_icon` = '2',
    `addonchat_ugp_post_delay` = '0',
    `addonchat_ugp_max_msg_length` = '2048',
    `addonchat_ugp_level` = '5',
    `addonchat_admin` = '16777087',
    `addonchat_moderator` = '12',
    `addonchat_rac` = '3'
WHERE usergroupid=6;

MySQL Error   : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number  : 1054
Request Date  : Sunday, January 17th 2010 @ 08:56:35 PM
Error Date    : Sunday, January 17th 2010 @ 08:56:35 PM
Script        : http://simfansuk.com/forums/admincp/usergroup.php?do=update
Referrer      : http://simfansuk.com/forums/admincp/usergroup.php?do=edit&usergroupid=6
IP Address    : 90.209.238.254
Username      : LadyAngel
Classname     : vB_Database
MySQL Version : 5.0.85-community

The reason I've posted this here, is because it looks as though this mod hasn't uninstalled properly? Not sure what to do.

Uninstall MGC Chat, it's not compatible with VB4.