https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33081 Bug ID: 33081 Summary: (Bug 31314 follow-up) Placing a hold on a serial generates DBI Exception Change sponsored?: --- Product: Koha Version: 22.11 Hardware: All OS: All Status: NEW Severity: major Priority: P2 Component: Hold requests Assignee: koha-bugs@lists.koha-community.org Reporter: januszop@gmail.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, jonathan.druart+koha@gmail.com, nick@bywatersolutions.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' ] -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.