Bug 16863

Summary: Quotes around search term cause search failure if QueryAutoTruncate is not enabled.
Product: Koha Reporter: Barton Chittenden <barton>
Component: SearchingAssignee: Galen Charlton <gmcharlt>
Status: CLOSED WORKSFORME QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low    
Version: 3.22   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18689
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Barton Chittenden 2016-07-06 17:49:56 UTC
The following search will succedd if the system preference 'quryautotruncate' is set to 'always' but will fail if set to 'only if * is added'.

http://intranet.bywatersolutions.com/cgi-bin/koha/catalogue/search.pl?q=%22The+Hobbit%22

This causes issues because call number links in the search results are quoted.

To replicate:

1/ Set quryautotruncate to 'only if * is added'.
2/ Run a keyword search, with quotes around the title, e.g. "The Hobbit"
   Seearch will fail
3/ Set quryautotruncate to 'always'
4/ Re-run the same search. It will succeed.
Comment 1 Barton Chittenden 2016-07-06 17:53:49 UTC
Additional notes:

Running zebrasrv using the options "-v none,fatal,warn,request” yielded the following warning for the search "FIC Grisham" when queryautotruncate was enabled:

WARNING: query problem with (rk=( callnum,ext,r1=" FIC Grisham " or callnum,phr,r3=" FIC Grisham " or callnum,wrdl,r6=" FIC Grisham " or callnum,wrdl,fuzzy,r8=" FIC Grisham " or callnum,wrdl,rt,r9=""fic? grisham"? "))  ZOOM error 10014 "CCL parsing error" (addinfo: "Embedded truncation not supported") from diag-set 'ZOOM' at /usr/share/koha/lib/C4/Search.pm line 378.
Comment 2 Katrin Fischer 2023-09-09 21:47:07 UTC
I cannot replicate the problem, searches with quotes work for me with QueryAutoTruncate on and off.
Comment 3 Katrin Fischer 2023-09-10 16:12:03 UTC
*** Bug 18294 has been marked as a duplicate of this bug. ***