#12 unable to create DB tables with MySQL 5.5 because of Invalid default values for timestamps

from mantis - 2012-07-05 07:53 (unauthenticated)

easyrec fails to initialize the database, the default value '0000-00-00 00:00:00' is invalid for timestamp.

Log:

CREATE TABLE profile ( profileId int(11) unsigned NOT NULL auto_increment, tenantId int(11) NOT NULL, itemId int(11) NOT NULL, itemTypeId int(11) NOT NULL, profileData text, changeDate timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP, active TINYINT(1) NOT NULL DEFAULT '1', PRIMARY KEY (profileId), UNIQUE KEY tenantId (tenantId,itemId,itemTypeId) ) ENGINE=InnoDb DEFAULT CHARSET=latin1 COMMENT='Table containing item profiles'; ERROR 1067 (42000): Invalid default value for 'changeDate'

CREATE TABLE plugin_log ( id int(11) NOT NULL AUTO_INCREMENT, tenantId int(11) unsigned NOT NULL, pluginId varchar(500) NOT NULL, pluginVersion varchar(50) NOT NULL, startDate timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', endDate timestamp NULL DEFAULT NULL, assocTypeId int(11) NOT NULL, configuration text NOT NULL, statistics text, PRIMARY KEY (id), UNIQUE unique_plugin_log (tenantId,pluginId(255),pluginVersion,assocTypeId,startDate), KEY idx_tenantId (tenantId), KEY idx_endDate (endDate) ) ENGINE=InnoDb DEFAULT CHARSET=latin1 COMMENT = 'store runs of plugins'; ERROR 1067 (42000): Invalid default value for 'startDate'