Bug 23997: Escape z3950servers.rank as it's a new MySQL 8 kw
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Fri, 8 Nov 2019 10:46:58 +0000 (11:46 +0100)
committerLucas Gass <lucas@bywatersolutions.com>
Thu, 9 Jan 2020 22:41:25 +0000 (22:41 +0000)
commit60324dcf6bb8c682ea7dc11228bf83bd5d84e533
tree8d992799bbdc3911cac82db1dce26a8fc171a38e
parentd0c97a661b96a65112502ccc1920ab3e00469506
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)

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
(cherry picked from commit 5ebf75ecd07f99b5d8bb56edc9b1758d262a30c1)

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
cataloguing/z3950_auth_search.pl
installer/data/mysql/de-DE/optional/sample_z3950_servers.sql
installer/data/mysql/en/optional/sample_z3950_servers.sql
installer/data/mysql/es-ES/optional/sample_z3950_servers.sql
installer/data/mysql/fr-CA/facultatif/sample_z3950_servers.sql
installer/data/mysql/nb-NO/2-Valgfritt/z3950servers.sql
installer/data/mysql/pl-PL/optional/sample_z3950_servers.sql