[Koha-bugs] [Bug 17979] Fatal error when searching from addbooks.pl due to ISBN flaw

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

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

Owen Leonard <oleonard at myacpl.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
 Attachment #119373|0                           |1
        is obsolete|                            |

--- Comment #9 from Owen Leonard <oleonard at myacpl.org> ---
Created attachment 119374
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=119374&action=edit
Bug 17979: Fix cataloguing search if ISBN 13 is passed

This patch fixes the following error:

C4::Breeding::BreedingSearch(): DBI Exception: DBD::mysql::st execute
failed: You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use
near '' at line 5 [for Statement "SELECT import_record_id, file_name,
isbn, title, author
     FROM  import_biblios
     JOIN import_records USING (import_record_id)
     JOIN import_batches USING (import_batch_id)
     WHERE "] at /kohadevbox/koha/cataloguing/addbooks.pl line 126
 at /usr/share/perl5/DBIx/Class/Exception.pm line 77

It happens when our GetNormalizedISBN sub does not return an ISBN, the
SQL query generated by BreedingSearch is invalid

Test plan:
Try a cataloguing search with "400638133393x"

Signed-off-by: Owen Leonard <oleonard at myacpl.org>

Tested with the suggested invalid ISBN as well as with some correct
ISBNS. No errors.

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