17829: findAll return only one record - LimeSurvey bugs and feature requests

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

17829	Bug reports	Other	public	2022-01-10 16:52	2024-06-26 10:22

Reporter	DenisChenu	Assigned To
Priority	none	Severity	minor
Status	new	Resolution	open
Product Version	5.2.x

Summary	17829: findAll return only one record
Description	using findAll with QuestionAttribute model return only one record.
Steps To Reproduce	Steps to reproduce Activate debug mode Import included plugin (pdfReport) Import included survey Activate Launch : check the tracevar to 1 Only one pdf generated Do the same with 3.X (last one) tracevar show 2 and 2 pdf are generated Expected result tracevar show 2 and 2 pdf are generated Actual result tracevar show 1 and 1 pdf are generated
Tags	No tags attached.
Attached Files	pdfReport.zip (486,946 bytes) limesurvey_survey_476956.lss (42,089 bytes) <?xml version="1.0" encoding="UTF-8"?> <document> <LimeSurveyDocType>Survey</LimeSurveyDocType> <DBVersion>365</DBVersion> <languages> <language>en</language> </languages> <answers> <fields> <fieldname>qid</fieldname> <fieldname>code</fieldname> <fieldname>answer</fieldname> <fieldname>sortorder</fieldname> <fieldname>assessment_value</fieldname> <fieldname>language</fieldname> <fieldname>scale_id</fieldname> </fields> <rows> <row> <qid><![CDATA[6045]]></qid> <code><![CDATA[ARCH]]></code> <answer><![CDATA[<img src="{SURVEYRESOURCESURL}files/archlinux-logo.png" alt="ArcLinux" />]]></answer> <sortorder><![CDATA[5]]></sortorder> <assessment_value><![CDATA[0]]></assessment_value> <language><![CDATA[en]]></language> <scale_id><![CDATA[0]]></scale_id> </row> <row> <qid><![CDATA[6045]]></qid> <code><![CDATA[DEB]]></code> <answer><![CDATA[<img src="{SURVEYRESOURCESURL}files/debian-logo.png" alt="Debian" />]]></answer> <sortorder><![CDATA[1]]></sortorder> <assessment_value><![CDATA[0]]></assessment_value> <language><![CDATA[en]]></language> <scale_id><![CDATA[0]]></scale_id> </row> <row> <qid><![CDATA[6045]]></qid> <code><![CDATA[FEDO]]></code> <answer><![CDATA[<img src="{SURVEYRESOURCESURL}files/fedora-logo.png" alt="Fedora" />]]></answer> <sortorder><![CDATA[2]]></sortorder> <assessment_value><![CDATA[0]]></assessment_value> <language><![CDATA[en]]></language> <scale_id><![CDATA[0]]></scale_id> </row> <row> <qid><![CDATA[6045]]></qid> <code><![CDATA[SLACK]]></code> <answer><![CDATA[<img src="{SURVEYRESOURCESURL}files/slackware-logo.png" alt="Slack" />]]></answer> <sortorder><![CDATA[3]]></sortorder> <assessment_value><![CDATA[0]]></assessment_value> <language><![CDATA[en]]></language> <scale_id><![CDATA[0]]></scale_id> </row> <row> <qid><![CDATA[6045]]></qid> <code><![CDATA[SUSE]]></code> <answer><![CDATA[<img src="{SURVEYRESOURCESURL}files/suse-logo.png" alt="Suse" />]]></answer> <sortorder><![CDATA[4]]></sortorder> <assessment_value><![CDATA[0]]></assessment_value> <language><![CDATA[en]]></language> <scale_id><![CDATA[0]]></scale_id> </row> </rows> </answers> <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[388]]></gid> <sid><![CDATA[476956]]></sid> <group_name><![CDATA[Prefilling]]></group_name> <group_order><![CDATA[1]]></group_order> <description/> <language><![CDATA[en]]></language> <randomization_group/> <grelevance/> </row> <row> <gid><![CDATA[389]]></gid> <sid><![CDATA[476956]]></sid> <group_name><![CDATA[The Linux distributions logos]]></group_name> <group_order><![CDATA[2]]></group_order> <description/> <language><![CDATA[en]]></language> <randomization_group/> <grelevance/> </row> <row> <gid><![CDATA[390]]></gid> <sid><![CDATA[476956]]></sid> <group_name><![CDATA[Report]]></group_name> <group_order><![CDATA[4]]></group_order> <description/> <language><![CDATA[en]]></language> <randomization_group/> <grelevance/> </row> <row> <gid><![CDATA[391]]></gid> <sid><![CDATA[476956]]></sid> <group_name><![CDATA[Hicdden Report]]></group_name> <group_order><![CDATA[3]]></group_order> <description/> <language><![CDATA[en]]></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[6043]]></qid> <parent_qid><![CDATA[0]]></parent_qid> <sid><![CDATA[476956]]></sid> <gid><![CDATA[388]]></gid> <type><![CDATA[Q]]></type> <title><![CDATA[USER]]></title> <question><![CDATA[Tell me who you are. If you put a valid email : you receive a PDF with the report.]]></question> <preg/> <help><![CDATA[{if(is_empty(USER_EMAIL.NAOK),"<div class='error'>If you leave email empty, you don't get the report.</div>","")} {if(!is_empty(USER_EMAIL.NAOK) && !regexMatch("/^(\w[-._+\w]\w@\w[-._\w]\w\.\w{2,})?$/",USER_EMAIL.NAOK),"<div class='warning'>Are you sure your email is valid ?</div>","")} {if(!is_empty(USER_EMAIL.NAOK) && regexMatch("/^(\w[-._+\w]\w@\w[-._\w]\w\.\w{2,})?$/",USER_EMAIL.NAOK),"<div class='good'>Your email seems valid, we send the PDF report.</div>","")} <div class="alert alert-warning">Email is deactivated on this instance</div>]]></help> <other><![CDATA[N]]></other> <mandatory><![CDATA[N]]></mandatory> <question_order><![CDATA[0]]></question_order> <language><![CDATA[en]]></language> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> <modulename/> </row> <row> <qid><![CDATA[6044]]></qid> <parent_qid><![CDATA[0]]></parent_qid> <sid><![CDATA[476956]]></sid> <gid><![CDATA[389]]></gid> <type><![CDATA[M]]></type> <title><![CDATA[KnowUse]]></title> <question><![CDATA[Did you use or know this ditributions]]></question> <preg/> <help/> <other><![CDATA[N]]></other> <mandatory><![CDATA[N]]></mandatory> <question_order><![CDATA[0]]></question_order> <language><![CDATA[en]]></language> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> </row> <row> <qid><![CDATA[6045]]></qid> <parent_qid><![CDATA[0]]></parent_qid> <sid><![CDATA[476956]]></sid> <gid><![CDATA[389]]></gid> <type><![CDATA[R]]></type> <title><![CDATA[Best]]></title> <question><![CDATA[What distribution you using most]]></question> <preg/> <help/> <other><![CDATA[N]]></other> <mandatory><![CDATA[N]]></mandatory> <question_order><![CDATA[1]]></question_order> <language><![CDATA[en]]></language> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[count(that.KnowUse.NAOK) > 1]]></relevance> </row> <row> <qid><![CDATA[6046]]></qid> <parent_qid><![CDATA[0]]></parent_qid> <sid><![CDATA[476956]]></sid> <gid><![CDATA[390]]></gid> <type><![CDATA[X]]></type> <title><![CDATA[Information]]></title> <question><![CDATA[Here : we construct the report. This question can be hidden, you can use html, expression manager. The report file use the question text.]]></question> <preg/> <help/> <other><![CDATA[N]]></other> <mandatory><![CDATA[N]]></mandatory> <question_order><![CDATA[0]]></question_order> <language><![CDATA[en]]></language> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> </row> <row> <qid><![CDATA[6047]]></qid> <parent_qid><![CDATA[0]]></parent_qid> <sid><![CDATA[476956]]></sid> <gid><![CDATA[390]]></gid> <type><![CDATA[\|]]></type> <title><![CDATA[Report]]></title> <question><![CDATA[<h1> Here is your report</h1> <p> Hi {USER_NAME.NAOK},</p> <p> You know {count(that.KnowUse.NAOK)} linux distribution on the list.</p> {if(is_empty(Best_1.NAOK),"<p> You don't rank any of this distribution</p>","<p>The distribution you use the most are "+Best_1.shown+"</p>")} <h2 style="text-align:center"> Some style usage</h2> <p style="text-align: right;"> Text align : right</p> <ol> <li style="text-align: right;"> A ordered list</li> <li style="text-align: right;"> With 3 elements</li> <li style="text-align: right;"> The 3rd element</li> </ol> <p> Some link : <a href="http://extensions.sondages.pro/about/contact.html">Get support for this plugin</a><br /> or <a href="https://framagit.org/SondagePro-LimeSurvey-plugin/pdfReport">fork it</a>, use it, adapt it, distribute it; because <strong><a href="https://www.gnu.org/licenses/agpl.html"><span style="color:#B22222;">you are free to do it</span></a></strong>.</p> <p> Long line can have issue , best is to use <br> or to use only short line :</p> <p> Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec dui nunc, faucibus ac neque in, gravida sollicitudin nunc. Phasellus venenatis nunc et eros pretium sodales quis sit amet enim. Morbi in dapibus elit. Quisque sit amet ornare quam, sed aliquet lectus. Quisque finibus facilisis erat, sit amet sagittis lorem. Aliquam erat volutpat. Cras pretium ultrices risus, suscipit vestibulum odio vehicula semper.</p> <br pagebreak="true" /> <h1> A new page is here</h1> <h2> image width is set in cm</h2> <p> <img alt="gnu and penguin" src="/3LTS/upload/surveys/476956/images/gnu-and-penguin-color-1024x946.jpg" style="width: 18cm; height: auto;"/></p> <p> <em>Better to use internal files than external dur to downloading files</em></p> <h2> A broken image</h2> <p> <img alt="broken image " src="invalid.png" style="width: 18cm; height: auto;" /></p> <p> After the image</p> ]]></question> <preg/> <help/> <other><![CDATA[N]]></other> <mandatory><![CDATA[N]]></mandatory> <question_order><![CDATA[1]]></question_order> <language><![CDATA[en]]></language> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> <modulename/> </row> <row> <qid><![CDATA[6055]]></qid> <parent_qid><![CDATA[0]]></parent_qid> <sid><![CDATA[476956]]></sid> <gid><![CDATA[391]]></gid> <type><![CDATA[\|]]></type> <title><![CDATA[HiddenReport]]></title> <question><![CDATA[<h1> Hidden report</h1> <p> Hi {USER_NAME.NAOK},</p> <p>]]></question> <preg/> <help/> <other><![CDATA[N]]></other> <mandatory><![CDATA[N]]></mandatory> <question_order><![CDATA[0]]></question_order> <language><![CDATA[en]]></language> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> </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[6048]]></qid> <parent_qid><![CDATA[6043]]></parent_qid> <sid><![CDATA[476956]]></sid> <gid><![CDATA[388]]></gid> <type><![CDATA[Q]]></type> <title><![CDATA[NAME]]></title> <question><![CDATA[Your name]]></question> <other><![CDATA[N]]></other> <mandatory><![CDATA[N]]></mandatory> <question_order><![CDATA[1]]></question_order> <language><![CDATA[en]]></language> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> <modulename/> </row> <row> <qid><![CDATA[6049]]></qid> <parent_qid><![CDATA[6043]]></parent_qid> <sid><![CDATA[476956]]></sid> <gid><![CDATA[388]]></gid> <type><![CDATA[Q]]></type> <title><![CDATA[EMAIL]]></title> <question><![CDATA[Your email]]></question> <other><![CDATA[N]]></other> <mandatory><![CDATA[N]]></mandatory> <question_order><![CDATA[2]]></question_order> <language><![CDATA[en]]></language> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance/> <modulename/> </row> <row> <qid><![CDATA[6050]]></qid> <parent_qid><![CDATA[6044]]></parent_qid> <sid><![CDATA[476956]]></sid> <gid><![CDATA[389]]></gid> <type><![CDATA[M]]></type> <title><![CDATA[DEB]]></title> <question><![CDATA[<img src="{SURVEYRESOURCESURL}files/debian-logo.png" alt="Debian" />]]></question> <help/> <other><![CDATA[N]]></other> <mandatory><![CDATA[N]]></mandatory> <question_order><![CDATA[1]]></question_order> <language><![CDATA[en]]></language> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> </row> <row> <qid><![CDATA[6051]]></qid> <parent_qid><![CDATA[6044]]></parent_qid> <sid><![CDATA[476956]]></sid> <gid><![CDATA[389]]></gid> <type><![CDATA[M]]></type> <title><![CDATA[FEDO]]></title> <question><![CDATA[<img src="{SURVEYRESOURCESURL}files/fedora-logo.png" alt="Fedora" />]]></question> <help/> <other><![CDATA[N]]></other> <mandatory><![CDATA[N]]></mandatory> <question_order><![CDATA[2]]></question_order> <language><![CDATA[en]]></language> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> </row> <row> <qid><![CDATA[6052]]></qid> <parent_qid><![CDATA[6044]]></parent_qid> <sid><![CDATA[476956]]></sid> <gid><![CDATA[389]]></gid> <type><![CDATA[M]]></type> <title><![CDATA[SLACK]]></title> <question><![CDATA[<img src="{SURVEYRESOURCESURL}files/slackware-logo.png" alt="Slack" />]]></question> <help/> <other><![CDATA[N]]></other> <mandatory><![CDATA[N]]></mandatory> <question_order><![CDATA[3]]></question_order> <language><![CDATA[en]]></language> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> </row> <row> <qid><![CDATA[6053]]></qid> <parent_qid><![CDATA[6044]]></parent_qid> <sid><![CDATA[476956]]></sid> <gid><![CDATA[389]]></gid> <type><![CDATA[M]]></type> <title><![CDATA[SUSE]]></title> <question><![CDATA[<img src="{SURVEYRESOURCESURL}files/suse-logo.png" alt="Suse" />]]></question> <help/> <other><![CDATA[N]]></other> <mandatory><![CDATA[N]]></mandatory> <question_order><![CDATA[4]]></question_order> <language><![CDATA[en]]></language> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> </row> <row> <qid><![CDATA[6054]]></qid> <parent_qid><![CDATA[6044]]></parent_qid> <sid><![CDATA[476956]]></sid> <gid><![CDATA[389]]></gid> <type><![CDATA[M]]></type> <title><![CDATA[ARCH]]></title> <question><![CDATA[<img src="{SURVEYRESOURCESURL}files/archlinux-logo.png" alt="ArcLinux" />]]></question> <help/> <other><![CDATA[N]]></other> <mandatory><![CDATA[N]]></mandatory> <question_order><![CDATA[5]]></question_order> <language><![CDATA[en]]></language> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> </row> </rows> </subquestions> <question_attributes> <fields> <fieldname>qid</fieldname> <fieldname>attribute</fieldname> <fieldname>value</fieldname> <fieldname>language</fieldname> </fields> <rows> <row> <qid><![CDATA[6044]]></qid> <attribute><![CDATA[random_order]]></attribute> <value><![CDATA[1]]></value> </row> <row> <qid><![CDATA[6045]]></qid> <attribute><![CDATA[array_filter]]></attribute> <value><![CDATA[KnowUse]]></value> </row> <row> <qid><![CDATA[6045]]></qid> <attribute><![CDATA[max_subquestions]]></attribute> <value><![CDATA[5]]></value> </row> <row> <qid><![CDATA[6047]]></qid> <attribute><![CDATA[pdfReport]]></attribute> <value><![CDATA[1]]></value> </row> <row> <qid><![CDATA[6047]]></qid> <attribute><![CDATA[pdfReportPdfGenerator]]></attribute> <value><![CDATA[0]]></value> </row> <row> <qid><![CDATA[6047]]></qid> <attribute><![CDATA[pdfReportPrintAnswer]]></attribute> <value><![CDATA[2]]></value> </row> <row> <qid><![CDATA[6047]]></qid> <attribute><![CDATA[pdfReportSavedFileName]]></attribute> <value><![CDATA[PDF-Report-Sample]]></value> <language><![CDATA[en]]></language> </row> <row> <qid><![CDATA[6047]]></qid> <attribute><![CDATA[pdfReportSendByEmailContent]]></attribute> <value><![CDATA[confirm]]></value> </row> <row> <qid><![CDATA[6047]]></qid> <attribute><![CDATA[pdfReportSendByEmailMail]]></attribute> <value><![CDATA[{USER_EMAIL}]]></value> </row> <row> <qid><![CDATA[6047]]></qid> <attribute><![CDATA[pdfReportSubTitle]]></attribute> <value><![CDATA[{SURVEYNAME}]]></value> <language><![CDATA[en]]></language> </row> <row> <qid><![CDATA[6047]]></qid> <attribute><![CDATA[pdfReportTitle]]></attribute> <value><![CDATA[{SITENAME}]]></value> <language><![CDATA[en]]></language> </row> <row> <qid><![CDATA[6055]]></qid> <attribute><![CDATA[pdfReport]]></attribute> <value><![CDATA[1]]></value> </row> <row> <qid><![CDATA[6055]]></qid> <attribute><![CDATA[pdfReportPdfGenerator]]></attribute> <value><![CDATA[0]]></value> </row> <row> <qid><![CDATA[6055]]></qid> <attribute><![CDATA[pdfReportPrintAnswer]]></attribute> <value><![CDATA[2]]></value> </row> <row> <qid><![CDATA[6055]]></qid> <attribute><![CDATA[pdfReportSavedFileName]]></attribute> <value><![CDATA[PDF-Report-Sample]]></value> <language><![CDATA[en]]></language> </row> <row> <qid><![CDATA[6055]]></qid> <attribute><![CDATA[pdfReportSendByEmailContent]]></attribute> <value><![CDATA[confirm]]></value> </row> <row> <qid><![CDATA[6055]]></qid> <attribute><![CDATA[pdfReportSendByEmailMail]]></attribute> <value><![CDATA[{USER_EMAIL}]]></value> </row> <row> <qid><![CDATA[6055]]></qid> <attribute><![CDATA[pdfReportSubTitle]]></attribute> <value><![CDATA[{SURVEYNAME}]]></value> <language><![CDATA[en]]></language> </row> <row> <qid><![CDATA[6055]]></qid> <attribute><![CDATA[pdfReportTitle]]></attribute> <value><![CDATA[{SITENAME}]]></value> <language><![CDATA[en]]></language> </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[476956]]></sid> <gsid><![CDATA[1]]></gsid> <admin><![CDATA[Denis Chenu]]></admin> <adminemail><![CDATA[denis@sondages.pro]]></adminemail> <anonymized><![CDATA[Y]]></anonymized> <faxto/> <format><![CDATA[G]]></format> <savetimings><![CDATA[N]]></savetimings> <template><![CDATA[skelvanilla]]></template> <language><![CDATA[en]]></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[Y]]></printanswers> <ipaddr><![CDATA[N]]></ipaddr> <refurl><![CDATA[N]]></refurl> <showsurveypolicynotice><![CDATA[0]]></showsurveypolicynotice> <publicstatistics><![CDATA[N]]></publicstatistics> <publicgraphs><![CDATA[N]]></publicgraphs> <listpublic><![CDATA[Y]]></listpublic> <htmlemail><![CDATA[Y]]></htmlemail> <sendconfirmation><![CDATA[Y]]></sendconfirmation> <tokenanswerspersistence><![CDATA[N]]></tokenanswerspersistence> <assessments><![CDATA[N]]></assessments> <usecaptcha><![CDATA[N]]></usecaptcha> <usetokens><![CDATA[N]]></usetokens> <bounce_email><![CDATA[denis@sondages.pro]]></bounce_email> <emailresponseto/> <emailnotificationto><![CDATA[{USER_EMAIL.NAOK}]]></emailnotificationto> <tokenlength><![CDATA[15]]></tokenlength> <showxquestions><![CDATA[Y]]></showxquestions> <showgroupinfo><![CDATA[B]]></showgroupinfo> <shownoanswer><![CDATA[Y]]></shownoanswer> <showqnumcode><![CDATA[X]]></showqnumcode> <bounceprocessing><![CDATA[N]]></bounceprocessing> <showwelcome><![CDATA[N]]></showwelcome> <showprogress><![CDATA[Y]]></showprogress> <questionindex><![CDATA[2]]></questionindex> <navigationdelay><![CDATA[0]]></navigationdelay> <nokeyboard><![CDATA[N]]></nokeyboard> <alloweditaftercompletion><![CDATA[N]]></alloweditaftercompletion> <googleanalyticsstyle><![CDATA[0]]></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[476956]]></surveyls_survey_id> <surveyls_language><![CDATA[en]]></surveyls_language> <surveyls_title><![CDATA[pdfReport test survey]]></surveyls_title> <surveyls_description><![CDATA[The pdfReport test survey]]></surveyls_description> <surveyls_welcometext/> <surveyls_endtext><![CDATA[<p> {if(is_empty(USER_EMAIL.NAOK),"You don't put any email, we can not send you the example pdf.","The server send you an email with the pdf, see you mailbox.")}</p> <p> You can download this survey : <a charset="utf8" href="/upload/surveys/{SID}/files/limesurvey_survey_sendPdReport.lss" lang="en" target="_blank" type="text/xml">limesurvey_survey_sendPdReport.lss</a> (without this link). But remind : the picture must be uploaded to your survey too.</p> ]]></surveyls_endtext> <surveyls_url/> <surveyls_urldescription/> <surveyls_email_invite_subj><![CDATA[Invitation to participate in a survey]]></surveyls_email_invite_subj> <surveyls_email_invite><![CDATA[Dear {FIRSTNAME},<br /> <br /> you have been invited to participate in a survey.<br /> <br /> The survey is titled:<br /> "{SURVEYNAME}"<br /> <br /> "{SURVEYDESCRIPTION}"<br /> <br /> To participate, please click on the link below.<br /> <br /> Sincerely,<br /> <br /> {ADMINNAME} ({ADMINEMAIL})<br /> <br /> ----------------------------------------------<br /> Click here to do the survey:<br /> {SURVEYURL}<br /> <br /> If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:<br /> {OPTOUTURL}<br /> <br /> If you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:<br /> {OPTINURL}]]></surveyls_email_invite> <surveyls_email_remind_subj><![CDATA[Reminder to participate in a survey]]></surveyls_email_remind_subj> <surveyls_email_remind><![CDATA[Dear {FIRSTNAME},<br /> <br /> Recently we invited you to participate in a survey.<br /> <br /> We note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.<br /> <br /> The survey is titled:<br /> "{SURVEYNAME}"<br /> <br /> "{SURVEYDESCRIPTION}"<br /> <br /> To participate, please click on the link below.<br /> <br /> Sincerely,<br /> <br /> {ADMINNAME} ({ADMINEMAIL})<br /> <br /> ----------------------------------------------<br /> Click here to do the survey:<br /> {SURVEYURL}<br /> <br /> If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:<br /> {OPTOUTURL}]]></surveyls_email_remind> <surveyls_email_register_subj><![CDATA[Survey registration confirmation]]></surveyls_email_register_subj> <surveyls_email_register><![CDATA[Dear {FIRSTNAME},<br /> <br /> You, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.<br /> <br /> To complete this survey, click on the following URL:<br /> <br /> {SURVEYURL}<br /> <br /> If you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.]]></surveyls_email_register> <surveyls_email_confirm_subj><![CDATA[Confirmation of your participation in our survey]]></surveyls_email_confirm_subj> <surveyls_email_confirm><![CDATA[Dear {USER_NAME.NAOK},<br /> <br /> this email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.<br /> <br /> Please find the your report as an attachment.<br /> <br /> {Report.question} <br/> Sincerely,<br /> <br /> {ADMINNAME}]]></surveyls_email_confirm> <surveyls_dateformat><![CDATA[9]]></surveyls_dateformat> <email_admin_notification_subj><![CDATA[Response submission for survey {SURVEYNAME}]]></email_admin_notification_subj> <email_admin_notification><![CDATA[Hello,<br /> <br /> A new response was submitted for your survey '{SURVEYNAME}'.<br /> <br /> {Report.question} <br /> View statistics by clicking here:<br /> {STATISTICSURL}]]></email_admin_notification> <email_admin_responses_subj><![CDATA[Response submission for survey {SURVEYNAME} with results]]></email_admin_responses_subj> <email_admin_responses><![CDATA[Hello,<br /> <br /> A new response was submitted for your survey '{SURVEYNAME}'.<br /> <br /> Click the following link to reload the survey:<br /> {RELOADURL}<br /> <br /> Click the following link to see the individual response:<br /> {VIEWRESPONSEURL}<br /> <br /> Click the following link to edit the individual response:<br /> {EDITRESPONSEURL}<br /> <br /> View statistics by clicking here:<br /> {STATISTICSURL}<br /> <br /> <br /> The following answers were given by the participant:<br /> {ANSWERTABLE}]]></email_admin_responses> <surveyls_numberformat><![CDATA[0]]></surveyls_numberformat> <attachments><![CDATA[a:0:{}]]></attachments> </row> </rows> </surveys_languagesettings> <plugin_settings> <fields> <fieldname>id</fieldname> <fieldname>name</fieldname> <fieldname>key</fieldname> <fieldname>value</fieldname> </fields> <rows> <row> <id><![CDATA[2443]]></id> <name><![CDATA[quickStatAdminParticipationAndStat]]></name> <key><![CDATA[questionCrossSatisfactionTable]]></key> <value><![CDATA[null]]></value> </row> <row> <id><![CDATA[2442]]></id> <name><![CDATA[quickStatAdminParticipationAndStat]]></name> <key><![CDATA[questionCrossSatisfaction]]></key> <value><![CDATA[null]]></value> </row> <row> <id><![CDATA[2441]]></id> <name><![CDATA[quickStatAdminParticipationAndStat]]></name> <key><![CDATA[tokenAttributesSatisfaction]]></key> <value><![CDATA[null]]></value> </row> <row> <id><![CDATA[2440]]></id> <name><![CDATA[quickStatAdminParticipationAndStat]]></name> <key><![CDATA[questionNumeric]]></key> <value><![CDATA[null]]></value> </row> <row> <id><![CDATA[2439]]></id> <name><![CDATA[quickStatAdminParticipationAndStat]]></name> <key><![CDATA[questionCross]]></key> <value><![CDATA[null]]></value> </row> <row> <id><![CDATA[2438]]></id> <name><![CDATA[quickStatAdminParticipationAndStat]]></name> <key><![CDATA[tokenAttributes]]></key> <value><![CDATA[null]]></value> </row> <row> <id><![CDATA[2437]]></id> <name><![CDATA[quickStatAdminParticipationAndStat]]></name> <key><![CDATA[numberMax]]></key> <value><![CDATA["0"]]></value> </row> <row> <id><![CDATA[2436]]></id> <name><![CDATA[quickStatAdminParticipationAndStat]]></name> <key><![CDATA[alternateTitle]]></key> <value><![CDATA[""]]></value> </row> <row> <id><![CDATA[2435]]></id> <name><![CDATA[findUserAgentInfo]]></name> <key><![CDATA[active]]></key> <value><![CDATA[""]]></value> </row> </rows> </plugin_settings> <themes> <theme> <sid>476956</sid> <template_name>skelvanilla</template_name> <config> <options> <general_inherit>1</general_inherit> <fixnumauto>inherit</fixnumauto> <theme>css/variations/contrast-awesome.min.css</theme> <questionsize>inherit</questionsize> <questioncolor>inherit</questioncolor> <questionwrap>inherit</questionwrap> <helpcolor>inherit</helpcolor> <validitycolor>inherit</validitycolor> <descriptiondisplay>inherit</descriptiondisplay> <titlelocation>inherit</titlelocation> <brandlogofile>inherit</brandlogofile> <surveylistlogofile>inherit</surveylistlogofile> <poweredlogofile>inherit</poweredlogofile> <hideprivacyinfo>inherit</hideprivacyinfo> <showpopups>inherit</showpopups> <questionhtag>inherit</questionhtag> <removeback>inherit</removeback> <dynamicvalidity>inherit</dynamicvalidity> <showclearall>inherit</showclearall> <tableheader>inherit</tableheader> <savelink>inherit</savelink> <clearalllink>inherit</clearalllink> <indexlink>inherit</indexlink> <languagelink>inherit</languagelink> <previouslink>inherit</previouslink> <nextsubmitlink>inherit</nextsubmitlink> <container>inherit</container> <headercontainer>inherit</headercontainer> <fixedheader>inherit</fixedheader> <bodyloaded>inherit</bodyloaded> <brandlogo>inherit</brandlogo> <brandlogoasbanner>inherit</brandlogoasbanner> <surveylistlogo>inherit</surveylistlogo> <poweredlogo>inherit</poweredlogo> <poweredlink>inherit</poweredlink> <poweredtext>inherit</poweredtext> <availablevariations>inherit</availablevariations> </options> </config> </theme> <theme> <sid>476956</sid> <template_name>vanilla</template_name> <config> <options>inherit</options> </config> </theme> </themes> <themes_inherited> <theme> <sid>476956</sid> <template_name>skelvanilla</template_name> <config> <options> <general_inherit>1</general_inherit> <fixnumauto>disable</fixnumauto> <theme>css/variations/contrast-awesome.min.css</theme> <questionsize>h4</questionsize> <questioncolor>primary</questioncolor> <questionwrap>none</questionwrap> <helpcolor>text-info</helpcolor> <validitycolor>text-info</validitycolor> <titlelocation>header</titlelocation> <brandlogofile>./files/logo.png</brandlogofile> <surveylistlogofile>./files/survey_list_header.png</surveylistlogofile> <poweredlogofile>./files/poweredby.png</poweredlogofile> <hideprivacyinfo>off</hideprivacyinfo> <questionhtag>off</questionhtag> <removeback>on</removeback> <dynamicvalidity>off</dynamicvalidity> <showclearall>on</showclearall> <tableheader>on</tableheader> <savelink>on</savelink> <clearalllink>on</clearalllink> <indexlink>on</indexlink> <languagelink>on</languagelink> <previouslink>off</previouslink> <nextsubmitlink>off</nextsubmitlink> <container>on</container> <headercontainer>off</headercontainer> <fixedheader>off</fixedheader> <bodyloaded>on</bodyloaded> <brandlogo>off</brandlogo> <brandlogoasbanner>off</brandlogoasbanner> <surveylistlogo>on</surveylistlogo> <poweredlogo>on</poweredlogo> <poweredlink>https://sondages.pro</poweredlink> <poweredtext>Theme by Sondages Pro</poweredtext> <availablevariations>{ "contrast": { "name": "Contrast", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "bootstrap": { "name": "Bootstrap", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "cerulean": { "name": "Cerulean", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "cosmo": { "name": "Cosmo", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "cyborg": { "name": "Cyborg", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "darkly": { "name": "Darkly", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "flatly": { "name": "Flatly", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "journal": { "name": "Journal", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "lumen": { "name": "Lumen", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "paper": { "name": "Paper", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "readable": { "name": "Readable", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "sandstone": { "name": "Sandstone", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "simplex": { "name": "Simplex", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "slate": { "name": "Slate", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "spacelab": { "name": "Spacelab", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "superhero": { "name": "Superhero", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "united": { "name": "United", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "yeti": { "name": "Yeti", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "fruity-apple_blossom": { "name": "(Fruity) Apple Blossom", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "fruity-black_pearl": { "name": "(Fruity) Black Pearl", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "fruity-free_magenta": { "name": "(Fruity) Free magenta", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "fruity-purple_tentacle": { "name": "(Fruity) Purple Tentacle", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "fruity-sea_green": { "name": "(Fruity) Sea Green", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "fruity-skyline_blue": { "name": "(Fruity) Skyline Blue", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" }, "fruity-sunset_orange": { "name": "(Fruity) Sunset Orange", "base": "1", "button": "1", "awesome": "1", "button_awesome": "1" } }</availablevariations> </options> </config> </theme> <theme> <sid>476956</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_476956.lss (42,089 bytes)

