Installation failed on ubuntu 16

[crirocha]

Error during install while running query.
I ran:

CREATE TABLE lovd_announcements (
id SMALLINT(5) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
type VARCHAR(15) NOT NULL DEFAULT "information",
announcement TEXT NOT NULL,
start_date DATETIME NOT NULL DEFAULT "0000-00-00 00:00:00",
end_date DATETIME NOT NULL DEFAULT "9999-12-31 23:59:59",
lovd_read_only BOOLEAN NOT NULL DEFAULT 0,
created_by SMALLINT(5) UNSIGNED ZEROFILL,
created_date DATETIME NOT NULL,
edited_by SMALLINT(5) UNSIGNED ZEROFILL,
edited_date DATETIME,
PRIMARY KEY (id),
INDEX (created_by),
INDEX (edited_by),
CONSTRAINT lovd_announcements_fk_created_by FOREIGN KEY (created_by) REFERENCES lovd_users (id) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT lovd_announcements_fk_edited_by FOREIGN KEY (edited_by) REFERENCES lovd_users (id) ON DELETE SET NULL ON UPDATE CASCADE)
ENGINE=InnoDB,
DEFAULT CHARACTER SET utf8

I got:
[42000] [1067] [Invalid default value for 'start_date']

Fixed replacing
start_date DATETIME NOT NULL DEFAULT "0000-00-00 00:00:00"
with
start_date DATETIME NOT NULL DEFAULT "1000-01-01 00:00:00"

[ifokkema]

Duplicate of #143.
Thank you for your report! This error message indeed occurs on newer MySQL versions. We will look at it and come up with a fix.