[Koha-bugs] [Bug 33081] (Bug 31314 follow-up) Placing a hold on a serial generates DBI Exception

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

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

--- Comment #1 from Janusz Kaczmarek <januszop at gmail.com> ---
In 22.11, apparently after applying bug 31314 (perhaps in conjunction with Bug
31306), placing a hold (from OPAC: opac-reserve.pl) on a serial record (i.e. a
MARC 21 record with 942 $s set) generates runtime error and produces in
opac-error.log the following info: 

DBI Exception: DBD::mysql::st execute failed: Column 'biblionumber' in 
where clause is ambiguous


It seems that this is caused by the presence of 'serialid.publisheddate' in the
line:

order_by => [ 'serialid.publisheddate', 'me.enumchron' ]

in Koha::Items::search_ordered.

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