Mailing List Archive

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