[JuniorWU]

Well, today I was trying to edit a user group on my forum, but this error is happening and do not know how to solve!

see below what appears when I try to edit:

Database error in vBulletin 3.8.4:

Invalid SQL:
UPDATE vb_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Uploader',
`description` = '',
`usertitle` = 'Uploader',
`opentag` = '<span style=\"font-weight: bold; color: #692DAC;\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`mgccustomusergroupperms` = '0',
`nbmsgshowchatbox` = '',
`forumpermissions` = '6013175',
`genericpermissions` = '1276657603',
`attachlimit` = '0',
`pmquota` = '150',
`pmpermissions` = '4',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '0',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '63',
`profilepicmaxwidth` = '140',
`profilepicmaxheight` = '220',
`profilepicmaxsize` = '102400',
`avatarmaxwidth` = '150',
`avatarmaxheight` = '250',
`avatarmaxsize` = '102400',
`signaturepermissions` = '236799',
`sigpicmaxwidth` = '450',
`sigpicmaxheight` = '400',
`sigpicmaxsize` = '307200',
`sigmaxrawchars` = '1500',
`sigmaxchars` = '1000',
`sigmaxlines` = '6',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '55159',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535'
WHERE usergroupid=11;

MySQL Error : Unknown column 'mgccustomusergroupperms' in 'field list'
Error Number : 1054
Request Date : Monday, November 22nd 2010 @ 02:55:51 PM
Error Date : Monday, November 22nd 2010 @ 02:55:51 PM
Script : http://www.warezup.net/admincp/usergroup.php?do=update
Referrer : http://www.warezup.net/admincp/userg...usergroupid=11
IP Address : 187.40.197.189
Username : Raposo
Classname : vB_Database
MySQL Version : 5.0.91-community


Help-me please!!!!!!

[Lynne]

There is no field "mgccustomusergroupperms" in the table usergroup in default vbulletin. Your error is from a modification. Disable, or uninstall, the mod and it will go away.

[JuniorWU]

deactivated all plugins and to no avail =/...
is there any way to restore or recreate the table?

[Lynne]

It could be that you didn't uninstall a modification correctly. Have you uninstalled any lately? And do you always make sure to remove all files you uploaded for the modification also?

[JuniorWU]

What is odd is that it came out of nowhere, everything was working properly, untill by what did not adding any new plugin = /....
I will try to resolve the problem, if there is other easier solution would appreciate

[FreshFroot]

Well it's a mod causing it. It was either not uninstalled or not working properly and causing your forum to have issues.

If you deactivate all plugins do you still have the problem?

otherwise you will have to list your mods or go through each one and see which one is causing a problem.

Some hack created the table mgccustomusergroupperms

Now I don't know if you are using that mod still. If not, then it didn't uninstall properly and is causing problems.

You could wipe that table too. But you want to know what and how it installed before you take a huge action. And make a backup 1st!

[JuniorWU]

already managed to solve, I accessed phpmyadmin and create a table named "mgccustomusergroupperms" and returned to work perfectly