Registering with email that may have been used previously on a different account

[Sam-Amy]

Registering with email address npms@ceh.ac.uk is causing it to be assigned the warehouse ID of another existing account (16), and automatically changing the email address now associated with that account in the warehouse, with the iRecord People table showing two accounts with ID16. I assume this may be because the npms email was at some point associated with user ID16, and perhaps needs totally purging from the database (i.e. even with deleted flag), though I'm not sure if/how I can do this.

I've edited the email address for ID16 in the people table of the warehouse back to what it should be, and deleted the iRecord NPMS acccount for now, but it would be helpful to be able to open a seperate account with this email address if the above can be resolved easily.

[johnvanbreda]

This is because when an email address is changed, the old email address is kept in the user_identifiers table. Account 16 does have the npms email in its user identifiers table so not only do you need to fix the email in the people table, you should remove the email from user_identifiers in order to properly remove the email address from account 16.

-- check
select * from user_identifiers where user_id=16;
-- now delete
delete from user_identifiers where user_id=16 and identifier='npms@ceh.ac.uk'

I've not run this script so let me know if you need a hand.

[Sam-Amy]

Thanks John.

It looks like this can't be done via the warehouse UI, in which case @BirenRathod are you able to run the following please as I have read only access? Thanks

delete from user_identifiers where user_id=16 and identifier='npms@ceh.ac.uk'

[BirenRathod]

@Sam-Amy you mentioned at the top "I've edited the email address for ID16 in the people table of the warehouse back to what it should be, " What email address have you edited with?

[Sam-Amy]

bire@ceh.ac.uk - apologies if this is wrong! You can change here is so: https://warehouse1.indicia.org.uk/index.php/person/edit_from_user/16

[BirenRathod]

@Sam-Amy I don't think that has changed anything? I can still see npms@ceh.ac.uk address in the people table in the database.

[Sam-Amy]

Oh yes, so can I now - that is strange becasue I did change and save, though this was before I then deleted the NPMS account so we can try again now.

[Sam-Amy]

I think it has saved now?

[BirenRathod]

@Sam-Amy It has. Also, I deleted the record from user_identifier now. Thanks, @johnvanbreda.

[Sam-Amy]

Great, thanks @Biren and @johnvanbreda, I have now re-registered and a new user ID has been assigned. Strangely, when I registered I got these contradictory messages, but the email did come through so I don't think a concern:

[johnvanbreda]

Those messages come from Drupal, not Indicia. Maybe worth taking a look @BirenRathod in case it relates to recent email setup changes?

[Sam-Amy]

Thanks John, I'll just re-open this for now rather than start a new issue