Comment 10 for bug 684112

Revision history for this message
Curtis Hovey (sinzui) wrote : Re: Link to PPA merged owner from +archivesubscriptions is broken

This might be the script to run one Edwin's merge fix is released:
-- Deactivate all archives that belong to merged users.
-- Set archive ito DELETING and disable it.
-- This assumes all jobs are complete.
update archive
set
    status = 1,
    enabled = FALSE
from
    person p
where
    p.id = a.owner
    and p.merged is not null
    and a.status = 0;
;