[Bug 19248] New: install.pl: DBD::mysql::st execute failed
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19248 Bug ID: 19248 Summary: install.pl: DBD::mysql::st execute failed Change sponsored?: --- Product: Koha Version: unspecified 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: k.shivaswamy@gmail.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com Created attachment 66795 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66795&action=edit Koha>Web Insteller> error The following error occurred while importing the database structure: [Mon Sep 4 13:12:33 2017] install.pl: DBD::mysql::st execute failed: Invalid default value for 'date_created' at /usr/share/perl5/DBIx/RunSQL.pm line 273. -- 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=19248 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Hi, can you share the version of your DBMS and the Koha version you tried to install, please? -- 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=19248 --- Comment #2 from mksiva@yahoo.com <k.shivaswamy@gmail.com> --- sir, Thanks for your response. Versions of DBMS, Koha & Ubuntu are Mysql-5.7.2 KKoha - 17.05 Ubuntu-16.04 Thanks K.Sivasamy -- 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=19248 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |INVALID --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I think the reason for your problem is the version of MySQL, see here: Koha does not work well with MySQL 5.7 which is shipped with Ubuntu 16.04. use MariaDB instead. https://wiki.koha-community.org/wiki/Koha_on_Debian I'd recommend switching to MariaDB and redoing the import. -- 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=19248 --- Comment #4 from mksiva@yahoo.com <k.shivaswamy@gmail.com> --- Thanks -- 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=19248 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |17258 CC| |jonathan.druart@bugs.koha-c | |ommunity.org Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 [Bug 17258] [OMNIBUS] MySQL 5.7 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org