View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|12803||Bug reports||[All Projects] Response browsing||public||2017-10-18 12:36||2017-10-22 11:30|
|Target Version||Fixed in Version|
|Summary||12803: Editing a response turns NULL data into no-value data, which exposes a separate bug|
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|
I've also included the reproduction/findings for me investigating these two related bugs as one end-user issue.
|Tags||No tags attached.|
|Complete LimeSurvey version number (& build)||2.72.1+171012|
|I will donate to the project if issue is resolved||No|
|Database & DB-Version||MySQL 14.14, LS DB v263|
|Server OS (if known)||Debian 7|
|Webserver software & version (if known)||Apache 2.22.22 Debian|
Blank Data Export Issue Reproduction.pdf (248,823 bytes)
The other bug exposed by this bug has been logged and has ID 12804
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.
|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|