Clean up dangling user references in the confirmation and subscription tables.