Perhaps a missing template or phrase?

Has anybody else got a blank page? No matter what I try, I can't make it come up with a blank page. Hello, are you sure you have done all the steps described in the instructions?

Rgds

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

I fixed it my adding this

Sounds nice, Im gonna chill with Erwin's hack until the number of users reporting bugs <= 0 ;)

that's the only bug i've found. Eveything else is fine, great hack!!

Installed

And this is not a bug, the installation script and the upgrade script include this column, in the warning_options table, check for yourself. Probably mcyates didn't run the scripts, maybe he upgraded manually, from an earlier version which I've published in ZT's thread?

Rgds

I ran the script but it didn't do anything so i had to do it manually. It was the upgrade script that i ran.

What you mean it didn't do anything? Didn't it upgraded your tables etc? Oh heck, time to work on that Sun, I need to do something about its disk space, before I can use it as a test environment again.

Clean install works fine! Thanks!

* clicks install