From 7282cd87ebd44adbc18daa3f0681fab35f08a3d1 Mon Sep 17 00:00:00 2001 From: Jonathan Druart 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 Signed-off-by: Katrin Fischer Signed-off-by: Tomas Cohen Arazi (cherry picked from commit f25893a2ba395e833c135fb590d4354c5ab6763f) Signed-off-by: Jacob O'Mara --- 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