View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
12113Bug reportsSurvey takingpublic2017-04-18 15:41
ReporterDenisChenu Assigned ToDenisChenu  
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Product Version2.62.x 
Fixed in Version2.63.x 
Summary12113: 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

TagsNo tags attached.
Attached Files
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 &#039;779847X2989X5717157174&#039; in &#039;field list&#039;. The SQL statement executed was: UPDATE lime_survey_779847 SET `lastpage`=0, `779847X2989X57171SQ001`=&#039;&#039;, `779847X2989X57171SQ002`=&#039;&#039;, `779847X2989X57171SQ003`=&#039;A1&#039;, `779847X2989X5717157174`=&#039;A1&#039; 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()-&gt;db-&gt;createCommand($sql)-&gt;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-&gt;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 &amp;&amp; (Yii::app()-&gt;getConfig(&#039;debug&#039;) &gt;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(&#039;Error executing query in dbExecuteAssoc:&#039;.$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()-&gt;db-&gt;createCommand($sql)-&gt;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>
										&nbsp;/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/helpers/expressions/em_manager_helper.php(5500): <strong>dbExecuteAssoc</strong>(&quot;UPDATE {{survey_779847}} SET `lastpage`=0, `779847X2989X57171SQ0...&quot;)				</div>

				<div class="code"><pre><span class="ln">5495</span> 
<span class="ln">5496</span>                 if (isset($_SESSION[$this-&gt;sessid][&#039;srid&#039;]) &amp;&amp; $this-&gt;surveyOptions[&#039;active&#039;])
<span class="ln">5497</span>                 {
<span class="ln">5498</span>                     $query .= $_SESSION[$this-&gt;sessid][&#039;srid&#039;];
<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&#039;t work.
<span class="ln">5503</span>                         $message = submitfailed(&#039;&#039;, $query);  // TODO - report SQL error?
<span class="ln">5504</span> 
<span class="ln">5505</span>                         if (($this-&gt;debugLevel &amp; 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>
										&nbsp;/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/helpers/expressions/em_manager_helper.php(5656): <strong>LimeExpressionManager</strong>-><strong>_UpdateValuesInDatabase</strong>(array(&quot;779847X2989X57171SQ001&quot; =&gt; array(&quot;type&quot; =&gt; &quot;F&quot;, &quot;value&quot; =&gt; &quot;&quot;), &quot;779847X2989X57171SQ002&quot; =&gt; array(&quot;type&quot; =&gt; &quot;F&quot;, &quot;value&quot; =&gt; &quot;&quot;), &quot;779847X2989X57171SQ003&quot; =&gt; array(&quot;type&quot; =&gt; &quot;F&quot;, &quot;value&quot; =&gt; &quot;A1&quot;), &quot;779847X2989X5717157174&quot; =&gt; array(&quot;type&quot; =&gt; &quot;F&quot;, &quot;value&quot; =&gt; &quot;A1&quot;)), false)				</div>

				<div class="code"><pre><span class="ln">5651</span>                         $message .= $result[&#039;message&#039;];
<span class="ln">5652</span>                         $updatedValues = array_merge($updatedValues,$result[&#039;updatedValues&#039;]);
<span class="ln">5653</span>                         if (!is_null($result) &amp;&amp; ($result[&#039;mandViolation&#039;] || !$result[&#039;valid&#039;]))
<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-&gt;_UpdateValuesInDatabase($updatedValues,false);
</span><span class="ln">5657</span>                             $LEM-&gt;runtimeTimings[] = array(__METHOD__,(microtime(true) - $now));
<span class="ln">5658</span>                             $LEM-&gt;lastMoveResult = array(
<span class="ln">5659</span>                                 &#039;finished&#039;=&gt;false,
<span class="ln">5660</span>                                 &#039;message&#039;=&gt;$message,
<span class="ln">5661</span>                                 &#039;gseq&#039;=&gt;$LEM-&gt;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>
										&nbsp;/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[&#039;questionindex&#039;]==2) // Must : save actual page , review whole before set finished to true (see #09906), index==1 seems to don&#039;t need it : (don&#039;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][&#039;totalsteps&#039;] + 1, false);
</span><span class="ln">584</span>                     }
<span class="ln">585</span>                 }
<span class="ln">586</span>                 if (isset($move) &amp;&amp; $move==&#039;changelang&#039;)
<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>
										&nbsp;/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/controllers/survey/index.php(611): <strong>SurveyRuntimeHelper</strong>-><strong>run</strong>(&quot;779847&quot;, array(&quot;surveyid&quot; =&gt; &quot;779847&quot;, &quot;thissurvey&quot; =&gt; array(&quot;template&quot; =&gt; &quot;default&quot;, &quot;language&quot; =&gt; &quot;fr&quot;, &quot;sid&quot; =&gt; &quot;779847&quot;, &quot;owner_id&quot; =&gt; &quot;1&quot;, ...), &quot;thisstep&quot; =&gt; &quot;1&quot;, &quot;tokensexist&quot; =&gt; 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(&#039;application.helpers.SurveyRuntimeHelper&#039;);
<span class="ln">610</span>         $tmp = new SurveyRuntimeHelper();
<span class="error"><span class="ln error-ln">611</span>         $tmp-&gt;run($surveyid,$redata);
</span><span class="ln">612</span> 
<span class="ln">613</span>         if (App()-&gt;request-&gt;getPost(&#039;saveall&#039;) || isset($flashmessage))
<span class="ln">614</span>         {
<span class="ln">615</span>             App()-&gt;clientScript-&gt;registerScript(&quot;saveflashmessage&quot;,&quot;alert(&#039;&quot;.gT(&quot;Your responses were successfully saved.&quot;,&quot;js&quot;).&quot;&#039;);&quot;,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>
										&nbsp;/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()-&gt;getClientScript()-&gt;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-&gt;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>
										&nbsp;/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, &#039;run&#039;);
<span class="ln">73</span>         if($method-&gt;getNumberOfParameters()&gt;0)
<span class="ln">74</span>             return $this-&gt;runWithParamsInternal($this, $method, $params);
<span class="ln">75</span> 
<span class="error"><span class="ln error-ln">76</span>         $this-&gt;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>
										&nbsp;/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CController.php(308): <strong>CAction</strong>-><strong>runWithParams</strong>(array(&quot;sid&quot; =&gt; &quot;779847&quot;))				</div>

				<div class="code"><pre><span class="ln">303</span>     {
<span class="ln">304</span>         $priorAction=$this-&gt;_action;
<span class="ln">305</span>         $this-&gt;_action=$action;
<span class="ln">306</span>         if($this-&gt;beforeAction($action))
<span class="ln">307</span>         {
<span class="error"><span class="ln error-ln">308</span>             if($action-&gt;runWithParams($this-&gt;getActionParams())===false)
</span><span class="ln">309</span>                 $this-&gt;invalidActionParams($action);
<span class="ln">310</span>             else
<span class="ln">311</span>                 $this-&gt;afterAction($action);
<span class="ln">312</span>         }
<span class="ln">313</span>         $this-&gt;_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>
										&nbsp;/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-&gt;runAction($action);
</span><span class="ln">287</span>         else
<span class="ln">288</span>         {
<span class="ln">289</span>             $priorAction=$this-&gt;_action;
<span class="ln">290</span>             $this-&gt;_action=$action;
<span class="ln">291</span>             CFilterChain::create($this,$action,$filters)-&gt;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>
										&nbsp;/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-&gt;getModule())===null)
<span class="ln">262</span>                 $parent=Yii::app();
<span class="ln">263</span>             if($parent-&gt;beforeControllerAction($this,$action))
<span class="ln">264</span>             {
<span class="error"><span class="ln error-ln">265</span>                 $this-&gt;runActionWithFilters($action,$this-&gt;filters());
</span><span class="ln">266</span>                 $parent-&gt;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-&gt;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>
										&nbsp;/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CWebApplication.php(282): <strong>CController</strong>-><strong>run</strong>(&quot;index&quot;)				</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-&gt;_controller;
<span class="ln">280</span>             $this-&gt;_controller=$controller;
<span class="ln">281</span>             $controller-&gt;init();
<span class="error"><span class="ln error-ln">282</span>             $controller-&gt;run($actionID);
</span><span class="ln">283</span>             $this-&gt;_controller=$oldController;
<span class="ln">284</span>         }
<span class="ln">285</span>         else
<span class="ln">286</span>             throw new CHttpException(404,Yii::t(&#039;yii&#039;,&#039;Unable to resolve the request &quot;{route}&quot;.&#039;,
<span class="ln">287</span>                 array(&#039;{route}&#039;=&gt;$route===&#039;&#039;?$this-&gt;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>
										&nbsp;/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CWebApplication.php(141): <strong>CWebApplication</strong>-><strong>runController</strong>(&quot;survey/index/sid/779847&quot;)				</div>

				<div class="code"><pre><span class="ln">136</span>             foreach(array_splice($this-&gt;catchAllRequest,1) as $name=&gt;$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-&gt;getUrlManager()-&gt;parseUrl($this-&gt;getRequest());
<span class="error"><span class="ln error-ln">141</span>         $this-&gt;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>
										&nbsp;/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-&gt;hasEventHandler(&#039;onBeginRequest&#039;))
<span class="ln">183</span>             $this-&gt;onBeginRequest(new CEvent($this));
<span class="ln">184</span>         register_shutdown_function(array($this,&#039;end&#039;),0,false);
<span class="error"><span class="ln error-ln">185</span>         $this-&gt;processRequest();
</span><span class="ln">186</span>         if($this-&gt;hasEventHandler(&#039;onEndRequest&#039;))
<span class="ln">187</span>             $this-&gt;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>
										&nbsp;/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(&#039;%s should be writable by the webserver (766 or 776).&#039;, $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(&#039;LSYii_Application&#039;, $config)-&gt;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 &#039;779847X2989X5717157174&#039; in &#039;field list&#039;. The SQL statement executed
was: UPDATE lime_survey_779847 SET `lastpage`=0,
`779847X2989X57171SQ001`=&#039;&#039;, `779847X2989X57171SQ002`=&#039;&#039;,
`779847X2989X57171SQ003`=&#039;A1&#039;, `779847X2989X5717157174`=&#039;A1&#039; 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 &#039;Exception&#039; with message &#039;Error executing query in
dbExecuteAssoc:CDbCommand failed to execute the SQL statement:
SQLSTATE[42S22]: Column not found: 1054 Unknown column
&#039;779847X2989X5717157174&#039; in &#039;field list&#039;. The SQL statement executed was:
UPDATE lime_survey_779847 SET `lastpage`=0, `779847X2989X57171SQ001`=&#039;&#039;,
`779847X2989X57171SQ002`=&#039;&#039;, `779847X2989X57171SQ003`=&#039;A1&#039;,
`779847X2989X5717157174`=&#039;A1&#039; WHERE ID=1&#039; 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(&#039;UPDATE {{survey...&#039;)
#1
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/helpers/expressions/em_manager_helper.php(5656):
LimeExpressionManager-&gt;_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-&gt;run(&#039;779847&#039;, Array)
#4
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/controllers/survey/index.php(70):
index-&gt;action()
#5
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/actions/CAction.php(76):
index-&gt;run()
#6
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CController.php(308):
CAction-&gt;runWithParams(Array)
#7
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CController.php(286):
CController-&gt;runAction(Object(index))
#8
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CController.php(265):
CController-&gt;runActionWithFilters(Object(index), Array)
#9
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CWebApplication.php(282):
CController-&gt;run(&#039;index&#039;)
#10
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CWebApplication.php(141):
CWebApplication-&gt;runController(&#039;survey/index/si...&#039;)
#11
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/base/CApplication.php(185):
CWebApplication-&gt;processRequest()
#12 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/index.php(214):
CApplication-&gt;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 heat4
Complete LimeSurvey version number (& build)20170302
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionunsure
Server OS (if known)Linux
Webserver software & version (if known)apache
PHP Versionunsure

Relationships

related to 12272 closeddominikvitt Duplicated sub-question 

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

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

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

DenisChenu

2017-02-06 13:30

developer   ~42963

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=22251

DenisChenu

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

c_schmitz

2017-02-07 15:03

administrator   ~42979

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=22260

Related Changesets

LimeSurvey: master 67a1e1ee

2017-02-06 13:30:13

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 15:03:06

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

Issue History

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