Bug heat	4
Complete LimeSurvey version number (& build)	5.2.9
I will donate to the project if issue is resolved	No
Browser	not relevant
Database type & version	mariadb
Server OS (if known)	fedora/linux
Webserver software & version (if known)	nginx
PHP Version	7.4

User List	There are no users monitoring this issue.

DenisChenu 2022-01-10 16:55 developer ~67944	The request is OK Doing the request on SQl : return 2 values Activating SQLdebug show : system.db.CDbCommand.query(SELECT `t`.`qaid`, `t`.`qid`, `t`.`attribute`, `t`.`value`, `t`.`language` FROM `lime_question_attributes` `t` LEFT JOIN lime_questions as question ON `question`.`qid`=`t`.`qid` WHERE question.sid = :sid and attribute = :attribute and value = :value. Bound with :sid='755657', :attribute='pdfReport', :value='1') I test before xssFilter fix : seems OK. I go before 5.2 …

DenisChenu 2022-01-10 17:17 developer ~67946 Last edited: 2022-01-11 17:15	Workaround : usage of findAllByArray Related : https://github.com/LimeSurvey/LimeSurvey/blob/538e0706f17938b31631c4b76874020323da7afd/application/models/LSActiveRecord.php#L63 ? But why this broke with find ?

gabrieljenik 2022-01-25 12:58 manager ~68090	QuestionAttribute model has a default scope. That default scope doesn't impact the query, but how the results are populated from the DB: populateRecords() uses the "attribute" attribute as the index of the array, and is therefore overwritten and a single record is returned. If you disable it, everything will be OK. `/** * This defaultScope indexes the ActiveRecords given back by attribute name * Important: This does not work if you want to retrieve records for more than one question at a time. * In that case disable the defaultScope by using MyModel::model()->resetScope()->findAll(); * @return array Scope that indexes the records by their attribute bane */ public function defaultScope() { return array('index' => 'attribute'); }`

