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)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Thu, 27 Sep 2018 12:07:29 +0000 (13:07 +0100)
commit9f306898886efe1c2a29f2b622885ec1dfa4fe9a
tree54af5cb258da5b0f51ae6997755923e9d9da2421
parentff3238992788344902835742c7ffd02899409e79
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>
C4/Creators/Lib.pm
installer/data/mysql/patroncards_upgrade.pl
t/db_dependent/Creators/Lib.t