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 (https://vborg.vbsupport.ru/showthread.php?p=1047841&highlight=hhroptions#post1047841) as the same problem has occured here and the answer is contained in that thread.