View Issue Details

IDProjectCategoryView StatusLast Update
0001259Main CAcert Websiteaccount administrationpublic2016-08-14 17:44
ReporterINOPIAE Assigned To 
PrioritynormalSeverityminorReproducibilityhave not tried
Status newResolutionopen 
Summary0001259: Database cleanup regarding deleted accounts
DescriptionThis bug is a split of bug 1223 regarding the database cleanup for deleted accounts.
Additional InformationOrgininal bug text:
In the support case [s20131125.67] a member asked for a deleted account. He could not access it, and searching in the SE console I could not find it either. However if he used the 'Lost password' link on the login website, entered the email address and correct birthdate, he got to step 2 of password recovery. That means, here his account showed up.

This looked strange to me, since normally as SE I can search even for deleted email addresses and I find all accounts this email address belongs to or previously belonged. But in this case I didn't find it.

So I asked Wytze and he told me: "This email address can be found in the table `email`, but with the field `deleted`. It can also be found in the table
`users`, again with `deleted`."

It thus showed up that the handling of the `deleted` field in the software is rather inconsistent. I suggest that this handling should be straightened in the way that an SE always can see all email addresses, domains and accounts that ever existed. If there is more than one account, in the list of the accounts to select, a flag should be added to show if it is an active account, email address or domain or if it is deleted.
TagsNo tags attached.
Reviewed by
Test Instructions


related to 0001223 needs review & testingNEOatNHNG Handling of deleted accounts, email addresses and domains 



2016-08-14 17:44

updater   ~0005525

Arbitrator entry:
I am the Arbitrator of a20140316.1 - "database cleanup regarding deleted accounts" [1]. Piet Starreveld is the Case Manager.

That case is related to bug 0001259.

I hereby give the following preliminary ruling:

A patch for bug 1259 may not be set productive until the arbitration case a20140316.1 is decided or there is a ruling in that case that allows to set such a patch productive.

Eva Stöwe - 2016-08-14


Issue History

Date Modified Username Field Change
2014-03-16 11:44 INOPIAE New Issue
2014-03-16 11:45 INOPIAE Relationship added related to 0001223
2016-08-14 17:44 Eva Note Added: 0005525