https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16664 Bug ID: 16664 Summary: SQL issues in 16.05 preventing installation in MySQL 5.7 Change sponsored?: --- Product: Koha Version: 16.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: koha-bugs@lists.koha-community.org Reporter: robin@kallisti.net.nz QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com The errors are: [Sat Jun 4 11:00:03 2016] install.pl: DBD::mysql::st execute failed: BLOB, TEXT, GEOMETRY or JSON column 'defaultvalue' can't have a default value at /usr/share/perl5/DBIx/RunSQL.pm line 273. caused by: 72 `defaultvalue` TEXT DEFAULT '', --- [Sat Jun 4 10:56:57 2016] install.pl: DBD::mysql::st execute failed: Invalid default value for 'created_on' at /usr/share/perl5/DBIx/RunSQL.pm line 273. caused by: 2212 `created_on` TIMESTAMP NOT NULL, -- creation time (timestamps are weird and special in mysql, see here: http://dev.mysql.com/doc/refman/5.7/en/timestamp-initialization.html ) --- -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.