12113: Unable to fix Invalid Sub questions in multilingua survey

This issue affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

12113	Bug reports	Survey taking	public	2017-02-03 17:39	2017-04-18 15:41

Reporter	DenisChenu	Assigned To	DenisChenu
Priority	none	Severity	minor
Status	closed	Resolution	fixed
Product Version	2.62.x
Fixed in Version	2.63.x

Summary	12113: Unable to fix Invalid Sub questions in multilingua survey
Description	I track down how it happen, but currently : a survey can have invalid subquestion in second or third language. There are no way to remove this questions ... Example : survey in FR : sub question in FR SQ001/SQ002/SQ003, second lang : EN : sub question in EN : SQ001/SQ002/SQ003/INVALID => Survey is broken in englsi (receive always error)
Steps To Reproduce	Import included survey, Launch survey in english Answer to the "Don't known what happen here and how it's happen. " question See the error Try to remove the subquestion via GUI ....
Additional Information	1st step -> Fix survey with 'Data integrity' (by survey) -> data integrity by survey is done when activate
Tags	No tags attached.
Attached Files	survey_archive_multiSubQBug.lsa (4,252 bytes) Exception.html (26,975 bytes) <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <title>Exception</title> <style type="text/css"> /<![CDATA[/ html,body,div,span,applet,object,iframe,h1,h2,h3,h4,h5,h6,p,blockquote,pre,a,abbr,acronym,address,big,cite,code,del,dfn,em,font,img,ins,kbd,q,s,samp,small,strike,strong,sub,sup,tt,var,b,u,i,center,dl,dt,dd,ol,ul,li,fieldset,form,label,legend,table,caption,tbody,tfoot,thead,tr,th,td{border:0;outline:0;font-size:100%;vertical-align:baseline;background:transparent;margin:0;padding:0;} body{line-height:1;} ol,ul{list-style:none;} blockquote,q{quotes:none;} blockquote:before,blockquote:after,q:before,q:after{content:none;} :focus{outline:0;} ins{text-decoration:none;} del{text-decoration:line-through;} table{border-collapse:collapse;border-spacing:0;} body { font: normal 9pt "Verdana"; color: #000; background: #fff; } h1 { font: normal 18pt "Verdana"; color: #f00; margin-bottom: .5em; } h2 { font: normal 14pt "Verdana"; color: #800000; margin-bottom: .5em; } h3 { font: bold 11pt "Verdana"; } pre { font: normal 11pt Menlo, Consolas, "Lucida Console", Monospace; } pre span.error { display: block; background: #fce3e3; } pre span.ln { color: #999; padding-right: 0.5em; border-right: 1px solid #ccc; } pre span.error-ln { font-weight: bold; } .container { margin: 1em 4em; } .version { color: gray; font-size: 8pt; border-top: 1px solid #aaa; padding-top: 1em; margin-bottom: 1em; } .message { color: #000; padding: 1em; font-size: 11pt; background: #f3f3f3; -webkit-border-radius: 10px; -moz-border-radius: 10px; border-radius: 10px; margin-bottom: 1em; line-height: 160%; } .source { margin-bottom: 1em; } .code pre { background-color: #ffe; margin: 0.5em 0; padding: 0.5em; line-height: 125%; border: 1px solid #eee; } .source .file { margin-bottom: 1em; font-weight: bold; } .traces { margin: 2em 0; } .trace { margin: 0.5em 0; padding: 0.5em; } .trace.app { border: 1px dashed #c00; } .trace .number { text-align: right; width: 2em; padding: 0.5em; } .trace .content { padding: 0.5em; } .trace .plus, .trace .minus { display:inline; vertical-align:middle; text-align:center; border:1px solid #000; color:#000; font-size:10px; line-height:10px; margin:0; padding:0 1px; width:10px; height:10px; } .trace.collapsed .minus, .trace.expanded .plus, .trace.collapsed pre { display: none; } .trace-file { cursor: pointer; padding: 0.2em; } .trace-file:hover { background: #f0ffff; } /]]>/ </style> </head> <body> <div class="container"> <h1>Exception</h1> <p class="message"> Error executing query in dbExecuteAssoc:CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column '779847X2989X5717157174' in 'field list'. The SQL statement executed was: UPDATE lime_survey_779847 SET `lastpage`=0, `779847X2989X57171SQ001`='', `779847X2989X57171SQ002`='', `779847X2989X57171SQ003`='A1', `779847X2989X5717157174`='A1' WHERE ID=1 </p> <div class="source"> <p class="file">/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/helpers/database_helper.php(44)</p> <div class="code"><pre><span class="ln">32</span> { <span class="ln">33</span> $dataset=Yii::app()->db->createCommand($sql)->query(); <span class="ln">34</span> <span class="ln">35</span> } <span class="ln">36</span> } catch(CDbException $e) { <span class="ln">37</span> $error = $e->getMessage(); <span class="ln">38</span> $dataset=false; <span class="ln">39</span> } <span class="ln">40</span> <span class="ln">41</span> if (!$dataset && (Yii::app()->getConfig('debug') >0 \|\| !$silent)) <span class="ln">42</span> { <span class="ln">43</span> // Exception is better than safeDie, because you can see the backtrace. <span class="error"><span class="ln error-ln">44</span> throw new \Exception('Error executing query in dbExecuteAssoc:'.$error); </span><span class="ln">45</span> } <span class="ln">46</span> return $dataset; <span class="ln">47</span> } <span class="ln">48</span> <span class="ln">49</span> <span class="ln">50</span> function dbQueryOrFalse($sql) <span class="ln">51</span> { <span class="ln">52</span> try { <span class="ln">53</span> $dataset=Yii::app()->db->createCommand($sql)->query(); <span class="ln">54</span> } catch(CDbException $e) { <span class="ln">55</span> $dataset=false; <span class="ln">56</span> } </pre></div> </div> <div class="traces"> <h2>Stack Trace</h2> <table style="width:100%;"> <tr class="trace app expanded"> <td class="number"> #0 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/helpers/expressions/em_manager_helper.php(5500): <strong>dbExecuteAssoc</strong>("UPDATE {{survey_779847}} SET `lastpage`=0, `779847X2989X57171SQ0...") </div> <div class="code"><pre><span class="ln">5495</span> <span class="ln">5496</span> if (isset($_SESSION[$this->sessid]['srid']) && $this->surveyOptions['active']) <span class="ln">5497</span> { <span class="ln">5498</span> $query .= $_SESSION[$this->sessid]['srid']; <span class="ln">5499</span> <span class="error"><span class="ln error-ln">5500</span> if (!dbExecuteAssoc($query)) </span><span class="ln">5501</span> { <span class="ln">5502</span> // TODO: This kills the session if adminemail is defined, so the queries below won't work. <span class="ln">5503</span> $message = submitfailed('', $query); // TODO - report SQL error? <span class="ln">5504</span> <span class="ln">5505</span> if (($this->debugLevel & LEM_DEBUG_VALIDATION_SUMMARY) == LEM_DEBUG_VALIDATION_SUMMARY) { </pre></div> </td> </tr> <tr class="trace app expanded"> <td class="number"> #1 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/helpers/expressions/em_manager_helper.php(5656): <strong>LimeExpressionManager</strong>-><strong>_UpdateValuesInDatabase</strong>(array("779847X2989X57171SQ001" => array("type" => "F", "value" => ""), "779847X2989X57171SQ002" => array("type" => "F", "value" => ""), "779847X2989X57171SQ003" => array("type" => "F", "value" => "A1"), "779847X2989X5717157174" => array("type" => "F", "value" => "A1")), false) </div> <div class="code"><pre><span class="ln">5651</span> $message .= $result['message']; <span class="ln">5652</span> $updatedValues = array_merge($updatedValues,$result['updatedValues']); <span class="ln">5653</span> if (!is_null($result) && ($result['mandViolation'] \|\| !$result['valid'])) <span class="ln">5654</span> { <span class="ln">5655</span> // redisplay the current group, showing error <span class="error"><span class="ln error-ln">5656</span> $message .= $LEM->_UpdateValuesInDatabase($updatedValues,false); </span><span class="ln">5657</span> $LEM->runtimeTimings[] = array(__METHOD__,(microtime(true) - $now)); <span class="ln">5658</span> $LEM->lastMoveResult = array( <span class="ln">5659</span> 'finished'=>false, <span class="ln">5660</span> 'message'=>$message, <span class="ln">5661</span> 'gseq'=>$LEM->currentGroupSeq, </pre></div> </td> </tr> <tr class="trace app expanded"> <td class="number"> #2 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/helpers/SurveyRuntimeHelper.php(583): <strong>LimeExpressionManager</strong>::<strong>JumpTo</strong>(2, false) </div> <div class="code"><pre><span class="ln">578</span> { <span class="ln">579</span> // may be submitting from the navigation bar, in which case need to process all intervening questions <span class="ln">580</span> // in order to update equations and ensure there are no intervening relevant mandatory or relevant invalid questions <span class="ln">581</span> if($thissurvey['questionindex']==2) // Must : save actual page , review whole before set finished to true (see #09906), index==1 seems to don't need it : (don't force move) <span class="ln">582</span> LimeExpressionManager::StartSurvey($surveyid, $surveyMode, $surveyOptions); <span class="error"><span class="ln error-ln">583</span> $moveResult = LimeExpressionManager::JumpTo($_SESSION[$LEMsessid]['totalsteps'] + 1, false); </span><span class="ln">584</span> } <span class="ln">585</span> } <span class="ln">586</span> if (isset($move) && $move=='changelang') <span class="ln">587</span> { <span class="ln">588</span> // jump to current step using new language, processing POST values </pre></div> </td> </tr> <tr class="trace app collapsed"> <td class="number"> #3 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/controllers/survey/index.php(611): <strong>SurveyRuntimeHelper</strong>-><strong>run</strong>("779847", array("surveyid" => "779847", "thissurvey" => array("template" => "default", "language" => "fr", "sid" => "779847", "owner_id" => "1", ...), "thisstep" => "1", "tokensexist" => 0, ...)) </div> <div class="code"><pre><span class="ln">606</span> //Send local variables to the appropriate survey type <span class="ln">607</span> unset($redata); <span class="ln">608</span> $redata = compact(array_keys(get_defined_vars())); <span class="ln">609</span> Yii::import('application.helpers.SurveyRuntimeHelper'); <span class="ln">610</span> $tmp = new SurveyRuntimeHelper(); <span class="error"><span class="ln error-ln">611</span> $tmp->run($surveyid,$redata); </span><span class="ln">612</span> <span class="ln">613</span> if (App()->request->getPost('saveall') \|\| isset($flashmessage)) <span class="ln">614</span> { <span class="ln">615</span> App()->clientScript->registerScript("saveflashmessage","alert('".gT("Your responses were successfully saved.","js")."');",CClientScript::POS_READY); <span class="ln">616</span> } </pre></div> </td> </tr> <tr class="trace app collapsed"> <td class="number"> #4 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/controllers/survey/index.php(70): <strong>index</strong>-><strong>action</strong>() </div> <div class="code"><pre><span class="ln">65</span> App()->getClientScript()->reset(); <span class="ln">66</span> return $buffer; <span class="ln">67</span> }); <span class="ln">68</span> <span class="ln">69</span> ob_implicit_flush(false); <span class="error"><span class="ln error-ln">70</span> $this->action(); </span><span class="ln">71</span> ob_flush(); <span class="ln">72</span> } <span class="ln">73</span> <span class="ln">74</span> function action() <span class="ln">75</span> { </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #5 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/actions/CAction.php(76): <strong>index</strong>-><strong>run</strong>() </div> <div class="code"><pre><span class="ln">71</span> { <span class="ln">72</span> $method=new ReflectionMethod($this, 'run'); <span class="ln">73</span> if($method->getNumberOfParameters()>0) <span class="ln">74</span> return $this->runWithParamsInternal($this, $method, $params); <span class="ln">75</span> <span class="error"><span class="ln error-ln">76</span> $this->run(); </span><span class="ln">77</span> return true; <span class="ln">78</span> } <span class="ln">79</span> <span class="ln">80</span> /** <span class="ln">81</span> * Executes a method of an object with the supplied named parameters. </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #6 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CController.php(308): <strong>CAction</strong>-><strong>runWithParams</strong>(array("sid" => "779847")) </div> <div class="code"><pre><span class="ln">303</span> { <span class="ln">304</span> $priorAction=$this->_action; <span class="ln">305</span> $this->_action=$action; <span class="ln">306</span> if($this->beforeAction($action)) <span class="ln">307</span> { <span class="error"><span class="ln error-ln">308</span> if($action->runWithParams($this->getActionParams())===false) </span><span class="ln">309</span> $this->invalidActionParams($action); <span class="ln">310</span> else <span class="ln">311</span> $this->afterAction($action); <span class="ln">312</span> } <span class="ln">313</span> $this->_action=$priorAction; </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #7 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CController.php(286): <strong>CController</strong>-><strong>runAction</strong>(index) </div> <div class="code"><pre><span class="ln">281</span> * @see runAction <span class="ln">282</span> / <span class="ln">283</span> public function runActionWithFilters($action,$filters) <span class="ln">284</span> { <span class="ln">285</span> if(empty($filters)) <span class="error"><span class="ln error-ln">286</span> $this->runAction($action); </span><span class="ln">287</span> else <span class="ln">288</span> { <span class="ln">289</span> $priorAction=$this->_action; <span class="ln">290</span> $this->_action=$action; <span class="ln">291</span> CFilterChain::create($this,$action,$filters)->run(); </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #8 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CController.php(265): <strong>CController</strong>-><strong>runActionWithFilters</strong>(index, array()) </div> <div class="code"><pre><span class="ln">260</span> { <span class="ln">261</span> if(($parent=$this->getModule())===null) <span class="ln">262</span> $parent=Yii::app(); <span class="ln">263</span> if($parent->beforeControllerAction($this,$action)) <span class="ln">264</span> { <span class="error"><span class="ln error-ln">265</span> $this->runActionWithFilters($action,$this->filters()); </span><span class="ln">266</span> $parent->afterControllerAction($this,$action); <span class="ln">267</span> } <span class="ln">268</span> } <span class="ln">269</span> else <span class="ln">270</span> $this->missingAction($actionID); </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #9 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CWebApplication.php(282): <strong>CController</strong>-><strong>run</strong>("index") </div> <div class="code"><pre><span class="ln">277</span> { <span class="ln">278</span> list($controller,$actionID)=$ca; <span class="ln">279</span> $oldController=$this->_controller; <span class="ln">280</span> $this->_controller=$controller; <span class="ln">281</span> $controller->init(); <span class="error"><span class="ln error-ln">282</span> $controller->run($actionID); </span><span class="ln">283</span> $this->_controller=$oldController; <span class="ln">284</span> } <span class="ln">285</span> else <span class="ln">286</span> throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".', <span class="ln">287</span> array('{route}'=>$route===''?$this->defaultController:$route))); </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #10 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CWebApplication.php(141): <strong>CWebApplication</strong>-><strong>runController</strong>("survey/index/sid/779847") </div> <div class="code"><pre><span class="ln">136</span> foreach(array_splice($this->catchAllRequest,1) as $name=>$value) <span class="ln">137</span> $_GET[$name]=$value; <span class="ln">138</span> } <span class="ln">139</span> else <span class="ln">140</span> $route=$this->getUrlManager()->parseUrl($this->getRequest()); <span class="error"><span class="ln error-ln">141</span> $this->runController($route); </span><span class="ln">142</span> } <span class="ln">143</span> <span class="ln">144</span> /* <span class="ln">145</span> * Registers the core application components. <span class="ln">146</span> * This method overrides the parent implementation by registering additional core components. </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #11 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/base/CApplication.php(185): <strong>CWebApplication</strong>-><strong>processRequest</strong>() </div> <div class="code"><pre><span class="ln">180</span> public function run() <span class="ln">181</span> { <span class="ln">182</span> if($this->hasEventHandler('onBeginRequest')) <span class="ln">183</span> $this->onBeginRequest(new CEvent($this)); <span class="ln">184</span> register_shutdown_function(array($this,'end'),0,false); <span class="error"><span class="ln error-ln">185</span> $this->processRequest(); </span><span class="ln">186</span> if($this->hasEventHandler('onEndRequest')) <span class="ln">187</span> $this->onEndRequest(new CEvent($this)); <span class="ln">188</span> } <span class="ln">189</span> <span class="ln">190</span> /** </pre></div> </td> </tr> <tr class="trace app collapsed"> <td class="number"> #12 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/index.php(214): <strong>CApplication</strong>-><strong>run</strong>() </div> <div class="code"><pre><span class="ln">209</span> die (sprintf('%s should be writable by the webserver (766 or 776).', $sDefaultRuntimePath)); <span class="ln">210</span> } <span class="ln">211</span> } <span class="ln">212</span> <span class="ln">213</span> Yii::$enableIncludePath = false; <span class="error"><span class="ln error-ln">214</span> Yii::createApplication('LSYii_Application', $config)->run(); </span><span class="ln">215</span> <span class="ln">216</span> /* End of file index.php / <span class="ln">217</span> / Location: ./index.php / </pre></div> </td> </tr> </table> </div> <div class="version"> 2017-02-03 17:29:28 Apache/2.2.22 (Debian) <a href="http://www.yiiframework.com/">Yii Framework</a>/1.1.17 </div> </div> <script type="text/javascript"> /<![CDATA[/ var traceReg = new RegExp("(^\|\\s)trace-file(\\s\|$)"); var collapsedReg = new RegExp("(^\|\\s)collapsed(\\s\|$)"); var e = document.getElementsByTagName("div"); for(var j=0,len=e.length;j<len;j++){ if(traceReg.test(e[j].className)){ e[j].onclick = function(){ var trace = this.parentNode.parentNode; if(collapsedReg.test(trace.className)) trace.className = trace.className.replace("collapsed", "expanded"); else trace.className = trace.className.replace("expanded", "collapsed"); } } } /]]>*/ </script> </body> </html> <!-- start log messages --> <table class="yiiLog" width="100%" cellpadding="2" style="border-spacing:1px;font:11px Verdana, Arial, Helvetica, sans-serif;background:#EEEEEE;color:#666666;"> <tr> <th style="background:black;color:white;" colspan="5"> Application Log </th> </tr> <tr style="background-color: #ccc;"> <th style="width:120px">Timestamp</th> <th>Level</th> <th>Category</th> <th>Message</th> </tr> <tr style="background:#FFC0CB"> <td align="center">17:29:27.986068</td> <td>error</td> <td>system.db.CDbCommand</td> <td><pre>CDbCommand::() failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column '779847X2989X5717157174' in 'field list'. The SQL statement executed was: UPDATE lime_survey_779847 SET `lastpage`=0, `779847X2989X57171SQ001`='', `779847X2989X57171SQ002`='', `779847X2989X57171SQ003`='A1', `779847X2989X5717157174`='A1' WHERE ID=1.</pre></td> </tr> <tr style="background:#FFC0CB"> <td align="center">17:29:28.223948</td> <td>error</td> <td>exception.Exception</td> <td><pre>exception 'Exception' with message 'Error executing query in dbExecuteAssoc:CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column '779847X2989X5717157174' in 'field list'. The SQL statement executed was: UPDATE lime_survey_779847 SET `lastpage`=0, `779847X2989X57171SQ001`='', `779847X2989X57171SQ002`='', `779847X2989X57171SQ003`='A1', `779847X2989X5717157174`='A1' WHERE ID=1' in /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/helpers/database_helper.php:44 Stack trace: #0 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/helpers/expressions/em_manager_helper.php(5500): dbExecuteAssoc('UPDATE {{survey...') #1 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/helpers/expressions/em_manager_helper.php(5656): LimeExpressionManager->_UpdateValuesInDatabase(Array, false) #2 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/helpers/SurveyRuntimeHelper.php(583): LimeExpressionManager::JumpTo(2, false) #3 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/controllers/survey/index.php(611): SurveyRuntimeHelper->run('779847', Array) #4 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/controllers/survey/index.php(70): index->action() #5 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/actions/CAction.php(76): index->run() #6 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CController.php(308): CAction->runWithParams(Array) #7 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CController.php(286): CController->runAction(Object(index)) #8 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CController.php(265): CController->runActionWithFilters(Object(index), Array) #9 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CWebApplication.php(282): CController->run('index') #10 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CWebApplication.php(141): CWebApplication->runController('survey/index/si...') #11 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/base/CApplication.php(185): CWebApplication->processRequest() #12 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/index.php(214): CApplication->run() #13 {main} REQUEST_URI=/index.php/779847 HTTP_REFERER=https://limesurvey.sondages.pro/ ---</pre></td> </tr></table> <!-- end of log messages --> Exception.html (26,975 bytes)

Bug heat	4
Complete LimeSurvey version number (& build)	20170302
I will donate to the project if issue is resolved	No
Browser	not relevant
Database type & version	unsure
Server OS (if known)	Linux
Webserver software & version (if known)	apache
PHP Version	unsure

User List	There are no users monitoring this issue.

DenisChenu 2017-02-03 17:40 developer ~42960	Maybe Expression Manager can test if column exist before adding it ? If not exist : log a clean error, and throw a alert to user : but save other answers Currently : none of the input in same page are saved.

DenisChenu 2017-02-05 12:56 developer ~42962	Don't found a clean place to do it (don't want to fix it each time a survey is launched) Then idea Fix it when load Sub question in admin GUI Try to load only valid sub question (with corresponding primary language) when launch survey

DenisChenu 2017-02-06 13:30 developer ~42963	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=22251

DenisChenu 2017-02-07 14:54 developer ~42978	Cuurently : fix only done when eidting subvquestion (need a way to fix it, and editing subquestion already fix (add needed subquestion for each extra languiage + delete subquestion in other language) Survey solution : https://github.com/LimeSurvey/LimeSurvey/pull/633

c_schmitz 2017-02-07 15:03 administrator ~42979	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=22260

LimeSurvey: master 67a1e1ee 2017-02-06 14:30 DenisChenu Details Diff	Fixed issue 12113: Unable to fix Invalid Sub questions in multilingual survey Dev: add a model function, currently call it when edit sub questions	Affected Issues 12113
	mod - application/controllers/admin/questions.php	Diff File
	mod - application/models/Question.php	Diff File
LimeSurvey: master 8d6b7bf5 2017-02-07 16:03 ~~user70560~~ Committer: c_schmitz Details Diff	Fixed issue 12113 : Fix invalid subquestions on activation Dev: add a Questions fixer for all other language Dev: use qid for question and title for subquestion : this broke Survey SQL Dev: we must have same qid+title then we can directly delete whole qid (no test on parent_qid) Dev: did we must log it ? In log("X questions are deleted",'info',application.survey.???) for example	Affected Issues 12113
	mod - application/helpers/admin/activate_helper.php	Diff File
	mod - application/helpers/common_helper.php	Diff File
	mod - application/models/Question.php	Diff File
	mod - application/models/Survey.php	Diff File

Date Modified	Username	Field	Change
2017-02-03 17:39	DenisChenu	New Issue
2017-02-03 17:39	DenisChenu	File Added: survey_archive_multiSubQBug.lsa
2017-02-03 17:39	DenisChenu	File Added: Exception.html
2017-02-03 17:39	DenisChenu	Assigned To	=> DenisChenu
2017-02-03 17:39	DenisChenu	Status	new => assigned
2017-02-03 17:40	DenisChenu	Note Added: 42960
2017-02-05 12:56	DenisChenu	Note Added: 42962
2017-02-06 13:30	DenisChenu	Changeset attached	=> LimeSurvey master 67a1e1ee
2017-02-06 13:30	DenisChenu	Note Added: 42963
2017-02-06 13:30	DenisChenu	Resolution	open => fixed
2017-02-07 14:53	DenisChenu	Assigned To	DenisChenu => c_schmitz
2017-02-07 14:54	DenisChenu	Note Added: 42978
2017-02-07 15:03	c_schmitz	Changeset attached	=> LimeSurvey master 8d6b7bf5
2017-02-07 15:03	c_schmitz	Note Added: 42979
2017-02-07 15:08	c_schmitz	Assigned To	c_schmitz => DenisChenu
2017-02-07 15:08	c_schmitz	Status	assigned => resolved
2017-02-07 15:08	c_schmitz	Fixed in Version	=> 2.62.x
2017-02-21 12:00	c_schmitz	Status	resolved => closed
2017-02-21 12:00	c_schmitz	Fixed in Version	2.62.x => 2.63.x
2017-04-18 15:41	DenisChenu	Relationship added	related to 12272

View Issue Details

Relationships

Users monitoring this issue

Activities

Related Changesets

Issue History