Helpful Information
 
 
Category: vB4 General Discussions
I cant remove old modification

When i try update user premmisions i get this error !!!



Database error in vBulletin 4.0.0 Beta 3:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<font color=\"#C34A2C\"><b>',
`closetag` = '</b></font>',
`passwordexpires` = '180',
`passwordhistory` = '360',
`gcbos_permissions` = '0',
`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',
`vbcmspermissions` = '1',
`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` = '500',
`profilepicmaxheight` = '500',
`profilepicmaxsize` = '365535',
`avatarmaxwidth` = '200',
`avatarmaxheight` = '200',
`avatarmaxsize` = '450000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`albumpermissions` = '255',
`albumpicmaxwidth` = '1000',
`albumpicmaxheight` = '1000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '262143',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '365535',
`vbblog_general_permissions` = '524286',
`vbblog_customblocks` = '10',
`vbblog_custompages` = '10',
`vbblog_entry_permissions` = '24575',
`vbblog_comment_permissions` = '990'
WHERE usergroupid=6;

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Tuesday, November 17th 2009 @ 07:23:12 AM
Error Date : Tuesday, November 17th 2009 @ 07:23:13 AM
Script : http://minimalmelodies.com/admincp/usergroup.php?do=update
Referrer : http://minimalmelodies.com/admincp/usergroup.php?do=edit&usergroupid=6




the mod was removed long time ago , and he showing in usergroup premisions .. how to remove this error.

Please help:up:

includes/class_hook_mgccoding.php isn't a default file, so it's an outdated product. Disable all vB3 addons you have installed in the product manager (and double check the plugin manager for any "stray" plugins that aren't attached to a product and disable those as well).

thnx i solved that problem :) i got new one .. i just edited first post .. can u help me with this ?

Sounds like it has some stray files still being parsed.

My suggestion is to delete your includes/xml folder and re-upload it from the vB4 package.

hey THNX again , i removed mgc files from xml folder and used update bitfields :) thnx without you i could not remember that trick :)










privacy (GDPR)