[Koha-bugs] [Bug 28524] Most-circulated items (cat_issues_top.pl) is failing with MySQL 8

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

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

--- Comment #1 from Jonathan Druart <jonathan.druart+koha at gmail.com> ---
Created attachment 122036
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=122036&action=edit
Bug 28524: Escape 'rank' in cat_issues_top.pl

It's a MySQL 8 keyword

Test plan:
Turn off strict_sql_modes (there are other problems in this script)
Hit Home Reports > Most-circulated items
Submit the form

Without this patch you got:
  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,
biblio.biblionumber AS ID, itemcallnumber as CALLNUM, ccode as CCODE, loca' at
line 1

With this patch applied you see the report result view

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