From 3d90027d228fb5b65a3413f6191a02a2f80ce81f 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 from a given biblio Place a hold on this record at the OPAC Signed-off-by: Janusz Kaczmarek --- 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.30.2