[Koha-bugs] [Bug 20596] Error Zoom 20003 when import authority marc file (koha/tools/manage-marc-import.pl)

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20596

--- Comment #12 from David Cook <dcook at prosentient.com.au> ---
Reproduced the error following Jan Kissig's instructions:

ZOOM error 20003 "can't set prefix query" (addinfo: "@or @attr 7=1 @attr 4=109
@attr 1=Local-Number 0  @attr 1=Other-control-number  @attr 4=1  @attr 5=100
@attr 6=3 "(DE-101)04079184X" @attr 1=Other-control-number  @attr 4=1  @attr
5=10
0 @attr 6=3 "(DE-588)4079184-1"") from diag-set 'ZOOM' at
/kohadevbox/koha/Koha/BackgroundJob/StageMARCForImport.pm line 162.

It looks like C4::AuthoritiesMarc::SearchAuthorities is where the issue is.

The "$orderstring" is being tacked on the front which is OK: '@attr 7=1 @attr
4=109 @attr 1=Local-Number 0'

    227     $query="\@or $orderstring $query" if $orderstring;

That leaves the two actual queries:

@attr 1=Other-control-number  @attr 4=1  @attr 5=100 @attr 6=3
"(DE-101)04079184X" 
@attr 1=Other-control-number  @attr 4=1  @attr 5=100 @attr 6=3
"(DE-588)4079184-1"

As I suspected, Koha isn't adding the operator to join these two queries
together. 

The query building code is frightful...

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.