View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
1723 | RackTables | default | public | 2017-02-02 21:00 | 2017-02-08 14:54 |
Reporter | AASithLord | Assigned To | |||
Priority | normal | Severity | block | Reproducibility | always |
Status | closed | Resolution | duplicate | ||
Platform | Linux | OS | Ubuntu | OS Version | 16.10 |
Product Version | 0.20.11 | ||||
Summary | 1723: MySQL 5.7 NO_ZERO_DATE prevents database initialisation | ||||
Description | When initialising the racktables database on MYSQL 5.7 some tables fail because the default value for the date is all Zeros | ||||
Steps To Reproduce | Following the installation on Ubuntu 16.10, with versions Apache2-bin (2.4.18-2ubuntu4 - apache2-ape-20120211) mysql-server-5.7 (5.7.17-0ubuntu0.16.10.1) php7.0 (7.0.13-0ubuntu0.16.10.1) The installation cannot complete the database table creations due to ZERO values in the date/time entries. | ||||
Additional Information | https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_no_zero_date for information about the changes in 5.7 I resolved this by changing the global sql_mode, to exclude "NO_ZERO_DATE": set global sql_mode = 'STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION'; | ||||
Tags | No tags attached. | ||||
duplicate of | 1647 | closed | infrastation | Installations fails at step 5 of 7 |
Date Modified | Username | Field | Change |
---|---|---|---|
2017-02-02 21:00 | AASithLord | New Issue | |
2017-02-08 14:54 | infrastation | Relationship added | duplicate of 1647 |
2017-02-08 14:54 | infrastation | Status | new => closed |
2017-02-08 14:54 | infrastation | Resolution | open => duplicate |