[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523 --- Comment #14 from David Nind --- Thanks Michael! -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list

[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523 Michael Hafen changed: What|Removed |Added CC||michael.ha...@washk12.org

[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523 --- Comment #12 from David Nind --- Currently getting this error when running Patrons with the most checkouts report (using KTD started with ku and on master) - is the this the same issue or something else?

[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523 wainuiwitikap...@catalyst.net.nz changed: What|Removed |Added Version(s)|21.11.00,21.05.02,20.11.08,

[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523 Victor Grousset/tuxayo changed: What|Removed |Added Status|Pushed to oldstable |Pushed to

[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523 Victor Grousset/tuxayo changed: What|Removed |Added CC||vic...@tuxayo.net

[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523 Kyle M Hall changed: What|Removed |Added Status|Pushed to master|Pushed to stable

[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523 --- Comment #7 from Jonathan Druart --- Pushed to master for 21.11, thanks to everybody involved! -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs

[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523 Jonathan Druart changed: What|Removed |Added Version(s)||21.11.00 released

[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523 Marcel de Rooy changed: What|Removed |Added QA Contact|testo...@bugs.koha-communit |m.de.r...@rijksmuseum.nl

[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523 Marcel de Rooy changed: What|Removed |Added Attachment #122395|0 |1 is obsolete|

[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523 Marcel de Rooy changed: What|Removed |Added Status|Signed Off |Passed QA -- You are

[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523 Owen Leonard changed: What|Removed |Added Attachment #122037|0 |1 is obsolete|

[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523 Owen Leonard changed: What|Removed |Added Patch complexity|--- |Trivial patch

[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523 --- Comment #4 from David Nind --- Thanks Jonathan! I can now get this to work with MySQL 8 (ku-my8). With the patch applied in master with MariaDB (ku), I need to turn off strict mode to get this to work. Is that what is

[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523 --- Comment #3 from Jonathan Druart --- Hi David, The "isn't in GROUP BY" error is happening when strict modes are set. To turn them off you need to edit $KOHA_CONF and set the value for to 0. Setting them globally is not

[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523 David Nind changed: What|Removed |Added CC||da...@davidnind.com ---

[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523 Jonathan Druart changed: What|Removed |Added Assignee|koha-b...@lists.koha-commun

[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523 --- Comment #1 from Jonathan Druart --- Created attachment 122037 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=122037=edit Bug 28523: Escape 'rank' in bor_issues_top.pl It's a MySQL 8 keyword Test plan: Turn

[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523 Jonathan Druart changed: What|Removed |Added Status|NEW |Needs Signoff -- You

[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523 Jonathan Druart changed: What|Removed |Added Version|21.05 |unspecified -- You are

[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523 Jonathan Druart changed: What|Removed |Added See Also|

[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28523 Jonathan Druart changed: What|Removed |Added See Also|