View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 8
IDProjectCategoryView StatusDate SubmittedLast Update
18283Bug reportsSurvey takingpublic2022-07-27 14:522022-07-28 20:00
Reportermfiora Assigned Togabrieljenik  
PrioritynoneSeveritypartial_block 
Status closedResolutionno change required 
Product Version3.28.x 
Summary18283: Unknown check prevents me from going to the next group
Description

So i have 2 questions: 2 arrays.
in the first array only have last line involved. The number in last line should be the total of the sum of the second table's second column.
So, validation only checks that in second array both fields per row are filled in and the sum of second column is equal to first array's last field.

Validation is ok but still i get the modal window saying the answers are invalid.

Steps To Reproduce

Steps to reproduce

If i set
first table: 2021 - 157420,57 - 0 - 0 - 101051,99
second table:
first column: random text in the first 4 fields
second column: 65577,31 - 15000 - 16638,12 - 3836,56

Expected result

validation is ok and let me go to the following group

Actual result

i get the modal window "Non è stata fornita una risposta valida ad una o più domande. Non è possibile continuare finchè queste risposte non siano valide."
"An invalid answer has been given to one or more questions. It's not possible to go on until those answers are valid"

Counterproof

If i set
first table: 2021 - 157420,57 - 0 - 0 - 101051,99
second table:
first column: random text in the first 4 fields
second column: 65577,31 - 15000 - 16638,13 - 3836,55

