PDA

View Full Version : DB error on save usergroups premissions


elenh
02-24-2010, 03:25 PM
Database error in vBulletin 4.0.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<span style=\"color:black\">',
`closetag` = '</span>',
`passwordexpires` = '180',
`passwordhistory` = '360',
`forumpermissions` = '16777215',
`genericpermissions` = '2113929151',
`attachlimit` = '0',
`pmquota` = '1000',
`pmpermissions` = '7',
`pmsendmax` = '20',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '1',
`genericoptions` = '54',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '150',
`avatarmaxheight` = '180',
`avatarmaxsize` = '20000',
`signaturepermissions` = '245759',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '65535',
`sigmaxchars` = '65535',
`sigmaxlines` = '1000',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '1000',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '262143',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_refreshrate` = '10',
`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',
`gcbos_permissions` = '2047'
WHERE usergroupid=6;

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Wednesday, February 24th 2010 @ 07:23:30 PM
Error Date : Wednesday, February 24th 2010 @ 07:23:30 PM
Script : ***********/admincp/usergroup.php?do=update
Referrer : ***********/admincp/usergroup.php?do=edit&usergroupid=6
IP Address : ***********
Username : ***********
Classname : vB_Database
MySQL Version : 5.1.33

Like i see the talk about mgc_cb_evo_permissions my old chatbox.I have unistalled id before a week.
What can i do?

Lynne
02-24-2010, 08:41 PM
Go back to the modification thread and read the install instructions and do them backwards. You have not completely uninstalled this modification.

elenh
03-01-2010, 06:39 AM
Okay the problem i forget to remove the files from root. Can you make me a favorite please lynne? Can read my post on the Articels section for vb 4 about the css two columns?

Thank you.