Editting usergroup option

[Mrcrans]

Hi, I dunno what the problem is, but I can't edit my Usergroup cause theres a field at the bottom (heres a pic: http://www.movieshares.co.uk/images/1199904879.PNG (https://www.vbulletin.com/link.php?u=http%3A%2F%2Fwww.movieshares.co.uk%2Fim ages%2F1199904879.PNG) ) all empty and when I try and change any settings it doesn't let it. Just says database error!

[Steve Machol]

That is from an add-on you installed.

We need to see the real error message. Right-click on the error page and go to View/Source. Then copy-n-paste the error message here.

[Mrcrans]

Couldn't view sauce but this is the database msg.

Database error in vBulletin 3.7.0 Beta 3:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '3928319',
`genericpermissions` = '1579685575',
`attachlimit` = '0',
`pmquota` = '100',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '6553500',
`avatarmaxwidth` = '100',
`avatarmaxheight` = '100',
`avatarmaxsize` = '2000000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '50000',
`sigpicmaxheight` = '10000',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '3',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '10000000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '31',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '115',
`mgccustomusergroupperms` = '0',
`nbmsgshowchatbox` = ''
WHERE usergroupid=2;

MySQL Error : Unknown column 'mgccustomusergroupperms' in 'field list'
Error Number : 1054
Date : Monday, January 14th 2008 @ 05:30:31 PM
Script : http://www.movieshares.co.uk/admincp/usergroup.php?do=update
Referrer : http://www.movieshares.co.uk/admincp/usergroup.php?do=edit&usergroupid=2
IP Address :
Username : Mrcrans
Classname : vB_Database
MySQL Version : 4.1.22-standard

[Steve Machol]

There is no 'mgccustomusergroupperms' field in the default vB database. This is from an add-on you installed. You will need to find out which add-on this is and either remove it or fix it.

[Mrcrans]

I tried, removing the hacks didn't work.

Can I manually remove from MySQL?

[Steve Machol]

Edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

If you need more help with this add-on, then tyou will need to post over aty vbulletin.org.