Bug 19248 - install.pl: DBD::mysql::st execute failed
Summary: install.pl: DBD::mysql::st execute failed
Status: CLOSED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: Installation and upgrade (web-based installer) (show other bugs)
Version: unspecified
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks: 17258
  Show dependency treegraph
 
Reported: 2017-09-04 08:23 UTC by mksiva@yahoo.com
Modified: 2018-12-03 20:04 UTC (History)
3 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Who signed the patch off:
Text to go in the release notes:
Version(s) released in:


Attachments
Koha>Web Insteller> error (2.96 KB, text/html)
2017-09-04 08:23 UTC, mksiva@yahoo.com
Details

Note You need to log in before you can comment on or make changes to this bug.
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