View Issue Details

IDProjectCategoryView StatusLast Update
15522Bug reportsSurvey editingpublic2020-04-01 16:52
Reportertbarrows Assigned Tocdorin  
PriorityhighSeveritypartial_block 
Status assignedResolutionopen 
Product Version3.19.1 
Summary15522: Changing a relevance equation of a single group can cause mass drop of answers in multiple groups
Description

I'm using LimeSurvey 3.19 hosted on Siteground.com. We have a dozen groups each with 10 questions. Each questions has three answers options. We created the survey in both English and Spanish (Mexican). We created the groups and an questions and then subsequent went back to the group level to write the expression to show each group based upon the age range of the participant thusly: "(strtotime('now')-strtotime(D004))/60/60/24/365 >= 0.083 and (strtotime('now')-strtotime(D004))/60/60/24/365 < 0.333
" (i.e.; show the group for age range > 1 month and <4 month olds). However, we discovered that making a change to an relevance equation causes a mass drop in the answers table across all groups. We lost over a hundred answers. I added back all the answers using pre-defined label sets but again, when a tweak is required of a single relevance equation for a single group, we suffered a table drop of our answers.

Is this a known bug or is this known behavior?

Steps To Reproduce
  1. Create a survey with groups, questions, and answers (using pre-definted label sets)
  2. write a relevance equation; we used this: (strtotime('now')-strtotime(D004))/60/60/24/365 >= 0.083 and (strtotime('now')-strtotime(D004))/60/60/24/365 < 0.333
  3. Check for the persistence of the previously created answers to questions not just under the edited group, but all groups.
TagsNo tags attached.
Complete LimeSurvey version number (& build)Version 3.19.3+191023
I will donate to the project if issue is resolvedYes
BrowserFirefox 69.0.3
Database & DB-VersionmySQL 5.6
Server OS (if known)
Webserver software & version (if known)
PHP Version7.1

Activities

tbarrows

tbarrows

2019-11-02 19:15

reporter  

image.png (1,838 bytes)   
image.png (1,838 bytes)   
image-2.png (1,838 bytes)   
image-2.png (1,838 bytes)   
cdorin

cdorin

2019-11-03 15:38

manager   ~54347

hey @tbarrows,

Could you please submit also an .lss file? Where you have the issue?

cdorin

cdorin

2019-11-03 18:00

manager   ~54365

Last edited: 2020-04-01 16:52

Could you please attach an .lss where the issue exists?

Have you tried to test it further using the free instance provided on limesurvey.org?

tbarrows

tbarrows

2019-11-03 18:31

reporter   ~54371

Last edited: 2020-04-01 16:52

I have not yet tried to recreate it on a new instance but I will try that next. See lss file.

cdorin

cdorin

2019-11-05 16:25

manager   ~54409

Last edited: 2020-04-01 16:52

Ok, I don;t thin that the issue is related to the expressions. Rather by the usage of predefined label sets which just cannot get stored. I will further investigate this one. Thanks for your report!

Issue History

Date Modified Username Field Change
2019-11-02 19:15 tbarrows New Issue
2019-11-02 19:15 tbarrows File Added: image.png
2019-11-02 19:15 tbarrows File Added: image-2.png
2019-11-03 15:38 cdorin Note Added: 54347
2019-11-03 18:00 cdorin Assigned To => cdorin
2019-11-03 18:00 cdorin Status new => feedback
2019-11-03 18:00 cdorin Note Added: 54365
2019-11-03 18:31 tbarrows File Added: limesurvey_survey_538577.lss
2019-11-03 18:31 tbarrows Note Added: 54371
2019-11-03 18:31 tbarrows Status feedback => assigned
2019-11-05 16:25 cdorin Note Added: 54409
2019-11-05 16:30 cdorin Priority none => high