[Koha-bugs] [Bug 33081] New: (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

            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 at lists.koha-community.org
          Reporter: januszop at gmail.com
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com, jonathan.druart+koha at gmail.com,
                    nick at 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.