[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Jun 16 14:56:18 CEST 2021
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523
--- Comment #1 from Jonathan Druart <jonathan.druart+koha at gmail.com> ---
Created attachment 122037
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=122037&action=edit
Bug 28523: Escape 'rank' in bor_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 > Patrons with the most checkouts
Submit the form
Without this patch you got:
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL s
erver version for the right syntax to use near 'RANK, borrowers.borrowernumber
AS ID FROM `old_issues`
With this patch applied you see the report result view
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
More information about the Koha-bugs
mailing list