[Koha-bugs] [Bug 29802] New: biblionumber in OPACHiddenItems breaks opac lists

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

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

            Bug ID: 29802
           Summary: biblionumber in OPACHiddenItems breaks opac lists
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: OPAC
          Assignee: oleonard at myacpl.org
          Reporter: nick at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org

When biblionumber is in the opachiddenitems preference the query to find hidden
items dies:
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st
execute failed: Column 'biblionumber' in where clause is ambiguous [for
Statement "SELECT `me`.`itemnumber`, `me`.`biblionumber`,
`me`.`biblioitemnumber`, `me`.`barcode`, `me`.`dateaccessioned`,
`me`.`booksellerid`, `me`.`homebranch`, `me`.`price`, `me`.`replacementprice`,
`me`.`replacementpricedate`, `me`.`datelastborrowed`, `me`.`datelastseen`,
`me`.`stack`, `me`.`notforloan`, `me`.`damaged`, `me`.`damaged_on`,
`me`.`itemlost`, `me`.`itemlost_on`, `me`.`withdrawn`, `me`.`withdrawn_on`,
`me`.`itemcallnumber`, `me`.`coded_location_qualifier`, `me`.`issues`,
`me`.`renewals`, `me`.`reserves`, `me`.`restricted`, `me`.`itemnotes`,
`me`.`itemnotes_nonpublic`, `me`.`holdingbranch`, `me`.`timestamp`,
`me`.`location`, `me`.`permanent_location`, `me`.`onloan`, `me`.`cn_source`,
`me`.`cn_sort`, `me`.`ccode`, `me`.`materials`, `me`.`uri`, `me`.`itype`,
`me`.`more_subfields_xml`, `me`.`enumchron`, `me`.`copynumber`,
`me`.`stocknumber`, `me`.`new_status`,
`me`.`exclude_from_local_holds_priority`,
`branchtransfers`.`branchtransfer_id`, `branchtransfers`.`itemnumber`,
`branchtransfers`.`daterequested`, `branchtransfers`.`datesent`,
`branchtransfers`.`frombranch`, `branchtransfers`.`datearrived`,
`branchtransfers`.`datecancelled`, `branchtransfers`.`tobranch`,
`branchtransfers`.`comments`, `branchtransfers`.`reason`,
`branchtransfers`.`cancellation_reason`, `reserves`.`reserve_id`,
`reserves`.`borrowernumber`, `reserves`.`reservedate`,
`reserves`.`biblionumber`, `reserves`.`branchcode`, `reserves`.`desk_id`,
`reserves`.`notificationdate`, `reserves`.`reminderdate`,
`reserves`.`cancellationdate`, `reserves`.`cancellation_reason`,
`reserves`.`reservenotes`, `reserves`.`priority`, `reserves`.`found`,
`reserves`.`timestamp`, `reserves`.`itemnumber`, `reserves`.`waitingdate`,
`reserves`.`expirationdate`, `reserves`.`lowestPriority`, `reserves`.`suspend`,
`reserves`.`suspend_until`, `reserves`.`itemtype`,
`reserves`.`item_level_hold`, `reserves`.`non_priority` FROM `items` `me` LEFT
JOIN `branchtransfers` `branchtransfers` ON `branchtransfers`.`itemnumber` =
`me`.`itemnumber` LEFT JOIN `reserves` `reserves` ON `reserves`.`itemnumber` =
`me`.`itemnumber` WHERE ( ( ( `biblionumber` NOT IN ( ?, ?, ?, ?, ?, ? ) OR
`biblionumber` IS NULL ) AND `itemlost` = ? AND ( `itype` NOT IN ( ?, ? ) OR
`itype` IS NULL ) AND ( `location` NOT IN ( ?, ? ) OR `location` IS NULL ) AND
`me`.`biblionumber` = ? AND 1=1 ) ) ORDER BY `me`.`itemnumber`"

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