View Issue Details

IDProjectCategoryView StatusLast Update
12803Bug reports[All Projects] Response browsingpublic2017-10-22 11:30
Reporterpnadam Assigned To 
PrioritynoneSeverityminor 
Status newResolutionopen 
Product Version2.7x.x 
Target VersionFixed in Version 
Summary12803: Editing a response turns NULL data into no-value data, which exposes a separate bug
Description

When one browses responses and edits one, any answers for questions that are not asked, for example because they are not relevant and were thus skipped, have their data in the database changed from NULL to an empty value, e.g. from NULL to an empty string.

This exposes a separate bug wherein the empty string causes incorrect data exports. I will log the separate bug separately and then add the issue numbers to each other's reports when both are logged.

Steps To Reproduce
  1. Create a survey
  2. Add a multiple choice question 'Q1'
  3. Add another multiple choice question 'Q2' and make the relevance equation such that it is only asked if Q2 was answered with a specific response.
  4. Activate the survey and fill in some surveys: some where Q2 is asked and answered, and some where Q2 is not asked because Q1 was answered such that Q2's relevance equation was not matched.
  5. Inspect the responses and note that Q2 is blank, correctly so, for the responses in which it was not asked.
  6. Inspect the database table of responses for this survey and not that Q2 is NULL for the responses in which it was not asked.
  7. Edit a response in which Q2 was not asked and is thus blank. Do not change Q2 in any way.
  8. Inspect the responses and note that Q2 is blank, correctly so, for the responses in which it was not asked.
  9. Inspect the database table of responses for this survey and note that Q2 is now an empty value instead of NULL, for the responses in which it was not asked.
Additional Information

I've also included the reproduction/findings for me investigating these two related bugs as one end-user issue.

TagsNo tags attached.
Complete LimeSurvey version number (& build)2.72.1+171012
I will donate to the project if issue is resolvedNo
Browser
Database & DB-VersionMySQL 14.14, LS DB v263
Server OS (if known)Debian 7
Webserver software & version (if known)Apache 2.22.22 Debian
PHP Version5.6.25

Relationships

has duplicate 12804 closedc_schmitz Bug reports Exporting responses using 'Answer Codes (replace Yes with 1 and No with 2)', causes false 2 values for resps affected by 12803 
related to 12813 new Feature requests Allow validate survey via an admin function 

Activities

pnadam

pnadam

2017-10-18 12:36

reporter  

Blank Data Export Issue Reproduction.pdf (248,823 bytes)
pnadam

pnadam

2017-10-18 12:47

reporter   ~44720

Last edited: 2017-10-20 11:45

View 2 revisions

The other bug exposed by this bug has been logged and has ID 12804

DenisChenu

DenisChenu

2017-10-22 11:30

developer   ~44780

About NULL values : we have some other bug for DECIMAL (numeric and numti-numerci question type) and DATETIME (date question type)). For this 2 database question tyope : there are no difference between 'Not seen' and 'not answered' value.
:)

Issue History

Date Modified Username Field Change
2017-10-18 12:36 pnadam New Issue
2017-10-18 12:36 pnadam File Added: Blank Data Export Issue Reproduction.pdf
2017-10-18 12:47 pnadam Note Added: 44720
2017-10-20 11:45 c_schmitz Note Edited: 44720 View Revisions
2017-10-20 15:59 c_schmitz Relationship added has duplicate 12804
2017-10-21 16:07 DenisChenu Relationship added related to 12813
2017-10-22 11:30 DenisChenu Note Added: 44780