Jeff Silvis's Blog

Problem

Louise told me that the following two purls produced an error when accessed:
http://purl.umn.edu/114817
http://purl.umn.edu/113790

The cause

It turns our that both in_archive and withdrawn are set to false.

dspace_sr=> select * from handle where handle = 113790;
 handle_id | handle | resource_type_id | resource_id 
-----------+--------+------------------+-------------
     51427 | 113790 |                2 |       53352


dspace_sr=> select * from item where item_id = 53352;

 item_id | submitter_id | in_archive | withdrawn |       last_modified        | owning_collection 
---------+--------------+------------+-----------+----------------------------+-------------------
   53352 |         2680 | f          | f         | 2011-08-25 12:58:34.912-05 |                  
(1 row)

I think that both variables should not be set to f.

The solution

Set withdrawn to t and the Louise can resubmit the metadata:

UPDATE item SET withdrawn = 'T' WHERE item_id = 53352;