[Bug 5615] New: ZOOM error 20003 "can't set prefix query" on some authority searches
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5615 Summary: ZOOM error 20003 "can't set prefix query" on some authority searches Change sponsored?: --- Product: Koha Version: rel_3_2 Platform: All OS/Version: All Status: NEW Severity: blocker Priority: P5 Component: Searching AssignedTo: gmcharlt@gmail.com ReportedBy: fcapovilla@live.ca QAContact: koha-bugs@lists.koha-community.org Estimated Hours: 0.0 Created attachment 2986 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=2986 Fixes the search queries of the SearchAuthorities subroutine. With some types of authority searches, a ZOOM error is sent : Example 1: In /koha/authorities/authorities-home.pl , If I search for a "Corporate Name" without entering any search term, I get the error : ZOOM error 20003 "can't set prefix query" (addinfo: "@or @attr 7=1 @attr 1=Heading 0 @and @attr 1=authtype @attr 5=100 CORPO_NAME") from diag-set 'ZOOM' Example 2: When adding or modifying a MARC record, click on the "..." next to the 100$a field to do an authority search. In the search window, any search with 0 or more than 1 search term returns a ZOOM error : ZOOM error 20003 "can't set prefix query" (addinfo: "@or @attr 7=1 @attr 1=Heading 0 @and @attr 1=authtype @attr 5=100 PERSO_NAME @attr 1=Heading @attr 5=1 @attr 4=6 "test" @attr 1=Heading @attr 5=1 @attr 4=6 "test"") from diag-set 'ZOOM' There was a problem in the way the SearchAuthorities subroutine in C4/AuthoritiesMarc.pm created its search queries. Patch attached to correct the problem. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5615 Frédérick Capovilla <fcapovilla@live.ca> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P5 |PATCH-Sent Patch Status|--- |Needs Signoff -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5615 Frédérick Capovilla <fcapovilla@live.ca> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|blocker |major -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5615 Frédérick Capovilla <fcapovilla@live.ca> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|major |normal -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5615 Frédéric Demians <frederic@tamil.fr> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |frederic@tamil.fr --- Comment #1 from Frédéric Demians <frederic@tamil.fr> 2011-01-20 09:40:30 UTC --- I confirm this bug. I send a patch since I can't sign on the previous one. http://lists.koha-community.org/pipermail/koha-patches/2011-January/013677.h... Please, Frédérick, test it and put a signed-off on it. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5615 --- Comment #2 from Frédérick Capovilla <fcapovilla@live.ca> 2011-01-24 16:31:39 UTC --- (In reply to comment #1)
I confirm this bug. I send a patch since I can't sign on the previous one.
http://lists.koha-community.org/pipermail/koha-patches/2011-January/013677.h...
Please, Frédérick, test it and put a signed-off on it.
I tested your version of the patch, but there is a small problem with it : If I do an empty search or a search sorted by "No order", I still get errors. I think the patch I attached with my bug report fixes the problem better. Still waiting for somebody to test it and sign off. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5615 Frédéric Demians <frederic@tamil.fr> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |DUPLICATE --- Comment #3 from Frédéric Demians <frederic@tamil.fr> 2011-01-25 07:24:17 UTC --- *** This bug has been marked as a duplicate of bug 4309 *** -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org