Launchpad itself

Move ~maldicore's email adress to ~shunan

Asked by Curtis Hovey

~shunan's email address was used for the ~maldicore team's contact address, now he does not own his own email address.

We need to update the email table transfer <email address hidden> to ~shunan.He will have to use a the password reset link from the login screen to verify the address is his and set it to preferred.

Question information

Language:
English Edit question
Status:
Solved
For:
Launchpad itself Edit question
Assignee:
[LEGACY] Canonical WebOps Edit question
Last query:
Last reply:
Whiteboard:
Do we have SQL to move the email address from the team?
Revision history for this message
Steve McInerney (spm) said : 		#1

<sinzui> spm, you wont see the error, we hide it in the UI, so the use has no clue that his email address is still held by the team. I saw the address there when the user reported the issue, another user tried to help, only succeeding in hiding the problem

Hmm. Am not sure I fully appreciate the problem here. So in an attempt tp rephrase:

~shunan apparently has 2 emails associated with theirself.
1. obviously personal as per the home page
2. related to the team in question

The 1st has status 4 on the emailaddress; the 2nd has status 2.

AIUI, we can simply delete the undesirable email address from the emailaddress table. Identifiable by:
select * from emailaddress where person = (select id from person where name = 'maldicore');

???

Cheers!
- Steve

Revision history for this message
Curtis Hovey (sinzui) said : 		#2

All unused team email addresses were removed in a db update. The email address can be registered again.

Revision history for this message
Curtis Hovey (sinzui) said : 		#3

This issue was indreictly solved by the db update.