View Issue Details

IDProjectCategoryView StatusLast Update
0001310Main CAcert Websiteaccount administrationpublic2015-02-09 22:30
ReporterINOPIAE Assigned ToTed  
PrioritynormalSeverityminorReproducibilityhave not tried
Status needs reviewResolutionopen 
PlatformDefaultOSWindows 7 
Product Version2014 Q4 
Target Version2014 Q4Fixed in Version2013 Q3 
Summary0001310: The check about email during email dispute works incorrect
DescriptionTaken from Ticket s20141001.32
I observed that there was an email disput that fires this mail:
Someone has just attempted to dispute this email 'someone@domain.tld', which belongs to a locked account: xxxxx

By looking at the accounts with 'someone@domain.tld' I find one deleted account following the old delete account predent case which of course is locked.
The second account is an active not blocked account.

The problem seems to be a wrong sql statement where there is no check if the email is deleted.
Tagscertificates, company register, domain
Reviewed byBenBE
Test Instructionssee https://bugs.cacert.org/view.php?id=1310#c5051

Activities

INOPIAE

2014-10-01 20:22

updater   ~0005042

Last edited: 2014-10-28 20:39

View 2 revisions

fix available under https://github.com/INOPIAE/CAcert/commit/3a5f13b14f21ce3e0ff8107c31c563a9de8c3fb0

INOPIAE

2014-10-14 20:32

updater   ~0005051

Last edited: 2014-10-28 13:34

View 9 revisions

Test instruction
This email address belongs to a deleted account: deleted-test@acme.com
It can be used for the test.

You should be able to added the address to your account and not be able to dispute it.

Alternatively you can create an new account, deleted it and than try to get the email of the deleted account either disputed, which should be unsuccessful, or to add the address to a new account.

BenBE

2014-10-28 21:01

updater   ~0005076

Applied on test system. Please test and review.

Eva

2014-12-02 20:32

updater   ~0005144

I tried to dispute the email address deleted-test@acme.com
-> email was not in the system

I tried to add email address deleted-test@acme.com to my account
-> email could be added

(I removed the address again for further tests.)

=> OK

felixd

2014-12-02 20:34

updater   ~0005145

I tried to dispute the address, which was not possible.
I tried to add the address to my account, which was possible.
I removed the email address from my account.

=> OK

Issue History

Date Modified Username Field Change
2014-10-01 18:48 INOPIAE New Issue
2014-10-01 18:48 INOPIAE Assigned To => INOPIAE
2014-10-01 20:22 INOPIAE Note Added: 0005042
2014-10-01 20:22 INOPIAE Assigned To INOPIAE => BenBE
2014-10-01 20:22 INOPIAE Status new => fix available
2014-10-04 09:40 Ruel Print OS => Windows 7
2014-10-04 09:40 Ruel Print OS Version => Ultimate
2014-10-04 09:40 Ruel Print Platform => Default
2014-10-04 09:40 Ruel Print Fixed in Version => 2013 Q3
2014-10-04 09:41 Ruel Print Tag Attached: domain
2014-10-04 09:41 Ruel Print Tag Attached: company register
2014-10-04 09:41 Ruel Print Tag Attached: certificates
2014-10-04 09:49 Ruel Print Issue cloned: 0001311
2014-10-14 20:15 BenBE Source_changeset_attached => cacert-devel testserver-stable 3b8168b5
2014-10-14 20:15 INOPIAE Source_changeset_attached => cacert-devel testserver-stable 3a5f13b1
2014-10-14 20:32 INOPIAE Note Added: 0005051
2014-10-14 20:33 INOPIAE Note Edited: 0005051 View Revisions
2014-10-14 20:34 INOPIAE Test Instructions => see https://bugs.cacert.org/view.php?id=1310#c5051
2014-10-14 20:37 INOPIAE Note Edited: 0005051 View Revisions
2014-10-14 20:37 INOPIAE Note Edited: 0005051 View Revisions
2014-10-14 20:38 INOPIAE Note Edited: 0005051 View Revisions
2014-10-14 20:39 INOPIAE Note Edited: 0005051 View Revisions
2014-10-14 20:40 INOPIAE Note Edited: 0005051 View Revisions
2014-10-14 20:40 INOPIAE Note Edited: 0005051 View Revisions
2014-10-28 13:34 INOPIAE Note Edited: 0005051 View Revisions
2014-10-28 20:39 BenBE Note Edited: 0005042 View Revisions
2014-10-28 21:01 BenBE Reviewed by => BenBE
2014-10-28 21:01 BenBE Note Added: 0005076
2014-10-28 21:01 BenBE Status fix available => needs review & testing
2014-12-02 20:32 Eva Note Added: 0005144
2014-12-02 20:34 felixd Note Added: 0005145
2014-12-23 20:35 Eva Status needs review & testing => needs review
2014-12-23 20:35 Eva Assigned To BenBE => NEOatNHNG
2015-02-09 22:30 Ted Assigned To NEOatNHNG => Ted