MantisBT

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0005804ATutorInstallationpublic2017-09-22 18:542017-09-22 18:54
Reportergreg 
Assigned To 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusnewResolutionopen 
PlatformOSOS Version
Product Version 
Target Version2.2.3Fixed in Version 
Summary0005804: Mysql 5.7 Strict mode
DescriptionBy default MySQL is set to strict mod, which causes any table creation DATETIME values set to 0000-00-00 00:00:00 to fail.

Steps To ReproduceWork around:
Possible to disable strict mode, in /etc/mysql/conf.d/mysql.cnf, adding this line, which remove NO_ZERO DATE from the default settings.

sql_mode = "STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

TagsNo tags attached.
Affects versionSVN
SVN Revision#
Attached Files

- Relationships

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2017-09-22 18:54 greg New Issue


Copyright © 2000 - 2017 MantisBT Team
Powered by Mantis Bugtracker