View Issue Details

This bug affects 1 person(s).
IDProjectCategoryView StatusLast Update
15522Bug reportsSurvey editingpublic2021-02-04 12:17
Reportertbarrows Assigned To 
Status acknowledgedResolutionopen 
Product Version3.19.1 
Summary15522: Changing a relevance equation of a single group can cause mass drop of answers in multiple groups
DescriptionI'm using LimeSurvey 3.19 hosted on 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 Reproduce1. 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.
Bug heat4
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

User List There are no users monitoring this issue.




2019-11-02 19:15


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


2019-11-03 15:38

manager   ~54347

hey @tbarrows,

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


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


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.


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
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