PDA

View Full Version : Anyone help with this error please (SOLVED)


[email protected] vbmenu_register("postmenu_1122280", true);
11-21-2006, 02:29 PM
when i try to modify a usergroup i gwt this error

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

Ive disabled all the products and its still not working

harmor19
11-21-2006, 06:54 PM
Go into your ACP --> Maintenance --> Execute SQL Query

In the textarea paste this code.
ALTER TABLE usergroup ADD hhroptions mediumint(10) unsigned NOT NULL default '0'

[email protected] vbmenu_register("postmenu_1122857", true);
11-22-2006, 10:20 AM
many thanks - it worked - thank you