Summary: | SQL syntax error in Cataloging when accessing pages "Advanced editor" and "New record" | ||
---|---|---|---|
Product: | Koha | Reporter: | Dave Hodgins <dhodgins> |
Component: | Cataloging | Assignee: | Bugs List <koha-bugs> |
Status: | RESOLVED DUPLICATE | QA Contact: | Testopia <testopia> |
Severity: | major | ||
Priority: | P5 - low | CC: | m.de.rooy |
Version: | 21.11 | ||
Hardware: | All | ||
OS: | Linux | ||
See Also: | https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30097 | ||
GIT URL: | Change sponsored?: | --- | |
Patch complexity: | --- | Documentation contact: | |
Documentation submission: | Text to go in the release notes: | ||
Version(s) released in: | Circulation function: |
Description
Dave Hodgins
2022-01-28 21:26:54 UTC
The problem is in file /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl. You've got a hard coded SQL statement that uses the MySQL (as of version 8, anyway) reserved keyword "rank." Escaping that seems to fix the issue. Raising severity for now to get some attention on this. |