[Koha-bugs] [Bug 23997] sample_z3950_servers.sql is failing on MySQL 8
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Nov 8 11:51:00 CET 2019
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23997
--- Comment #1 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
Created attachment 95193
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=95193&action=edit
Bug 23997: Escape z3950servers.rank as it's a new MySQL 8 kw
This patch will fix installation of Koha on MySQL 8
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to
use near 'rank, syntax, encoding,recordtype) VALUES
('lx2.loc.gov',210,'LCDB','','','LIBRA' at line 2 at
/usr/share/perl5/DBIx/RunSQL.pm line 273.
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
=> RANK (R); added in 8.0.2 (reserved)
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list