The following issue has been SUBMITTED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=1094 ====================================================================== Reported By: Arty Assigned To: ====================================================================== Project: DBMail Issue ID: 1094 Category: installation scripts Reproducibility: always Severity: minor Priority: normal Status: new target: ====================================================================== Date Submitted: 03-Apr-18 05:03 CEST Last Modified: 03-Apr-18 05:03 CEST ====================================================================== Summary: Installation script fails with ERROR 1067 on MySQL 5.7 due to strict checking of date value '0000-00-00 00:00:00' Description: Installation script fails when deploying on MySQL version 5.7 with default mode.
mysql dbmail < /usr/share/doc/dbmail-3.2.3/sql/mysql/create_tables.mysql ERROR 1067 (42000) at line 278: Invalid default value for 'since' The problem with default datetime value '0000-00-00 00:00:00' which is no more valid since 5.7. Read: https://dev.mysql.com/doc/refman/5.7/en/datetime.html Minimal valid date is '1000-01-01 00:00:00' ====================================================================== Issue History Date Modified Username Field Change ====================================================================== 03-Apr-18 05:03 Arty New Issue ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://lists.nfg.nl/mailman/listinfo/dbmail-dev
