|
|
| Reporter | pnadam | Assigned To | | |
|---|
| Priority | none | Severity | minor | |
|---|
| Status | closed | Resolution | open | |
|---|
| Product Version | 2.7x.x | |
|---|
This bug affects 1 person(s).
12
|
|
| Summary | 12803: 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 |
- Create a survey
- Add a multiple choice question 'Q1'
- 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.
- 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.
- Inspect the responses and note that Q2 is blank, correctly so, for the responses in which it was not asked.
- Inspect the database table of responses for this survey and not that Q2 is NULL for the responses in which it was not asked.
- Edit a response in which Q2 was not asked and is thus blank. Do not change Q2 in any way.
- Inspect the responses and note that Q2 is blank, correctly so, for the responses in which it was not asked.
- 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. |
|---|
| Tags | No tags attached. |
|---|
| Attached Files | |
|---|
|
|
| Bug heat | 12 |
|---|
| Complete LimeSurvey version number (& build) | 2.72.1+171012 |
|---|
| I will donate to the project if issue is resolved | No |
|---|
| Browser | |
|---|
| Database type & version | MySQL 14.14, LS DB v263 |
|---|
| Server OS (if known) | Debian 7 |
|---|
| Webserver software & version (if known) | Apache 2.22.22 Debian |
|---|
| PHP Version | 5.6.25 |
|---|
|
|
