The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Anyone help with this error please (SOLVED)
when i try to modify a usergroup i gwt this error
Code:
Database error in vBulletin 3.6.2: Invalid SQL: UPDATE usergroup SET ### UPDATE QUERY GENERATED BY fetch_query_sql() ### `title` = 'Banned Users', `description` = '', `usertitle` = 'Banned', `opentag` = '', `closetag` = '', `passwordexpires` = '0', `passwordhistory` = '0', `ispublicgroup` = '0', `canoverride` = '0', `forumpermissions` = '0', `genericpermissions` = '64', `attachlimit` = '0', `pmquota` = '0', `pmpermissions` = '0', `pmsendmax` = '0', `calendarpermissions` = '0', `wolpermissions` = '0', `adminpermissions` = '0', `genericoptions` = '0', `profilepicmaxwidth` = '100', `profilepicmaxheight` = '100', `profilepicmaxsize` = '65535', `avatarmaxwidth` = '80', `avatarmaxheight` = '80', `avatarmaxsize` = '20000', `signaturepermissions` = '139263', `sigpicmaxwidth` = '500', `sigpicmaxheight` = '100', `sigpicmaxsize` = '20000', `sigmaxrawchars` = '1000', `sigmaxchars` = '500', `sigmaxlines` = '0', `sigmaxsizebbcode` = '7', `sigmaximages` = '10', `hhroptions` = '0' WHERE usergroupid=8; MySQL Error : Unknown column 'hhroptions' in 'field list' Error Number : 1054 Date : Tuesday, November 21st 2006 @ 04:28:08 PM Script : http://www.************.co.uk/forums/admincp/usergroup.php?do=update Referrer : http://www.************.co.uk/forums/admincp/usergroup.php?do=edit&usergroupid=8 IP Address : 81.97.30.247 Username : Rix Classname : vb_database |
#2
|
|||
|
|||
Go into your ACP --> Maintenance --> Execute SQL Query
In the textarea paste this code. Code:
ALTER TABLE usergroup ADD hhroptions mediumint(10) unsigned NOT NULL default '0' |
#3
|
|||
|
|||
many thanks - it worked - thank you
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|