View Issue Details

IDProjectCategoryView StatusLast Update
14289Bug reportsSurvey participants (Tokens)public2018-11-27 01:09
Reportermfavetti Assigned Tomfavetti  
Status assignedResolutionopen 
Product Version3.15.x 
Summary14289: Token column is blank when selecting "Not completed" or "Not started" status for token export

In the token status dropdown, selecting "Not completed" or "Not started" generates a CSV with a blank token column. Suspect this has to do with identically named columns overwriting each other in the leftJoin call for those two options. Since the where clause limits to where there is no row in the result table, the token column for the token table will be overwritten with a NULL from the token column for the result table. Can fix this by modifying the query's select clause.

PR incoming

Steps To Reproduce

Create a survey
Create participants table
Add a participant
Export participants with "Not completed" or "Not started", token will be blank.

TagsNo tags attached.
Complete LimeSurvey version number (& build)3.15.5+181115
I will donate to the project if issue is resolvedNo
BrowserChrome 70.0.3538.110
Database & DB-VersionMariaDB 10.3
Server OS (if known)Linux Mint 19
Webserver software & version (if known)nginx 1.14.1
PHP Version7.2.12


Issue History

Date Modified Username Field Change
2018-11-26 23:48 mfavetti New Issue
2018-11-26 23:48 mfavetti Status new => assigned
2018-11-26 23:48 mfavetti Assigned To => mfavetti
2018-11-27 01:09 mfavetti Note Added: 49792