[Bug 16664] New: SQL issues in 16.05 preventing installation in MySQL 5.7
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.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16664 --- Comment #1 from Robin Sheat <robin@kallisti.net.nz> --- Created attachment 52037 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=52037&action=edit Bug 16664: fix loaded SQL for strictness There were some errors in the SQL structure that MySQL got upset at in strict mode. This lets the file load. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16664 Robin Sheat <robin@kallisti.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff --- Comment #2 from Robin Sheat <robin@kallisti.net.nz> --- To test: * attempt to use the web installer in Ubuntu 16.05, see that it works with this patch. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16664 Robin Sheat <robin@kallisti.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|enhancement |major Priority|P5 - low |P3 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16664 Srdjan Jankovic <srdjan@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16664 Srdjan Jankovic <srdjan@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #52037|0 |1 is obsolete| | --- Comment #3 from Srdjan Jankovic <srdjan@catalyst.net.nz> --- Created attachment 53119 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=53119&action=edit [SIGNED-OFF] Bug 16664: fix loaded SQL for strictness There were some errors in the SQL structure that MySQL got upset at in strict mode. This lets the file load. Signed-off-by: Srdjan <srdjan@catalyst.net.nz> -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16664 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Failed QA CC| |jonathan.druart@bugs.koha-c | |ommunity.org --- Comment #4 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- This fix is already done on bug 16573 (which should get more love). We could push this one separately anyway but I think the patch should fix existing installs too. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16664 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=16583 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16664 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Failed QA |RESOLVED Resolution|--- |DUPLICATE --- Comment #5 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- *** This bug has been marked as a duplicate of bug 16573 *** -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org