View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
14266Bug reportsSurvey participants (Tokens)public2018-11-20 13:382018-11-21 10:21
Reporterizzysteve Assigned ToDenisChenu  
PrioritynoneSeverityminor 
Status closedResolutionno change required 
Product Version3.13.x 
Summary14266: Multiple database rows for same token
Description

I am unsure if this is a bug or working as designed.

It seems to be possible to create 2 survey response rows in table survey_nnnnnn for the same token.

I would have assumed that the token in the survey_nnnnnnn table would need to be unique?

Steps To Reproduce

1) On desktop, click link to a survey in an invite email. The welcome page displays, and click Next to start survey. I checked the database and at this point a row with the token is created in the survey_nnnnnn table, with NULL in all columns.
2) On a different device, eg tablet, click link to same survey from the invite email. The welcome page displays, and click Next to start survey. When database checked, a second row for the token exists.
3) I cleared the survey (checked both rows disappeared in database). Repeated #1 and started survey again, but this time clicked 'Resume later' and filled in details. If I click the link in either the original invitation email, or the saved survey email, from the desktop, I return to the same point in the survey - so this is fine.
4) However, if I click the link from the original invite email on the tablet, I once again end up with a second row in the database.

Additional Information

My use case is a user starts a survey at work and only gets half way through it. They decide to finish it when they get home. They may just close their browser, or they may do the correct thing and click 'Resume later' (either does not seem to matter in this use case).

They get home and pick up their ipad as it also has their work email on it. They find the invitation, click the link and find they are back at the start of the survey, not at the midway point where they expected to be.

Frustrated and confused, the survey is completed by repeating answers previously given and finishing the rest. However, we now actually have 2 sets of responses in the database (one incomplete).

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)3.15.2+181107
I will donate to the project if issue is resolvedNo
BrowserChrome and Firefox
Database type & versionmysql 5.7.23
Server OS (if known)linux
Webserver software & version (if known)apache 2.4.34
PHP Version5.6.37

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2018-11-20 15:15

developer   ~49709

Last edited: 2018-11-20 15:16

https://manual.limesurvey.org/Participant_settings
Enable token-based response persistence

And :

  1. use last version please (there are some issue fixed for this)
  2. ALWAYS send a lss to reproduce issue
izzysteve

izzysteve

2018-11-20 15:34

reporter   ~49710

Ok, many thanks.

Issue History

Date Modified Username Field Change
2018-11-20 13:38 izzysteve New Issue
2018-11-20 15:15 DenisChenu Note Added: 49709
2018-11-20 15:16 DenisChenu Note Edited: 49709
2018-11-20 15:34 izzysteve Note Added: 49710
2018-11-21 10:21 DenisChenu Assigned To => DenisChenu
2018-11-21 10:21 DenisChenu Status new => closed
2018-11-21 10:21 DenisChenu Resolution open => no change required