[mcyates]

mysql error: Unknown column 'hierarchical' in 'field list'

ERROR BELOW::


Database error in vBulletin 3.0.3:

Invalid SQL: update warning_options set
hierarchical='Yes',
warner='0',
banned_limit='7',
points_before_banned='10',
banned_usergroup_id='8',
troll_usergroup_id='8',
protected_usergroups='6',
incr_ban_days='Yes',
max_no_bans='3',
multiple_per_post='Yes',
send_pm_warning='Yes',
send_em_warning='Yes',
historical='Yes',
allowoffpost='Yes',
warnings_per_page='10'
where oid='1'
mysql error: Unknown column 'hierarchical' in 'field list'

mysql error number: 1054

Date: Tuesday 23rd of November 2004 01:45:59 PM
Script: http://www.myfootballforum.com/10293...admin_warn.php
Referer: http://www.myfootballforum.com/10293...=manageoptions
Username: boro_boy
IP Address: 62.254.64.19

==============================================

This is possible because I can't find anything containing 'hierarchical' in the SQL below I think the 'hierarchical' bit of the script which is missing should be above line 3 below, (above `warner` int(10) unsigned, )

CREATE TABLE `".TABLE_PREFIX."warning_options` (
`oid` int(15) NOT NULL auto_increment,
`warner` int(10) unsigned,
`banned_limit` int(15) NOT NULL,
`points_before_banned` int(15) NOT NULL default '0',
`banned_usergroup_id` int(15) default '0',
`protected_usergroups` varchar(10),
`troll_usergroup_id` varchar(10),
`incr_ban_days` char(3),
`max_no_bans` int(5),
`multiple_per_post` char(3),
`send_pm_warning` char(3),
`send_em_warning` char(3),
`historical` char(3),
`allowoffpost` char(3),
`warnings_per_page` int(3),
PRIMARY KEY (`oid`)
) TYPE=MyISAM


This erro keeps coming up when i change the settings in the admin cp.

Cheers