[Koha-bugs] [Bug 12903] New: UseQueryParse, Staff client search incatalog, Duplicated records massage when adding a record.

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12903

            Bug ID: 12903
           Summary: UseQueryParse, Staff client search incatalog,
                    Duplicated records  massage when adding a record.
 Change sponsored?: ---
           Product: Koha
           Version: 3.16
          Hardware: All
                OS: All
            Status: NEW
          Severity: critical
          Priority: P5 - low
         Component: Cataloging
          Assignee: gmcharlt at gmail.com
          Reporter: ayousef at kwareict.com
        QA Contact: testopia at bugs.koha-community.org
                CC: m.de.rooy at rijksmuseum.nl

Hello,

We have tested search in catalog using (Search the catalog) tab located at the
header of staff client
more and more times, but the result always gets
No results found

No results match your search for 'science #'.

Although searching the opac gets results correctly, and advanced search in
intranet staff client also

gets results correctly

here: http://library.domain/cgi-bin/koha/opac-search.pl?q=science (opac gets
results)

and here: http://library.domain:8080/cgi-bin/koha/catalogue/search.pl?q=science
(intranet doesn't get any result)

also we have instances of koha 3.2 and koha 3.14.x and this type of search is
working good.


We noticed that activating System preference ( UseQueryParse ) was the reason
that has stopped intranet staff client catalog search
when we stopped it the search has been worked correctly.

But stopping this system preference affected on adding new catalog records
negatively specially Arabic records, Always the message of (duplicated record)
appears.

Here's the reason:
the reason is because (isbn) number in many Arabic records is not necessary in
old records, I mean it has the value of (NULL) in koha DB and when checking
isbn numbers it considers the NULL values are for the same record, so it always
asking if that record is identical to another one in database or not if we
entered the record without (isbn) number, so i think the following snippet of
code in (search.pm -->koha v3.16.01)

doesn't exclude NULL values when checking record duplication by isbn numbers

# search duplicate on ISBN, easy and fast..
    # ... normalize first
    if ( $result->{isbn} ) {
        $result->{isbn} =~ s/\(.*$//;
        $result->{isbn} =~ s/\s+$//;
        $query = "isbn:$result->{isbn}";
    }

I'm asking if that is a bug???

thanks

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