View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
15522Bug reportsSurvey editingpublic2019-11-02 19:152022-07-05 15:36
Reportertbarrows Assigned Togabrieljenik  
PriorityhighSeveritypartial_block 
Status closedResolutionunable to reproduce 
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.
Attached Files
image.png (1,838 bytes)   
image.png (1,838 bytes)   
image-2.png (1,838 bytes)   
image-2.png (1,838 bytes)   
Bug heat6
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 type & versionmySQL 5.6
Server OS (if known)
Webserver software & version (if known)
PHP Version7.1

Users monitoring this issue

There are no users monitoring this issue.

Activities

cdorin

cdorin

2019-11-03 15:38

reporter   ~54347

hey @tbarrows,

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

cdorin

2019-11-03 18:00

reporter   ~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.

limesurvey_survey_538577.lss (267,093 bytes)
cdorin

cdorin

2019-11-05 16:25

reporter   ~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!
gabrieljenik

gabrieljenik

2022-04-22 15:03

manager   ~69195

Hello tbarrows,
Seems this issue was hard to reproduce and it is quite old.
Do you have any other feedback?
Can you please check if this issue still exists in the latest version of LimeSurvey and let us know?
Thank you!
gabrieljenik

gabrieljenik

2022-07-05 15:36

manager   ~70739

Hello tbarrows,

we have asked for feedback on this issue. Because we did not get an answer we assume that the issue is resolved.
However, should you be able to reproduce the issue using the latest version, please feel free to re-open the issue and give us exact details on how to reproduce it.

Thank you and best regards,

gabrieljenik

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
2020-04-01 16:52 cdorin Zoho Sprints => |Yes|
2020-04-01 16:52 swendrich Zoho Sprints ID => 14469000000018121
2021-02-04 10:15 cdorin Status assigned => new
2021-02-04 12:17 cdorin Assigned To cdorin =>
2021-02-04 12:17 cdorin Status new => acknowledged
2022-04-22 15:03 gabrieljenik Assigned To => gabrieljenik
2022-04-22 15:03 gabrieljenik Status acknowledged => feedback
2022-04-22 15:03 gabrieljenik Note Added: 69195
2022-04-22 15:03 gabrieljenik Bug heat 4 => 6
2022-07-05 15:36 gabrieljenik Status feedback => closed
2022-07-05 15:36 gabrieljenik Resolution open => fixed
2022-07-05 15:36 gabrieljenik Note Added: 70739
2022-07-05 15:36 gabrieljenik Resolution fixed => unable to reproduce