[Koha-bugs] [Bug 8466] New: Holds on MARC records with no item causes silent error in koha-error_log

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Wed Jul 18 13:50:50 CEST 2012


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

          Priority: P5 - low
 Change sponsored?: ---
            Bug ID: 8466
                CC: m.de.rooy at rijksmuseum.nl
          Assignee: gmcharlt at gmail.com
           Summary: Holds on MARC records with no item causes silent error
                    in koha-error_log
          Severity: minor
    Classification: Unclassified
                OS: All
          Reporter: kolpen at o2.pl
          Hardware: All
            Status: NEW
           Version: rel_3_6
         Component: Cataloging
           Product: Koha

Created attachment 10931
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10931&action=edit
proposed (two) patches

While cataloging, viewing MARC details of record that hasn't items yet, a
silent error occurs in koha-error_log when a librarian clicks on the "Holds"
tab.
The error messages are like that:
request.pl: DBD::mysql::st execute failed: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version for the
right syntax to use near ')' at line 3 at /usr/share/koha/lib/C4/Koha.pm line
811., 
request.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute()
at /usr/share/koha/lib/C4/Koha.pm line 814., 

The reason is an empty items value in dynamically build query in procedures:
- Module: Items.pm, procedure: GetItemInfosOf
- Module: Biblio.pm, procedure: GetBiblioItemInfosOf

Proposed patch refers to the version 3.6.4

The bug occurs also in later Koha versions (ie. 3.6.6, 3.8) and the same
patches should be implemented there (it is only one line add), respectively:
Module: Items.pm - line 1064 in version 3.6.6; line 1069 in version 3.8
Module: Biblio.pm - line 1014 in version 3.6.6; line 1026 in version 3.8

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


More information about the Koha-bugs mailing list