DenisChenu 2022-01-25 14:24 developer ~68091	Why adding this defaultScope ? What usage ? Even with one question : attribute is not the index with lang. This must be removed from defaultScope , no ?

gabrieljenik 2022-01-26 13:21 manager ~68114	Not sure. It was like that when I found it! We could remove it, but I suggest to create a new story for it and have @galads prioritize it. Removing it would require some research and quite some testing. That's the problem.

DenisChenu 2022-01-26 15:14 developer ~68116	I ask on commit from @c_schmitz https://github.com/LimeSurvey/LimeSurvey/commit/7213088904adc71c027c097f13cbb76605801a5c#diff-ac521af6038093a1c4c5c35c0e901c23f2f4dc0572163912ad047d4f12a4574b I don't understand why adding it. And since this update disable Yii Core system :)

Date Modified	Username	Field	Change
2022-01-10 16:52	DenisChenu	New Issue
2022-01-10 16:52	DenisChenu	File Added: pdfReport.zip
2022-01-10 16:52	DenisChenu	File Added: limesurvey_survey_476956.lss
2022-01-10 16:55	DenisChenu	Note Added: 67944
2022-01-10 16:55	DenisChenu	Bug heat	0 => 2
2022-01-10 17:17	DenisChenu	Note Added: 67946
2022-01-10 17:45	ollehar	Product Version	=> 5.2.x
2022-01-11 17:15	galads	Assigned To	=> galads
2022-01-11 17:15	galads	Status	new => confirmed
2022-01-11 17:15	galads	Zoho Project Synchronization	=> \|Yes\|
2022-01-25 12:58	gabrieljenik	Note Added: 68090
2022-01-25 12:58	gabrieljenik	Bug heat	2 => 4
2022-01-25 14:24	DenisChenu	Note Added: 68091
2022-01-26 13:21	gabrieljenik	Note Added: 68114
2022-01-26 15:14	DenisChenu	Note Added: 68116
2022-02-23 10:35	galads	Zoho Project Synchronization	Yes =>
2024-06-26 10:22	DenisChenu	Assigned To	galads =>
2024-06-26 10:22	DenisChenu	Status	confirmed => new

View Issue Details

Steps to reproduce

Expected result

Actual result

Users monitoring this issue

Activities

Issue History