Removing subscriptions sent to a dead email address
We recently moved our DSpace to a shiny new server, which mostly made things much faster, but also caused some funky email glitches. Once the glitches were resolved, we discovered we had a problem with DSpace email subscriptions going to no-longer-usable email addresses. As far as I can tell, DSpace doesn’t have any UI for getting rid of those subscriptions.
The fix is to go into the database and perform the following query:
delete from subscription where eperson_id = (select eperson_id from eperson where email='bouncing email here');
This doesn’t affect the eperson record in the slightest, so if your eperson was responsible for item submissions, you haven’t destroyed any provenance information. You may, however, want to check the eperson out in the dspace-admin UI to be sure you’ve removed any submission privileges they shouldn’t have any longer.