Bug 6023 - Authority searches containing double-quotes returns an error 500.
Summary: Authority searches containing double-quotes returns an error 500.
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Searching (show other bugs)
Version: rel_3_2
Hardware: All All
: PATCH-Sent (DO NOT USE) normal (vote)
Assignee: Frédérick Capovilla
QA Contact: Bugs List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-31 15:25 UTC by Frédérick Capovilla
Modified: 2012-10-25 23:04 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments
Escape the double quotes in authority search queries to prevent errors. (986 bytes, patch)
2011-03-31 15:25 UTC, Frédérick Capovilla
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description Frédérick Capovilla 2011-03-31 15:25:27 UTC
Created attachment 3577 [details] [review]
Escape the double quotes in authority search queries to prevent errors.

Searching for any term containing double-quotes returns an error 500 when doing an authority search on this page : authorities/authorities-home.pl .

The error is returned because the double-quotes aren't escaped when creating the pqf search query, which breaks the query.

Patch attached which does some escaping on double-quotes when constructing the pqf query.
Comment 1 Julian Maurice 2011-04-01 07:17:33 UTC
It works as expected, signed off.
Comment 2 Chris Cormack 2011-04-01 07:39:14 UTC
Pushed please test