[Koha-bugs] [Bug 34609] New: Holds history errors 500 if old_reserves.biblionumber is NULL

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

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

            Bug ID: 34609
           Summary: Holds history errors 500 if old_reserves.biblionumber
                    is NULL
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Hold requests
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: pedro.amorim at ptfs-europe.com
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com, jonathan.druart+koha at gmail.com,
                    katrin.fischer at bsz-bw.de,
                    martin.renvoize at ptfs-europe.com,
                    nick at bywatersolutions.com, tomascohen at gmail.com
        Depends on: 32894

To reproduce, clean k-t-d:

1) Add a reserve to koha/koha user, mysql run:
insert into reserves(borrowernumber, reservedate, branchcode, cancellationdate,
timestamp, biblionumber) 
VALUES (51, '2022-09-23', 'CPL', '2022-09-23', '2022-09-23 15:46:21', 76);

2) Add an old_reserve to koha/koha user, mysql run:
insert into old_reserves(borrowernumber, reservedate, branchcode,
cancellationdate, timestamp, reserve_id) 
VALUES (51, '2022-09-23', 'CPL', '2022-09-23', '2022-09-23 15:46:21', 1);

3) Visit holdshistory on either OPAC (requires OPACHoldsHistory sys pref) or
STAFF 
STAFF/cgi-bin/koha/members/holdshistory.pl?borrowernumber=1
OPAC//cgi-bin/koha/opac-holdshistory.pl

4) Notice it blows up with a 500 error


Referenced Bugs:

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32894
[Bug 32894] Objects cache methods' result without invalidation
-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.