First of all, thanks alot for a great component, it's just the thing i've been looking for! But i cant get it to install it
SQL Error DB function failed with error number 1067
Invalid default value for 'day' SQL=CREATE TABLE `jos_tdihistory` ( `id` int(11) unsigned NOT NULL auto_increment, `day` tinyint(2) NOT NULL default '', `month` tinyint(2) NOT NULL default '', `year` int(4) NOT NULL default '', `event` text NOT NULL default '', `date_mod` datetime NOT NULL default '0000-00-00 00:00:00', `date_entered` datetime NOT NULL default '0000-00-00 00:00:00', `displays` int(11) unsigned NOT NULL default '0', `feventid` int(11) unsigned default '0', `era` tinyint(1) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM
SQL =
CREATE TABLE `jos_tdihistory` (
`id` int(11) unsigned NOT NULL auto_increment,
`day` tinyint(2) NOT NULL default '',
`month` tinyint(2) NOT NULL default '',
`year` int(4) NOT NULL default '',
`event` text NOT NULL default '',
`date_mod` datetime NOT NULL default '0000-00-00 00:00:00',
`date_entered` datetime NOT NULL default '0000-00-00 00:00:00',
`displays` int(11) unsigned NOT NULL default '0',
`feventid` int(11) unsigned default '0',
`era` tinyint(1) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM
I'm running on Joomla 1.0.8, PHP 4.4.2 and MySQL 5.0.15
I believe that the problem might be in the MySQL version but if there a chance to get it working on 5.0 i would be more then happy!
Hoping for a reply!
Cheers!
