Bug 21281: Surround creator_templates.rows with backquotes
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Wed, 29 Aug 2018 20:05:50 +0000 (17:05 -0300)
committerFridolin Somers <fridolin.somers@biblibre.com>
Wed, 3 Oct 2018 11:51:28 +0000 (13:51 +0200)
commit52e4a8635eb48662da6bc48fa83dfe4758598fa2
tree00effb0f9f09521b2084e1af1ce7682d3fb1948c
parente69ce2d8a6b5e469ff809dfa8a616e615d096205
Bug 21281: Surround creator_templates.rows with backquotes

'rows' is a reserved word since MariaDB 10.2.4 and MySQL
https://mariadb.com/kb/en/library/mariadb-1024-release-notes/
https://dev.mysql.com/doc/refman/8.0/en/keywords.html

Test plan:
Do not apply this patch and make sure you recreate the reported issue
Apply this patch and confirm that it is now fixed.

QA will take care for the changes in installer and test files

Signed-off-by: Chris Cormack <chris@bigballofwax.co.nz>
Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
(cherry picked from commit 7de47202f2876892524c8b68de962c0776f32881)
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
(cherry picked from commit 9f306898886efe1c2a29f2b622885ec1dfa4fe9a)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
C4/Creators/Lib.pm
installer/data/mysql/patroncards_upgrade.pl
t/db_dependent/Creators/Lib.t