TagsNo tags attached.
Attached Files
limesurvey_survey_874329.lss (29,539 bytes)    
<?xml version="1.0" encoding="UTF-8"?>
<document>
 <LimeSurveyDocType>Survey</LimeSurveyDocType>
 <DBVersion>365</DBVersion>
 <languages>
  <language>it</language>
 </languages>
 <groups>
  <fields>
   <fieldname>gid</fieldname>
   <fieldname>sid</fieldname>
   <fieldname>group_name</fieldname>
   <fieldname>group_order</fieldname>
   <fieldname>description</fieldname>
   <fieldname>language</fieldname>
   <fieldname>randomization_group</fieldname>
   <fieldname>grelevance</fieldname>
  </fields>
  <rows>
   <row>
    <gid><![CDATA[215]]></gid>
    <sid><![CDATA[874329]]></sid>
    <group_name><![CDATA[Il mio primo gruppo di domande]]></group_name>
    <group_order><![CDATA[2]]></group_order>
    <description/>
    <language><![CDATA[it]]></language>
    <randomization_group/>
    <grelevance><![CDATA[1]]></grelevance>
   </row>
   <row>
    <gid><![CDATA[217]]></gid>
    <sid><![CDATA[874329]]></sid>
    <group_name><![CDATA[test group]]></group_name>
    <group_order><![CDATA[1]]></group_order>
    <description/>
    <language><![CDATA[it]]></language>
    <randomization_group/>
    <grelevance/>
   </row>
  </rows>
 </groups>
 <questions>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>parent_qid</fieldname>
   <fieldname>sid</fieldname>
   <fieldname>gid</fieldname>
   <fieldname>type</fieldname>
   <fieldname>title</fieldname>
   <fieldname>question</fieldname>
   <fieldname>preg</fieldname>
   <fieldname>help</fieldname>
   <fieldname>other</fieldname>
   <fieldname>mandatory</fieldname>
   <fieldname>question_order</fieldname>
   <fieldname>language</fieldname>
   <fieldname>scale_id</fieldname>
   <fieldname>same_default</fieldname>
   <fieldname>relevance</fieldname>
   <fieldname>modulename</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[9663]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[874329]]></sid>
    <gid><![CDATA[215]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[Q00]]></title>
    <question><![CDATA[Una prima domanda di esempio. Per favore rispondere a questa domanda:]]></question>
    <help><![CDATA[Questo è il testo di help della domanda.]]></help>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[it]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[9725]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[874329]]></sid>
    <gid><![CDATA[217]]></gid>
    <type><![CDATA[;]]></type>
    <title><![CDATA[SEZ62QC50]]></title>
    <question><![CDATA[<p style="text-align: justify;"><strong>Table</strong></p>
]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[Y]]></mandatory>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[it]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[9726]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[874329]]></sid>
    <gid><![CDATA[217]]></gid>
    <type><![CDATA[;]]></type>
    <title><![CDATA[ALTR3]]></title>
    <question><![CDATA[<p style="text-align: justify;"> </p>
<script type="text/javascript" charset="utf-8">
$(document).on('ready pjax:scriptcomplete',function(){
let thisQuestion = $('#question{QID}');
$("input:text[id$='IMP']", thisQuestion).each(function() { 
$(this).attr("data-number", 1).addClass("dueDecimali valuta positivo"); 
});
$('colgroup', thisQuestion).remove();
$('table:first', thisQuestion).prepend('<colgroup class="col-responses"><col class="answertext" style="width: 0%;"><col class=" " style="width: 80.0%;"><col class=" " style="width: 20.0%;"></colgroup>');

});
</script>]]></question>
    <preg/>
    <help><![CDATA[<p style="text-align: right;"><strong>Totale: {(sum(that.ALTR3.sq_IMP.NAOK))} €</strong></p>
]]></help>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[2]]></question_order>
    <language><![CDATA[it]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[(SEZ62QC50_AltriFondi_Importo.NAOK > 0)]]></relevance>
    <modulename/>
   </row>
  </rows>
 </questions>
 <subquestions>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>parent_qid</fieldname>
   <fieldname>sid</fieldname>
   <fieldname>gid</fieldname>
   <fieldname>type</fieldname>
   <fieldname>title</fieldname>
   <fieldname>question</fieldname>
   <fieldname>preg</fieldname>
   <fieldname>help</fieldname>
   <fieldname>other</fieldname>
   <fieldname>mandatory</fieldname>
   <fieldname>question_order</fieldname>
   <fieldname>language</fieldname>
   <fieldname>scale_id</fieldname>
   <fieldname>same_default</fieldname>
   <fieldname>relevance</fieldname>
   <fieldname>modulename</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[9729]]></qid>
    <parent_qid><![CDATA[9725]]></parent_qid>
    <sid><![CDATA[874329]]></sid>
    <gid><![CDATA[217]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[Anno]]></title>
    <question><![CDATA[year]]></question>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[it]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[9730]]></qid>
    <parent_qid><![CDATA[9726]]></parent_qid>
    <sid><![CDATA[874329]]></sid>
    <gid><![CDATA[217]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[Alt1]]></title>
    <question/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[it]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[9736]]></qid>
    <parent_qid><![CDATA[9726]]></parent_qid>
    <sid><![CDATA[874329]]></sid>
    <gid><![CDATA[217]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[TIP]]></title>
    <question><![CDATA[Text]]></question>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[it]]></language>
    <scale_id><![CDATA[1]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance/>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[9737]]></qid>
    <parent_qid><![CDATA[9725]]></parent_qid>
    <sid><![CDATA[874329]]></sid>
    <gid><![CDATA[217]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[Importo]]></title>
    <question/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[it]]></language>
    <scale_id><![CDATA[1]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance/>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[9743]]></qid>
    <parent_qid><![CDATA[9726]]></parent_qid>
    <sid><![CDATA[874329]]></sid>
    <gid><![CDATA[217]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[Alt2]]></title>
    <question/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[2]]></question_order>
    <language><![CDATA[it]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[9744]]></qid>
    <parent_qid><![CDATA[9725]]></parent_qid>
    <sid><![CDATA[874329]]></sid>
    <gid><![CDATA[217]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[FondoCont]]></title>
    <question><![CDATA[1]]></question>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[2]]></question_order>
    <language><![CDATA[it]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[9749]]></qid>
    <parent_qid><![CDATA[9726]]></parent_qid>
    <sid><![CDATA[874329]]></sid>
    <gid><![CDATA[217]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[IMP]]></title>
    <question><![CDATA[money]]></question>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[2]]></question_order>
    <language><![CDATA[it]]></language>
    <scale_id><![CDATA[1]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance/>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[9756]]></qid>
    <parent_qid><![CDATA[9726]]></parent_qid>
    <sid><![CDATA[874329]]></sid>
    <gid><![CDATA[217]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[Alt3]]></title>
    <question/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[3]]></question_order>
    <language><![CDATA[it]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[9758]]></qid>
    <parent_qid><![CDATA[9725]]></parent_qid>
    <sid><![CDATA[874329]]></sid>
    <gid><![CDATA[217]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[FondoOneri]]></title>
    <question><![CDATA[2]]></question>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[3]]></question_order>
    <language><![CDATA[it]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[9764]]></qid>
    <parent_qid><![CDATA[9726]]></parent_qid>
    <sid><![CDATA[874329]]></sid>
    <gid><![CDATA[217]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[Alt4]]></title>
    <question/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[4]]></question_order>
    <language><![CDATA[it]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[9767]]></qid>
    <parent_qid><![CDATA[9725]]></parent_qid>
    <sid><![CDATA[874329]]></sid>
    <gid><![CDATA[217]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[FondPart]]></title>
    <question><![CDATA[3]]></question>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[4]]></question_order>
    <language><![CDATA[it]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[9769]]></qid>
    <parent_qid><![CDATA[9725]]></parent_qid>
    <sid><![CDATA[874329]]></sid>
    <gid><![CDATA[217]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[AltriFondi]]></title>
    <question><![CDATA[4]]></question>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[5]]></question_order>
    <language><![CDATA[it]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[9773]]></qid>
    <parent_qid><![CDATA[9726]]></parent_qid>
    <sid><![CDATA[874329]]></sid>
    <gid><![CDATA[217]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[Alt5]]></title>
    <question/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[5]]></question_order>
    <language><![CDATA[it]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[9776]]></qid>
    <parent_qid><![CDATA[9726]]></parent_qid>
    <sid><![CDATA[874329]]></sid>
    <gid><![CDATA[217]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[Alt6]]></title>
    <question/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[6]]></question_order>
    <language><![CDATA[it]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
  </rows>
 </subquestions>
 <question_attributes>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>attribute</fieldname>
   <fieldname>value</fieldname>
   <fieldname>language</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[9725]]></qid>
    <attribute><![CDATA[answer_width]]></attribute>
    <value><![CDATA[75]]></value>
   </row>
   <row>
    <qid><![CDATA[9725]]></qid>
    <attribute><![CDATA[hide_tip]]></attribute>
    <value><![CDATA[1]]></value>
   </row>
   <row>
    <qid><![CDATA[9725]]></qid>
    <attribute><![CDATA[numbers_only]]></attribute>
    <value><![CDATA[1]]></value>
   </row>
   <row>
    <qid><![CDATA[9726]]></qid>
    <attribute><![CDATA[answer_width]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
   <row>
    <qid><![CDATA[9726]]></qid>
    <attribute><![CDATA[em_validation_q]]></attribute>
    <value><![CDATA[sum(that.ALTR3.sq_IMP.NAOK) == SEZ62QC50_AltriFondi_Importo.NAOK AND ((count(that.ALTR3.sq_Alt1.NAOK) == 0 OR (count(that.ALTR3.sq_Alt1.NAOK) == 2) AND ALTR3_Alt1_IMP.NAOK > 0) AND (count(that.ALTR3.sq_Alt2.NAOK) == 0 OR (count(that.ALTR3.sq_Alt2.NAOK) == 2) AND ALTR3_Alt2_IMP.NAOK > 0) AND (count(that.ALTR3.sq_Alt3.NAOK) == 0 OR (count(that.ALTR3.sq_Alt3.NAOK) == 2) AND ALTR3_Alt3_IMP.NAOK > 0) AND (count(that.ALTR3.sq_Alt4.NAOK) == 0 OR (count(that.ALTR3.sq_Alt4.NAOK) == 2) AND ALTR3_Alt4_IMP.NAOK > 0) AND (count(that.ALTR3.sq_Alt5.NAOK) == 0 OR (count(that.ALTR3.sq_Alt5.NAOK) == 2) AND ALTR3_Alt5_IMP.NAOK > 0) AND (count(that.ALTR3.sq_Alt6.NAOK) == 0 OR (count(that.ALTR3.sq_Alt6.NAOK) == 2) AND ALTR3_Alt6_IMP.NAOK > 0))]]></value>
   </row>
   <row>
    <qid><![CDATA[9726]]></qid>
    <attribute><![CDATA[em_validation_q_tip]]></attribute>
    <value><![CDATA[Fill in both fields in the row. the sum on the second column but be equal to value 4 at previous table.]]></value>
    <language><![CDATA[it]]></language>
   </row>
   <row>
    <qid><![CDATA[9726]]></qid>
    <attribute><![CDATA[statistics_showgraph]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
  </rows>
 </question_attributes>
 <surveys>
  <fields>
   <fieldname>sid</fieldname>
   <fieldname>gsid</fieldname>
   <fieldname>admin</fieldname>
   <fieldname>expires</fieldname>
   <fieldname>startdate</fieldname>
   <fieldname>adminemail</fieldname>
   <fieldname>anonymized</fieldname>
   <fieldname>faxto</fieldname>
   <fieldname>format</fieldname>
   <fieldname>savetimings</fieldname>
   <fieldname>template</fieldname>
   <fieldname>language</fieldname>
   <fieldname>additional_languages</fieldname>
   <fieldname>datestamp</fieldname>
   <fieldname>usecookie</fieldname>
   <fieldname>allowregister</fieldname>
   <fieldname>allowsave</fieldname>
   <fieldname>autonumber_start</fieldname>
   <fieldname>autoredirect</fieldname>
   <fieldname>allowprev</fieldname>
   <fieldname>printanswers</fieldname>
   <fieldname>ipaddr</fieldname>
   <fieldname>refurl</fieldname>
   <fieldname>showsurveypolicynotice</fieldname>
   <fieldname>publicstatistics</fieldname>
   <fieldname>publicgraphs</fieldname>
   <fieldname>listpublic</fieldname>
   <fieldname>htmlemail</fieldname>
   <fieldname>sendconfirmation</fieldname>
   <fieldname>tokenanswerspersistence</fieldname>
   <fieldname>assessments</fieldname>
   <fieldname>usecaptcha</fieldname>
   <fieldname>usetokens</fieldname>
   <fieldname>bounce_email</fieldname>
   <fieldname>attributedescriptions</fieldname>
   <fieldname>emailresponseto</fieldname>
   <fieldname>emailnotificationto</fieldname>
   <fieldname>tokenlength</fieldname>
   <fieldname>showxquestions</fieldname>
   <fieldname>showgroupinfo</fieldname>
   <fieldname>shownoanswer</fieldname>
   <fieldname>showqnumcode</fieldname>
   <fieldname>bouncetime</fieldname>
   <fieldname>bounceprocessing</fieldname>
   <fieldname>bounceaccounttype</fieldname>
   <fieldname>bounceaccounthost</fieldname>
   <fieldname>bounceaccountpass</fieldname>
   <fieldname>bounceaccountencryption</fieldname>
   <fieldname>bounceaccountuser</fieldname>
   <fieldname>showwelcome</fieldname>
   <fieldname>showprogress</fieldname>
   <fieldname>questionindex</fieldname>
   <fieldname>navigationdelay</fieldname>
   <fieldname>nokeyboard</fieldname>
   <fieldname>alloweditaftercompletion</fieldname>
   <fieldname>googleanalyticsstyle</fieldname>
   <fieldname>googleanalyticsapikey</fieldname>
  </fields>
  <rows>
   <row>
    <sid><![CDATA[874329]]></sid>
    <gsid><![CDATA[1]]></gsid>
    <admin><![CDATA[LS Adm]]></admin>
    <adminemail><![CDATA[lsformazione@net-addiction.net]]></adminemail>
    <anonymized><![CDATA[N]]></anonymized>
    <faxto/>
    <format><![CDATA[G]]></format>
    <savetimings><![CDATA[N]]></savetimings>
    <template><![CDATA[vanilla]]></template>
    <language><![CDATA[it]]></language>
    <additional_languages/>
    <datestamp><![CDATA[N]]></datestamp>
    <usecookie><![CDATA[N]]></usecookie>
    <allowregister><![CDATA[N]]></allowregister>
    <allowsave><![CDATA[Y]]></allowsave>
    <autonumber_start><![CDATA[6]]></autonumber_start>
    <autoredirect><![CDATA[N]]></autoredirect>
    <allowprev><![CDATA[Y]]></allowprev>
    <printanswers><![CDATA[N]]></printanswers>
    <ipaddr><![CDATA[N]]></ipaddr>
    <refurl><![CDATA[N]]></refurl>
    <showsurveypolicynotice><![CDATA[0]]></showsurveypolicynotice>
    <publicstatistics><![CDATA[N]]></publicstatistics>
    <publicgraphs><![CDATA[N]]></publicgraphs>
    <listpublic><![CDATA[N]]></listpublic>
    <htmlemail><![CDATA[Y]]></htmlemail>
    <sendconfirmation><![CDATA[Y]]></sendconfirmation>
    <tokenanswerspersistence><![CDATA[Y]]></tokenanswerspersistence>
    <assessments><![CDATA[N]]></assessments>
    <usecaptcha><![CDATA[N]]></usecaptcha>
    <usetokens><![CDATA[N]]></usetokens>
    <bounce_email><![CDATA[lsformazione@net-addiction.net]]></bounce_email>
    <attributedescriptions><![CDATA[[]]]></attributedescriptions>
    <emailresponseto/>
    <emailnotificationto/>
    <tokenlength><![CDATA[15]]></tokenlength>
    <showxquestions><![CDATA[Y]]></showxquestions>
    <showgroupinfo><![CDATA[B]]></showgroupinfo>
    <shownoanswer><![CDATA[N]]></shownoanswer>
    <showqnumcode><![CDATA[X]]></showqnumcode>
    <bounceprocessing><![CDATA[N]]></bounceprocessing>
    <showwelcome><![CDATA[Y]]></showwelcome>
    <showprogress><![CDATA[Y]]></showprogress>
    <questionindex><![CDATA[0]]></questionindex>
    <navigationdelay><![CDATA[0]]></navigationdelay>
    <nokeyboard><![CDATA[N]]></nokeyboard>
    <alloweditaftercompletion><![CDATA[Y]]></alloweditaftercompletion>
    <googleanalyticsstyle/>
    <googleanalyticsapikey/>
   </row>
  </rows>
 </surveys>
 <surveys_languagesettings>
  <fields>
   <fieldname>surveyls_survey_id</fieldname>
   <fieldname>surveyls_language</fieldname>
   <fieldname>surveyls_title</fieldname>
   <fieldname>surveyls_description</fieldname>
   <fieldname>surveyls_welcometext</fieldname>
   <fieldname>surveyls_endtext</fieldname>
   <fieldname>surveyls_policy_notice</fieldname>
   <fieldname>surveyls_policy_error</fieldname>
   <fieldname>surveyls_policy_notice_label</fieldname>
   <fieldname>surveyls_url</fieldname>
   <fieldname>surveyls_urldescription</fieldname>
   <fieldname>surveyls_email_invite_subj</fieldname>
   <fieldname>surveyls_email_invite</fieldname>
   <fieldname>surveyls_email_remind_subj</fieldname>
   <fieldname>surveyls_email_remind</fieldname>
   <fieldname>surveyls_email_register_subj</fieldname>
   <fieldname>surveyls_email_register</fieldname>
   <fieldname>surveyls_email_confirm_subj</fieldname>
   <fieldname>surveyls_email_confirm</fieldname>
   <fieldname>surveyls_dateformat</fieldname>
   <fieldname>surveyls_attributecaptions</fieldname>
   <fieldname>email_admin_notification_subj</fieldname>
   <fieldname>email_admin_notification</fieldname>
   <fieldname>email_admin_responses_subj</fieldname>
   <fieldname>email_admin_responses</fieldname>
   <fieldname>surveyls_numberformat</fieldname>
   <fieldname>attachments</fieldname>
  </fields>
  <rows>
   <row>
    <surveyls_survey_id><![CDATA[874329]]></surveyls_survey_id>
    <surveyls_language><![CDATA[it]]></surveyls_language>
    <surveyls_title><![CDATA[test]]></surveyls_title>
    <surveyls_description><![CDATA[test]]></surveyls_description>
    <surveyls_welcometext/>
    <surveyls_endtext/>
    <surveyls_url/>
    <surveyls_urldescription/>
    <surveyls_email_invite_subj><![CDATA[Invito per partecipare all'indagine]]></surveyls_email_invite_subj>
    <surveyls_email_invite><![CDATA[Egregio/a {FIRSTNAME},<br />
<br />
è invitato a partecipare ad un'indagine on line.<br />
<br />
L'indagine è intitolata:<br />
"{SURVEYNAME}"<br />
<br />
"{SURVEYDESCRIPTION}"<br />
<br />
Per partecipare fare click sul link in basso.<br />
<br />
Cordiali saluti,{ADMINNAME} ({ADMINEMAIL})<br />
<br />
----------------------------------------------<br />
Fare click qui per accedere al questionario e rispondere alle domande relative:<br />
{SURVEYURL}<br />
<br />
Se non si intende partecipare a questa indagine e non si vogliono ricevere altri inviti, si può cliccare sul seguente collegamento:<br />
{OPTOUTURL}<br />
<br />
Se è presente in blacklist ma vuole partecipare a questa indagine e ricevere inviti, vada al seguente link:<br />
{OPTINURL}]]></surveyls_email_invite>
    <surveyls_email_remind_subj><![CDATA[Promemoria per partecipare all'indagine]]></surveyls_email_remind_subj>
    <surveyls_email_remind><![CDATA[Egregio/a {FIRSTNAME},<br />
Recentemente ha ricevuto un invito a partecipare ad un'indagine on line.<br />
<br />
Abbiamo notato che non ha ancora completato il questionario. Con l'occasione Le ricordiamo che il questionario è ancora disponibile.<br />
<br />
L'indagine è intitolata:<br />
"{SURVEYNAME}"<br />
<br />
"{SURVEYDESCRIPTION}"<br />
<br />
Per partecipare fare clic sul link qui sotto.<br />
<br />
Cordiali saluti,<br />
<br />
{ADMINNAME} ({ADMINEMAIL})<br />
<br />
----------------------------------------------<br />
Fare clic qui per accedere all'indagine e rispondere al questionario:<br />
{SURVEYURL}<br />
<br />
Se non si intende partecipare a questa indagine e non si vogliono ricevere altri inviti, si può cliccare sul seguente collegamento:<br />
{OPTOUTURL}]]></surveyls_email_remind>
    <surveyls_email_register_subj><![CDATA[Conferma di registrazione all'indagine]]></surveyls_email_register_subj>
    <surveyls_email_register><![CDATA[Egregio/a {FIRSTNAME},<br />
<br />
Lei (o qualcuno che ha utilizzato il suo indirizzo e-mail) si è registrato per partecipare all'indagine on line intitolata {SURVEYNAME}.<br />
<br />
Per completare il questionario fare clic sul seguente indirizzo:<br />
<br />
{SURVEYURL}<br />
<br />
Se ha qualche domanda, o se non si è registrato e ritiene che questa e-mail ti sia pervenuta per errore, la preghiamo di contattare  {ADMINNAME} all'indirizzo {ADMINEMAIL}.]]></surveyls_email_register>
    <surveyls_email_confirm_subj><![CDATA[Confermare la partecipazione all&#039;indagine]]></surveyls_email_confirm_subj>
    <surveyls_email_confirm><![CDATA[Egregio/a {FIRSTNAME},<br />
<br />
Questa e-mail le è stata inviata per confermarle che ha completato correttamente il questionario intitolato {SURVEYNAME}  e che le sue risposte sono state salvate. Grazie per la partecipazione.<br />
<br />
Se ha ulteriori domande circa questo messaggio, la prego di contattare {ADMINNAME} all'indirizzo e-mail {ADMINEMAIL}.<br />
<br />
Cordiali saluti<br />
<br />
{ADMINNAME}]]></surveyls_email_confirm>
    <surveyls_dateformat><![CDATA[5]]></surveyls_dateformat>
    <email_admin_notification_subj><![CDATA[Invio di una risposta all'indagine {SURVEYNAME}]]></email_admin_notification_subj>
    <email_admin_notification><![CDATA[Salve,<br />
<br />
Una nuova risposta é stata inviata per l'indagine '{SURVEYNAME}'.<br />
<br />
Fare click sul link seguente per vedere le risposte individuali:<br />
{VIEWRESPONSEURL}<br />
<br />
Fare click sul link seguente per modificare le risposte individuali:<br />
{EDITRESPONSEURL}<br />
<br />
Fare clic sul link seguente per visualizzare le statistiche:<br />
{STATISTICSURL}]]></email_admin_notification>
    <email_admin_responses_subj><![CDATA[Invio di una risposta all'indagine {SURVEYNAME} con risultati]]></email_admin_responses_subj>
    <email_admin_responses><![CDATA[Salve,<br />
<br />
Una nuova risposta è stata inviata dall'indagine '{SURVEYNAME}'.<br />
<br />
Fare clic sul link seguente per vedere la risposta individuale:<br />
{VIEWRESPONSEURL}<br />
<br />
Fare clic sul link seguente per modificare la risposta individuale:<br />
{EDITRESPONSEURL}<br />
<br />
Fare clic sul link seguente per visualizzare le statistiche:<br />
{STATISTICSURL}<br />
<br />
<br />
Le seguenti risposte sono state date dal partecipante:<br />
{ANSWERTABLE}]]></email_admin_responses>
    <surveyls_numberformat><![CDATA[0]]></surveyls_numberformat>
   </row>
  </rows>
 </surveys_languagesettings>
 <themes>
  <theme>
   <sid>874329</sid>
   <template_name>bootswatch</template_name>
   <config>
    <options>inherit</options>
   </config>
  </theme>
  <theme>
   <sid>874329</sid>
   <template_name>CDC-Basic-AutoNumeric</template_name>
   <config>
    <options>inherit</options>
   </config>
  </theme>
  <theme>
   <sid>874329</sid>
   <template_name>fruity</template_name>
   <config>
    <options>inherit</options>
   </config>
  </theme>
  <theme>
   <sid>874329</sid>
   <template_name>vanilla</template_name>
   <config>
    <options>inherit</options>
   </config>
  </theme>
 </themes>
 <themes_inherited>
  <theme>
   <sid>874329</sid>
   <template_name>bootswatch</template_name>
   <config>
    <options>
     <ajaxmode>off</ajaxmode>
     <brandlogo>on</brandlogo>
     <container>on</container>
     <brandlogofile>./files/logo.png</brandlogofile>
    </options>
   </config>
  </theme>
  <theme>
   <sid>874329</sid>
   <template_name>CDC-Basic-AutoNumeric</template_name>
   <config>
    <options>
     <animatebody>off</animatebody>
     <hideprivacyinfo>off</hideprivacyinfo>
     <container>on</container>
     <bodyanimation>fadeInRight</bodyanimation>
     <brandlogo>on</brandlogo>
     <brandlogofile>./files/logo.png</brandlogofile>
     <font>titillium</font>
     <showpopups>1</showpopups>
     <fixnumauto>off</fixnumauto>
    </options>
   </config>
  </theme>
  <theme>
   <sid>874329</sid>
   <template_name>fruity</template_name>
   <config>
    <options>
     <ajaxmode>off</ajaxmode>
     <brandlogo>on</brandlogo>
     <brandlogofile>./files/logo.png</brandlogofile>
     <container>on</container>
     <backgroundimage>off</backgroundimage>
     <animatebody>off</animatebody>
     <bodyanimation>fadeInRight</bodyanimation>
     <bodyanimationduration>500</bodyanimationduration>
     <animatequestion>off</animatequestion>
     <questionanimation>flipInX</questionanimation>
     <questionanimationduration>500</questionanimationduration>
     <animatealert>off</animatealert>
     <alertanimation>shake</alertanimation>
     <alertanimationduration>500</alertanimationduration>
     <font>noto</font>
     <bodybackgroundcolor>#ffffff</bodybackgroundcolor>
     <fontcolor>#444444</fontcolor>
     <questionbackgroundcolor>#ffffff</questionbackgroundcolor>
     <questionborder>on</questionborder>
     <questioncontainershadow>on</questioncontainershadow>
     <checkicon>f00c</checkicon>
     <animatecheckbox>on</animatecheckbox>
     <checkboxanimation>rubberBand</checkboxanimation>
     <checkboxanimationduration>500</checkboxanimationduration>
     <animateradio>on</animateradio>
     <radioanimation>zoomIn</radioanimation>
     <radioanimationduration>500</radioanimationduration>
     <zebrastriping>off</zebrastriping>
     <stickymatrixheaders>off</stickymatrixheaders>
     <greyoutselected>off</greyoutselected>
     <hideprivacyinfo>off</hideprivacyinfo>
     <crosshover>off</crosshover>
     <showpopups>1</showpopups>
    </options>
   </config>
  </theme>
  <theme>
   <sid>874329</sid>
   <template_name>vanilla</template_name>
   <config>
    <options>
     <ajaxmode>off</ajaxmode>
     <brandlogo>on</brandlogo>
     <container>on</container>
     <hideprivacyinfo>off</hideprivacyinfo>
     <brandlogofile>./files/logo.png</brandlogofile>
     <font>noto</font>
    </options>
   </config>
  </theme>
 </themes_inherited>
</document>
limesurvey_survey_874329.lss (29,539 bytes)   
Bug heat8
Complete LimeSurvey version number (& build)both 3.27.17+210911 and 3.28.21+220726
I will donate to the project if issue is resolvedNo
BrowserTried firefox and chrome at latest versions
Database type & versionMySQL
Server OS (if known)
Webserver software & version (if known)
PHP Version7.3

Users monitoring this issue

Mazi

Activities

mfiora

mfiora

2022-07-27 14:52

reporter   ~71179

validation.png (32,326 bytes)   
validation.png (32,326 bytes)   
DenisChenu

DenisChenu

2022-07-27 15:13

developer   ~71180

Issue in survey ?

Before we have an alert when there are such issue (3.X and before) and survey can not be launched.
Now : no (it's an issue)

Capture d’écran du 2022-07-27 15-12-04.png (18,788 bytes)   
Capture d’écran du 2022-07-27 15-12-04.png (18,788 bytes)   
DenisChenu

DenisChenu

2022-07-27 15:15

developer   ~71181

Check integrity and test again
mfiora

mfiora

2022-07-27 15:25

reporter   ~71184

Hello Denis,
i checked the Survey logic file and "No syntax errors detected in this survey."

I checked integrity and tested again on both installations and the problem persists.

Thanks,

Regards,
DenisChenu

DenisChenu

2022-07-27 15:33

developer   ~71185

Strange … import on 5.X : have the issue.
integrity fix it …

But still have your issue
Can you separate each test ?
Start by sum(…) == SEZ62QC50_AltriFondi_Importo.NAOK
etc …
DenisChenu

DenisChenu

2022-07-27 15:33

developer   ~71186

Capture d’écran du 2022-07-27 15-31-29.png (26,949 bytes)   
Capture d’écran du 2022-07-27 15-31-29.png (26,949 bytes)   
mfiora

mfiora

2022-07-27 15:43

reporter   ~71187

Hello Denis,
so, setting as a Validation Equation:

sum(that.ALTR3.sq_IMP.NAOK) == SEZ62QC50_AltriFondi_Importo.NAOK

still triggers the error but in the question text checked values:

sum(that.ALTR3.sq_IMP.NAOK): 101051.99 true
SEZ62QC50_AltriFondi_Importo.NAOK: 101051.99 1

"true" and "1" are is_numeric() output on the value on the same line.
Thanks,
mfiora

mfiora

2022-07-27 16:11

reporter   ~71188

And still this works (see image). So, is there a workaround for this or should i wait for the bug to be solved?
Thanks,

validation2.png (13,561 bytes)   
validation2.png (13,561 bytes)   
gabrieljenik

gabrieljenik

2022-07-28 19:06

manager   ~71233

Last edited: 2022-07-28 19:10

Maybe trying on master could provide more info.
gabrieljenik

gabrieljenik

2022-07-28 19:10

manager   ~71234

Last edited: 2022-07-28 19:11

sum(that.ALTR3.sq_IMP.NAOK) == SEZ62QC50_AltriFondi_Importo.NAOK

Please, try 

abs(sum(that.ALTR3.sq_IMP.NAOK) - SEZ62QC50_AltriFondi_Importo.NAOK) < 0.01

Maybe a rounding issue / datat type... ?
mfiora

mfiora

2022-07-28 19:19

reporter   ~71236

Hello gabrieljenik,
thanks, the workaround you provided seems working.
But will this be fixed at some point?

Thank you very much for your support.
gabrieljenik

gabrieljenik

2022-07-28 19:59

manager   ~71237

This is a typical situation that happens when comparing decimals. Not a bug.
Maybe you can file a feature request for a function num_compare :)

Issue History

Date Modified Username Field Change
2022-07-27 14:52 mfiora New Issue
2022-07-27 14:52 mfiora File Added: limesurvey_survey_874329.lss
2022-07-27 14:52 mfiora Note Added: 71179
2022-07-27 14:52 mfiora File Added: validation.png
2022-07-27 14:52 mfiora Bug heat 0 => 2
2022-07-27 15:13 DenisChenu Note Added: 71180
2022-07-27 15:13 DenisChenu File Added: Capture d’écran du 2022-07-27 15-12-04.png
2022-07-27 15:13 DenisChenu Bug heat 2 => 4
2022-07-27 15:15 DenisChenu Note Added: 71181
2022-07-27 15:25 mfiora Note Added: 71184
2022-07-27 15:33 DenisChenu Note Added: 71185
2022-07-27 15:33 DenisChenu Note Added: 71186
2022-07-27 15:33 DenisChenu File Added: Capture d’écran du 2022-07-27 15-31-29.png
2022-07-27 15:35 gabrieljenik Status new => feedback
2022-07-27 15:43 mfiora Note Added: 71187
2022-07-27 15:43 mfiora Status feedback => new
2022-07-27 16:11 mfiora Note Added: 71188
2022-07-27 16:11 mfiora File Added: validation2.png
2022-07-28 01:06 Mazi Issue Monitored: Mazi
2022-07-28 01:06 Mazi Bug heat 4 => 6
2022-07-28 19:06 gabrieljenik Note Added: 71233
2022-07-28 19:06 gabrieljenik Bug heat 6 => 8
2022-07-28 19:06 gabrieljenik Note Edited: 71233
2022-07-28 19:08 gabrieljenik Status new => acknowledged
2022-07-28 19:10 gabrieljenik Note Added: 71234
2022-07-28 19:10 gabrieljenik Note Edited: 71233
2022-07-28 19:11 gabrieljenik Note Edited: 71234
2022-07-28 19:19 mfiora Note Added: 71236
2022-07-28 19:59 gabrieljenik Note Added: 71237
2022-07-28 20:00 gabrieljenik Assigned To => gabrieljenik
2022-07-28 20:00 gabrieljenik Status acknowledged => closed
2022-07-28 20:00 gabrieljenik Resolution open => no change required