Log in

View Full Version : Error when trying to create user group


EDITH
09-07-2006, 03:37 PM
I have tried loads of times to try adding a new user group but keep getting this error, anyone got any ideas on how to fix it.

Database error in vBulletin 3.0.1:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO usergroup
(`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `arcadepermissions`, `hhroptions`, `forumpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `calendarpermissions`, `wolpermissions`, `adminpermissions`, `genericpermissions`, `genericoptions`, `profilepicmaxwidth`, `profilepicmaxheight`, `profilepicmaxsize`, `avatarmaxwidth`, `avatarmaxheight`, `avatarmaxsize`)
VALUES
('Gold Members', '', '', '', '', '', '', '0', '0', '0', '0', '651271', '1000000', '0', '0', '5', '0', '1', '0', '2626563', '9', '100', '100', '25000', '50', '50', '20000');

MySQL Error : Unknown column 'hhroptions' in 'field list'
Error Number : 1054
Date : Thursday, September 7th 2006 @ 05:32:55 PM
Script : http://www.scoused.net/admincp/usergroup.php
Referrer : http://www.scoused.net/admincp/usergroup.php?do=add
IP Address :
Username :
Classname : vb_database

D.Ilyin
09-07-2006, 07:34 PM
hhroptions - it's a Hide Hack Resurection column.
may be you dont unistall it correct or install it?

EDITH
09-09-2006, 07:05 PM
i didnt install it, the guys who host me done it

Sparticus_V2
04-26-2007, 08:23 PM
You need to go into your FTP>Includes>XML folder and delete the porblem bitfield

Look to this post for more info>>>>
https://vborg.vbsupport.ru/showpost.php?p=1047841&postcount=2