Bug 19248

Summary: install.pl: DBD::mysql::st execute failed
Product: Koha Reporter: mksiva@yahoo.com <k.shivaswamy>
Component: Installation and upgrade (web-based installer)Assignee: Bugs List <koha-bugs>
Status: CLOSED INVALID QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: gmcharlt, jonathan.druart, katrin.fischer
Version: unspecified   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on:    
Bug Blocks: 17258    
Attachments: Koha>Web Insteller> error

Description mksiva@yahoo.com 2017-09-04 08:23:07 UTC
Created attachment 66795 [details]
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.
Comment 1 Katrin Fischer 2017-09-04 18:57:25 UTC
Hi, can you share the version of your DBMS and the Koha version you tried to install, please?
Comment 2 mksiva@yahoo.com 2017-09-05 05:13:21 UTC
sir,

Thanks for your response. 

Versions of DBMS, Koha & Ubuntu are
Mysql-5.7.2
KKoha - 17.05
Ubuntu-16.04

Thanks 

K.Sivasamy
Comment 3 Katrin Fischer 2017-09-05 05:56:06 UTC
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.
Comment 4 mksiva@yahoo.com 2017-09-05 08:43:03 UTC
Thanks