View Issue Details

IDProjectCategoryView StatusLast Update
1723RackTablesdefaultpublic2017-02-08 14:54
ReporterAASithLord Assigned To 
PrioritynormalSeverityblockReproducibilityalways
Status closedResolutionduplicate 
PlatformLinuxOSUbuntuOS Version16.10
Product Version0.20.11 
Summary1723: MySQL 5.7 NO_ZERO_DATE prevents database initialisation
DescriptionWhen initialising the racktables database on MYSQL 5.7 some tables fail because the default value for the date is all Zeros
Steps To ReproduceFollowing 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 Informationhttps://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';
TagsNo tags attached.

Relationships

duplicate of 1647 closedinfrastation Installations fails at step 5 of 7 

Activities

There are no notes attached to this issue.

Issue History

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