restore a deleted user

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

restore a deleted user

mahtab seifi
i have a request.
i want to restore a deleted user,how can do it?


_______________________________________________
support-bugzilla mailing list
[hidden email]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [hidden email] in the To: field when you reply.
Reply | Threaded
Open this post in threaded view
|

RE: restore a deleted user

Tosh, Michael J
One option is to find out what their userid was and insert a record for
them back into the profiles table in MySQL.  Very much a back-door
operation, and may not work correctly, so be careful.

Another option is to create a new account for the user, and update each
field in each table that references the old account:
update bugs set reporter=<newid> where reporter=<oldid>
update bugs set qa_contact=<newid> where qa_contact=<oldid>
update bugs set assigned_to=<newid> where assigned_to=<oldid>
update bugs_activity set who=<newid> where who=<oldid>

There are a ton more places where that needs to be updated, but sanity
check can point those out for you.


-----Original Message-----
From: [hidden email]
[mailto:[hidden email]] On Behalf Of mahtab
seifi
Sent: Monday, November 12, 2007 3:22 AM
To: [hidden email]
Subject: restore a deleted user

i have a request.
i want to restore a deleted user,how can do it?


_______________________________________________
support-bugzilla mailing list
[hidden email]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [hidden email] in the To: field when you
reply.
_______________________________________________
support-bugzilla mailing list
[hidden email]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [hidden email] in the To: field when you reply.
Reply | Threaded
Open this post in threaded view
|

Re: restore a deleted user

Frédéric Buclin
In reply to this post by mahtab seifi
Tosh, Michael J a écrit :
> One option is to find out what their userid was and insert a record for
> them back into the profiles table in MySQL.

This won't work. As soon as a user account is deleted from the UI, *all*
his data is deleted. There is absolutely no way to get it back.

LpSolit
_______________________________________________
support-bugzilla mailing list
[hidden email]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [hidden email] in the To: field when you reply.