Holds history breaks when old holds connect to a deleted target
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Confirmed
|
Medium
|
Unassigned |
Bug Description
/usr/sbin/apache2 [ERR :55401:
Can't call method "id" on an undefined value at /usr/local/
Here is the sql that identifies this situation:
select * from action.hold_request where usr in(
select id from actor.usr where usrname=
)
-- and hold_type='M' and target not in(select id from metabib.metarecord)
-- and hold_type='P' and target not in(select id from biblio.
-- and hold_type='C' and target not in(select id from asset.copy where not deleted)
and hold_type='T' and target not in(select id from biblio.record_entry where not deleted)
order by hold_type
Uncomment the hold type lines one at a time until you find the type that returns row(s)
Changed in evergreen: | |
status: | New → Confirmed |
importance: | Undecided → Medium |
tags: | added: holds opac |
tags: |
added: circ-holds removed: holds |
I'm seeing this on 2.12.8, and I'm fairly confident it continues to be an issue in later releases.