http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8466 Priority: P5 - low Change sponsored?: --- Bug ID: 8466 CC: m.de.rooy@rijksmuseum.nl Assignee: gmcharlt@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@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.