[Koha-bugs] [Bug 13669] Web installer fails to load sample data on MySQL 5.6+

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669

--- Comment #48 from Bernardo Gonzalez Kriegel <bgkriegel at gmail.com> ---
(In reply to Katrin Fischer from comment #47)
> I have installed the dependency from CPAN, made sure that the database was
> empty, applied the patches and ran the web installer in English. But I still
> get errors, any idea what's going wrong there?
> 
...

I can confirm similar problems on Ubuntu 16.05, Myslq 5.7
My test where not done on this kind of system, sorry :(

In case the problem where from DBIX::RunSQL (which gives problems),
I wrote a revision using Tomas' approach (SQL::SplitStatment), and found
the same problems

[Sun May 22 18:49:18 2016] install.pl: DBD::mysql::db do failed: BLOB, TEXT,
GEOMETRY or JSON column 'defaultvalue' can't have a default value at
/home/bgkriegel/kohaclone/C4/Installer.pm line 443. [Sun May 22 18:49:51 2016]
install.pl: DBD::mysql::db do failed: Invalid default value for 'created_on' at
/home/bgkriegel/kohaclone/C4/Installer.pm line 443. [Sun May 22 18:49:52 2016]
install.pl: DBD::mysql::db do failed: Cannot add foreign key constraint at
/home/bgkriegel/kohaclone/C4/Installer.pm line 443. [Sun May 22 18:49:52 2016]
install.pl: DBD::mysql::db do failed: Cannot add foreign key constraint at
/home/bgkriegel/kohaclone/C4/Installer.pm line 443

-- 
You are receiving this mail because:
You are watching all bug changes.