From 7282cd87ebd44adbc18daa3f0681fab35f08a3d1 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Tue, 28 Feb 2023 09:13:19 +0100
Subject: [PATCH] Bug 32674: Fix placing a hold at the OPAC for serials

Placing a hold at the OPAC explodes with a 500 when the record is a
serial
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Column 'biblionumber' in where clause is ambiguous at /usr/share/koha/lib/Koha/Objects.pm line 394

Test plan:
* Create a serial subscription for an existing bibliographic record
* Place a hold on this record at the OPAC

Signed-off-by: Janusz Kaczmarek <januszop@gmail.com>
Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
(cherry picked from commit f25893a2ba395e833c135fb590d4354c5ab6763f)
Signed-off-by: Jacob O'Mara <jacob.omara@ptfs-europe.com>
---
 opac/opac-reserve.pl | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/opac/opac-reserve.pl b/opac/opac-reserve.pl
index 85f2659a87..07440efa6a 100755
--- a/opac/opac-reserve.pl
+++ b/opac/opac-reserve.pl
@@ -335,7 +335,7 @@ foreach my $biblioNumber (@biblionumbers) {
 
     my $items = Koha::Items->search_ordered(
         [
-            biblionumber => $biblioNumber,
+            'me.biblionumber' => $biblioNumber,
             'me.itemnumber' => {
                 -in => [
                     $biblio->host_items->get_column('itemnumber')
-- 
2.39.5