Install screws up on step 3

[gatrhaze]

Here is part of what it says as the problem...

Executing package #5... unsuccessful!
Error: Column 'year' is used with UNIQUE or INDEX but is not defined as NOT NULL
In CREATE TABLE yabbse_calendar_holiday ( id int(10) unsigned NOT NULL auto_increment, title char(30) NOT NULL default '', month tinyint(4) NOT NULL default '0', day tinyint(4) NOT NULL default '0', year smallint(6) default NULL, PRIMARY KEY (id), KEY idx_month (month), KEY idx_year (year)) TYPE=MyISAM;

Anyone have a solution?

[[Unknown]]

What version of MySQL are you running?

yse151.sql, find:

Code Select Expand

 KEY idx_month (month),
 KEY idx_year (year))

Replace:

Code Select Expand

 KEY idx_month (month))

But... wierd.  Are you using MySQL 3.22?

-[Unknown]

[gatrhaze]

I'm using
mysql  Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686)

and that worked for that step, but then brought upon more problems

http://www.geocities.com/gatrhaze/yabberrors.txt

(no im not trying to install yabbse on geocities)

[[Unknown]]

Ask your host to upgrade.  The install doesn't seem to run for 3.22....

-[Unknown]