Vbulletin Problem

[terry123]

Hi Everyone,

Been using VB for many years and installing modifications for some time, but for some reason am unable to change any settings for the usergroups - every time I try to change an option from NO to Yes I get a database error which is below.

Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = 'UFA Super Moderators',
	`description` = '',
	`usertitle` = 'UFA Super Moderator',
	`opentag` = '<span style=\"color: blue;\">',
	`closetag` = '</span>',
	`passwordexpires` = '0',
	`passwordhistory` = '0',
	`forumpermissions` = '1048575',
	`attachlimit` = '0',
	`hhroptions` = '0',
	`pmquota` = '50',
	`pmpermissions` = '3',
	`pmsendmax` = '0',
	`calendarpermissions` = '63',
	`wolpermissions` = '15',
	`adminpermissions` = '1',
	`genericpermissions` = '204429039',
	`genericoptions` = '31',
	`profilepicmaxwidth` = '100',
	`profilepicmaxheight` = '100',
	`profilepicmaxsize` = '65535',
	`avatarmaxwidth` = '80',
	`avatarmaxheight` = '80',
	`avatarmaxsize` = '20000',
	`vbghsepermissions` = '0'
WHERE usergroupid=5;

MySQL Error  : Unknown column 'hhroptions' in 'field list'
Error Number : 1054
Date         : Tuesday, August 8th 2006 @ 10:00:56 PM
Script       : http://mysite.co.uk/forum/admincp/usergroup.php
Referrer     : http://mysite.co.uk/forum/admincp/usergroup.php?do=edit&usergroupid=5
IP Address   : *********
Username     : ******
Classname    : vb_database

Any help or suggestions would be gratefully appreciated as I have just installed the VBookie modification and no users can use it as I cannot set the option to YES in the usergroup manager.

Thanks

Terry

[Paul M]

<a href="https://vborg.vbsupport.ru/showpost.php?p=1047841&postcount=2" target="_blank">https://vborg.vbsupport.ru/showp...41&postcount=2</a>

[peterska2]

see this thread as the same problem has occured here and the answer is contained in that thread.