https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36587 Bug ID: 36587 Summary: Reserved word in mySQL prevents link to a purchase suggestion Change sponsored?: --- Product: Koha Version: 22.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Staff interface Assignee: koha-bugs@lists.koha-community.org Reporter: r.delahunty@arts.ac.uk QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com There is no link to a specific purchase suggestion in Suggestions management in the SQL Report Library. While this syntax CONCAT('<a href=\"/cgi-bin/koha/suggestion/suggestion.pl?suggestionid=', suggestionid,'\">', suggestionid, '</a>') copies the pattern of other links, it takes the user to an upper level, where a library must be selected. To reach a specific suggestion the url must have a 'trailing fragment' &op=show added. Including the trailing fragment in the link statement is forbidden as SHOW is a reserved word in mySQL. If the API route were changed so that it used a different word, for example "display" instead of "show", it would probably be possible to get around this. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.