Originally Posted by angeljs
(Post 1958494)
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):
Code:
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. :o
|