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)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Fri, 8 Nov 2019 11:22:31 +0000 (11:22 +0000)
commit5ebf75ecd07f99b5d8bb56edc9b1758d262a30c1
tree5cb259221b4760e9bb285699ea87619e46e8ad25
parent0d2cc574d1c8ac00cebd91816277c75a461eef3b
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>
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