914842 - Account Glitch

Status: VERIFIED FIXED

(Webtools Graveyard :: Air Mozilla, defect, P4)

Description

[David Weir (satdav)]

I found a bug I recently changed my mozillians email recently and it has been changed on air mozilla but my previous requests have not been moved to my new account can you do that

I recently changed my email to [e-mail] and my previous email was [e-mail] 

Can we get this linked to a mozillians account insted of emails for the requests

Comment 1

[Peter Bengtsson [:peterbe]]

Can you not log in to your old email address on Air Mozilla?
We don't yet have a way of transferring requests from one user to another.

Comment 2

[David Weir (satdav)]

not tried logging into my old acount yet 

will try this the now and if it works i will mark it as invalid

Comment 3

[David Weir (satdav)]

it wont let me to login to my old account on air mozilla as its not on my mozillains profile any more

Comment 4

[David Weir (satdav)]

Attachment: ss1.jpg

Comment 5

[Peter Bengtsson [:peterbe]]

It's clear that what needs to be done is to transfer the requests from the old account to the new account. But like I said in comment #6, we don't have this functionality. It would need to be something we do in the production database.

Comment 6

[David Weir (satdav)]

Peter can you file a bug to add that feature if possible or should i file it

Comment 8

[Peter Bengtsson [:peterbe]]

Solution to the problem is here: https://bugzilla.mozilla.org/show_bug.cgi?id=932078#c1

Comment 9

[Sheeri Cabral [:sheeri]]

As per https://bugzilla.mozilla.org/show_bug.cgi?id=932078#c1:

air_mozilla_org=# UPDATE main_suggestedevent
air_mozilla_org-# SET user_id=(select id from auth_user where email='[e-mail]')
air_mozilla_org-# WHERE
air_mozilla_org-#   user_id in (select id from auth_user where email='[e-mail]');
UPDATE 4
air_mozilla_org=# UPDATE main_suggestedeventcomment
air_mozilla_org-# SET user_id=(select id from auth_user where email='[e-mail]')
air_mozilla_org-# WHERE
air_mozilla_org-#   user_id in (select id from auth_user where email='[e-mail]');
UPDATE 2

You should be all set now.

Comment 10

[David Weir (satdav)]

I can now verify this has been fixed