16575: When email field (core attribute) is encrypted, answer is not counted in participants database

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

16575	Bug reports	Survey participants (Tokens)	public	2020-08-08 12:50	2021-03-29 12:31

Reporter	kjnerhus	Assigned To	p_teichmann
Priority	normal	Severity	minor
Status	closed	Resolution	fixed
Product Version	4.3.9

Summary	16575: When email field (core attribute) is encrypted, answer is not counted in participants database
Description	Invitation mail is sendt to participant, and participant answers the survey. Answer is saved in participants database.
Steps To Reproduce	-Go to attributes -Encrypt email attribute -send invitation email to participant -Participant answers survey -Check "show participants" to see if survey completed date is present it is not present, then: -uncheck encryption of email attribute -send invitation email to participant -Participant answers survey -Check "show participants" to see if survey completed date is present it is then present
Tags	No tags attached.

Bug heat	16
Complete LimeSurvey version number (& build)	LimeSurvey 4.3.9+200806
I will donate to the project if issue is resolved	No
Browser	chrome
Database type & version	Mysql 5.0.12
Server OS (if known)	centos
Webserver software & version (if known)
PHP Version	7.2

User List	kjnerhus

kjnerhus 2020-08-08 13:04 reporter ~59375	Related to bug 16122, which was fixed in Release 4.2.1+200428 But the problem is back in later releases.

kjnerhus 2020-08-08 13:25 reporter ~59376 Last edited: 2021-02-06 16:09	My latest comment was a incorrect. What was fixed in release 4.2.1 was that the participant was marked as invited when email was sent. The current issue is that the answer is not marked as completed.

cdorin 2020-10-19 17:09 reporter ~60271 Last edited: 2021-02-06 16:09	Thanks @kjnerhus for report! Have you had time to test further this issue? Does it happen only if email is encrypted but all other fields are not?

kjnerhus 2021-02-06 16:07 reporter ~61967 Last edited: 2021-02-06 16:09	Sorry for my late answer. Tried this again now in Versjon 4.4.1+210201. 1) All attribute fields encrypted, including email field: Answer from participant is not saved in database, and not counted. 2) All attribute fields encrypted, except email field: Answer from participant is then saved in database, and counted - everything normal as it should.

cdorin 2021-02-06 16:09 reporter ~61968 Last edited: 2021-02-06 16:09	Thanks a lot for feedback, @kjnerhus. We are on encryption atm :)

p_teichmann 2021-03-29 10:26 administrator ~63671	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=31416

lime_release_bot 2021-03-29 12:31 administrator ~63687	Fixed in Release 4.4.15+210329

Date Modified	Username	Field	Change
2020-08-08 12:50	kjnerhus	New Issue
2020-08-08 12:51	kjnerhus	Issue Monitored: kjnerhus
2020-08-08 13:04	kjnerhus	Note Added: 59375
2020-08-08 13:25	kjnerhus	Note Added: 59376
2020-10-19 17:09	cdorin	Note Added: 60271
2020-10-19 17:31	cdorin	Status	new => confirmed
2020-10-19 17:32	cdorin	Priority	none => normal
2021-02-06 16:07	kjnerhus	Note Added: 61967
2021-02-06 16:09	cdorin	Note Added: 61968
2021-02-06 16:09	cdorin	Sync to Zoho Project	=> \|Yes\|
2021-03-26 14:39	c_schmitz	Assigned To	=> p_teichmann
2021-03-26 14:39	c_schmitz	Status	confirmed => assigned
2021-03-29 10:26	p_teichmann	Changeset attached	=> LimeSurvey master 0eb34617
2021-03-29 10:26	p_teichmann	Note Added: 63671
2021-03-29 10:26	p_teichmann	Resolution	open => fixed
2021-03-29 10:42	p_teichmann	Relationship added	has duplicate 16946
2021-03-29 12:31	lime_release_bot	Sync to Zoho Project	Yes => \|Yes\|
2021-03-29 12:31	lime_release_bot	Note Added: 63687
2021-03-29 12:31	lime_release_bot	Status	assigned => closed
2021-08-02 21:24	guest	Bug heat	14 => 16

LimeSurvey: master 0eb34617 2021-03-12 13:40 p_teichmann Details Diff	Fixed issue 16575: Token not marked as answered if email encryption is turned on	Affected Issues 16575
	mod - application/helpers/frontend_helper.php	Diff File
	mod - application/views/admin/super/layout_insurvey.php	Diff File