[Koha-bugs] [Bug 33375] Advanced editor crashes when using MySQL 8 due to reserved rank keyword

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33375

--- Comment #1 from David Cook <dcook at prosentient.com.au> ---
Created attachment 149008
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=149008&action=edit
Bug 33375: Quote reserved keyword 'rank' in advanced editor

This change quotes the 'rank' keyword in the advanced editor,
so that it doesn't cause fatal crashes when using MySQL 8

Test plan:
0. Apply patch and koha-plack --restart kohadev
1. Enable advanced editor
http://localhost:8081/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=EnableAdvancedCatalogingEditor
2. Go to http://localhost:8081/cgi-bin/koha/cataloguing/editor.pl#new/
3. Click on "Advanced" on the left nav
4. Note that "LIBRARY OF CONGRESS" is ordered before "NATIONAL LIBRARY OF
FRANCE"
5. Rejoice!

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.