[Koha-bugs] [Bug 33375] New: Advanced editor crashes when using MySQL 8 due to reserved rank keyword
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Mar 31 02:54:45 CEST 2023
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33375
Bug ID: 33375
Summary: Advanced editor crashes when using MySQL 8 due to
reserved rank keyword
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: critical
Priority: P1 - high
Component: Cataloging
Assignee: koha-bugs at lists.koha-community.org
Reporter: dcook at prosentient.com.au
QA Contact: testopia at bugs.koha-community.org
CC: m.de.rooy at rijksmuseum.nl
Bug 17515 added "rank" to the ORDER BY without quoting it. Since it's a
reserved keyword in MySQL 8, this causes a syntax error which causes the
advanced editor to throw a fatal 500 error.
--
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