View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
17208Bug reportsSurvey takingpublic2021-03-26 15:122021-07-12 11:54
ReporterDenisChenu Assigned ToDenisChenu  
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Product Version3.25.13 
Fixed in Version3.25.20 
Summary17208: Potential Column name must be either a string or an array during survey taking
Description

With some specific survey : participant can see «Column name must be either a string or an array during survey taking»

Steps To Reproduce

Didn't know …

Additional Information

I have it on a 3.25.15 / MSSQL
It's happen one time with one survey,

Import in same instance the LSA : the seconf import didn't have this issue.

BUT : the fix is really short

TagsNo tags attached.
Attached Files
CDbException.html (27,098 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>CDbException</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>CDbException</h1>

	<p class="message">
		Column name must be either a string or an array.	</p>

	<div class="source">
		<p class="file">E:\WebSite\limesurvey\framework\db\schema\CDbCommandBuilder.php(831)</p>
		<div class="code"><pre><span class="ln">819</span>             }
<span class="ln">820</span>             if(count($values)===1)
<span class="ln">821</span>             {
<span class="ln">822</span>                 $entries=array();
<span class="ln">823</span>                 foreach($values[0] as $name=&gt;$value)
<span class="ln">824</span>                     $entries[]=$prefix.$table-&gt;columns[$name]-&gt;rawName.($value===null?&#039; IS NULL&#039;:&#039;=&#039;.$value);
<span class="ln">825</span>                 return implode(&#039; AND &#039;,$entries);
<span class="ln">826</span>             }
<span class="ln">827</span> 
<span class="ln">828</span>             return $this-&gt;createCompositeInCondition($table,$values,$prefix);
<span class="ln">829</span>         }
<span class="ln">830</span>         else
<span class="error"><span class="ln error-ln">831</span>             throw new CDbException(Yii::t(&#039;yii&#039;,&#039;Column name must be either a string or an array.&#039;));
</span><span class="ln">832</span>     }
<span class="ln">833</span> 
<span class="ln">834</span>     /**
<span class="ln">835</span>      * Generates the expression for selecting rows with specified composite key values.
<span class="ln">836</span>      * @param CDbTableSchema $table the table schema
<span class="ln">837</span>      * @param array $values list of primary key values to be selected within
<span class="ln">838</span>      * @param string $prefix column prefix (ended with dot)
<span class="ln">839</span>      * @return string the expression for selection
<span class="ln">840</span>      */
<span class="ln">841</span>     protected function createCompositeInCondition($table,$values,$prefix)
<span class="ln">842</span>     {
<span class="ln">843</span>         $keyNames=array();
</pre></div>	</div>

	<div class="traces">
		<h2>Stack Trace</h2>
				<table style="width:100%;">
						<tr class="trace core collapsed">
			<td class="number">
				#0			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\limesurvey\framework\db\schema\CDbCommandBuilder.php(624): <strong>CDbCommandBuilder</strong>-><strong>createInCondition</strong>(CMssqlTableSchema, null, array(&quot;16&quot;), &quot;[t].&quot;)				</div>

				<div class="code"><pre><span class="ln">619</span>             $prefix=$this-&gt;_schema-&gt;quoteTableName($criteria-&gt;alias).&#039;.&#039;;
<span class="ln">620</span>         if(!is_array($pk)) // single key
<span class="ln">621</span>             $pk=array($pk);
<span class="ln">622</span>         if(is_array($table-&gt;primaryKey) &amp;&amp; !isset($pk[0]) &amp;&amp; $pk!==array()) // single composite key
<span class="ln">623</span>             $pk=array($pk);
<span class="error"><span class="ln error-ln">624</span>         $condition=$this-&gt;createInCondition($table,$table-&gt;primaryKey,$pk,$prefix);
</span><span class="ln">625</span>         if($criteria-&gt;condition!=&#039;&#039;)
<span class="ln">626</span>             $criteria-&gt;condition=$condition.&#039; AND (&#039;.$criteria-&gt;condition.&#039;)&#039;;
<span class="ln">627</span>         else
<span class="ln">628</span>             $criteria-&gt;condition=$condition;
<span class="ln">629</span> 
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#1			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\limesurvey\framework\db\ar\CActiveRecord.php(1493): <strong>CDbCommandBuilder</strong>-><strong>createPkCriteria</strong>(CMssqlTableSchema, array(&quot;16&quot;), &quot;&quot;, array(), ...)				</div>

				<div class="code"><pre><span class="ln">1488</span>      */
<span class="ln">1489</span>     public function findByPk($pk,$condition=&#039;&#039;,$params=array())
<span class="ln">1490</span>     {
<span class="ln">1491</span>         Yii::trace(get_class($this).&#039;.findByPk()&#039;,&#039;system.db.ar.CActiveRecord&#039;);
<span class="ln">1492</span>         $prefix=$this-&gt;getTableAlias(true).&#039;.&#039;;
<span class="error"><span class="ln error-ln">1493</span>         $criteria=$this-&gt;getCommandBuilder()-&gt;createPkCriteria($this-&gt;getTableSchema(),$pk,$condition,$params,$prefix);
</span><span class="ln">1494</span>         return $this-&gt;query($criteria);
<span class="ln">1495</span>     }
<span class="ln">1496</span> 
<span class="ln">1497</span>     /**
<span class="ln">1498</span>      * Finds all active records with the specified primary keys.
</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;E:\WebSite\limesurvey\application\helpers\expressions\em_manager_helper.php(5607): <strong>CActiveRecord</strong>-><strong>findByPk</strong>(&quot;16&quot;)				</div>

				<div class="code"><pre><span class="ln">5602</span>                     }
<span class="ln">5603</span>                 }
<span class="ln">5604</span> 
<span class="ln">5605</span>                 if (isset($_SESSION[$this-&gt;sessid][&#039;srid&#039;]) &amp;&amp; $this-&gt;surveyOptions[&#039;active&#039;])
<span class="ln">5606</span>                 {
<span class="error"><span class="ln error-ln">5607</span>                     $oResponse = Response::model($this-&gt;sid)-&gt;findByPk($_SESSION[$this-&gt;sessid][&#039;srid&#039;]);
</span><span class="ln">5608</span>                     if (empty($oResponse)) {
<span class="ln">5609</span>                         // This can happen if admin deletes incomple response while survey is running.
<span class="ln">5610</span>                         $message = submitfailed(&#039;&#039;, $this-&gt;gT(&#039;Error on response update&#039;));
<span class="ln">5611</span>                         LimeExpressionManager::addFrontendFlashMessage(&#039;error&#039;, $message, $this-&gt;sid);
<span class="ln">5612</span>                         return;
</pre></div>			</td>
		</tr>
						<tr class="trace app expanded">
			<td class="number">
				#3			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\limesurvey\application\helpers\expressions\em_manager_helper.php(5321): <strong>LimeExpressionManager</strong>-><strong>_UpdateValuesInDatabase</strong>()				</div>

				<div class="code"><pre><span class="ln">5316</span>                             continue;
<span class="ln">5317</span>                         }
<span class="ln">5318</span>                         else
<span class="ln">5319</span>                         {
<span class="ln">5320</span>                             // display new group
<span class="error"><span class="ln error-ln">5321</span>                             $message .= $LEM-&gt;_UpdateValuesInDatabase();
</span><span class="ln">5322</span>                             $LEM-&gt;runtimeTimings[] = array(__METHOD__,(microtime(true) - $now));
<span class="ln">5323</span>                             $LEM-&gt;lastMoveResult = array(
<span class="ln">5324</span>                                 &#039;finished&#039;=&gt;false,
<span class="ln">5325</span>                                 &#039;message&#039;=&gt;$message,
<span class="ln">5326</span>                                 &#039;gseq&#039;=&gt;$LEM-&gt;currentGroupSeq,
</pre></div>			</td>
		</tr>
						<tr class="trace app expanded">
			<td class="number">
				#4			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\limesurvey\application\helpers\SurveyRuntimeHelper.php(828): <strong>LimeExpressionManager</strong>::<strong>NavigateForwards</strong>()				</div>

				<div class="code"><pre><span class="ln">823</span>                     $this-&gt;aMoveResult = false; // so display welcome page again
<span class="ln">824</span>                 }
<span class="ln">825</span>             }
<span class="ln">826</span> 
<span class="ln">827</span>             if ($this-&gt;sMove == &quot;movenext&quot;) {
<span class="error"><span class="ln error-ln">828</span>                 $this-&gt;aMoveResult = LimeExpressionManager::NavigateForwards();
</span><span class="ln">829</span>             }
<span class="ln">830</span> 
<span class="ln">831</span>             if (($this-&gt;sMove == &#039;movesubmit&#039;)) {
<span class="ln">832</span>                 if ($this-&gt;sSurveyMode == &#039;survey&#039;) {
<span class="ln">833</span>                     $this-&gt;aMoveResult = LimeExpressionManager::NavigateForwards();
</pre></div>			</td>
		</tr>
						<tr class="trace app collapsed">
			<td class="number">
				#5			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\limesurvey\application\helpers\SurveyRuntimeHelper.php(531): <strong>SurveyRuntimeHelper</strong>-><strong>setMoveResult</strong>()				</div>

				<div class="code"><pre><span class="ln">526</span>         $this-&gt;initFirstStep(); // If it&#039;s the first time user load this survey, will init session and LEM
<span class="ln">527</span>         $this-&gt;initTotalAndMaxSteps();
<span class="ln">528</span>         $this-&gt;checkIfUseBrowserNav(); // Check if user used browser navigation, or relaoded page
<span class="ln">529</span>         if ($this-&gt;sMove != &#039;clearcancel&#039; &amp;&amp; $this-&gt;sMove != &#039;confirmquota&#039;) {
<span class="ln">530</span>             $this-&gt;checkPrevStep(); // Check if prev step is set, else set it
<span class="error"><span class="ln error-ln">531</span>             $this-&gt;setMoveResult();
</span><span class="ln">532</span>             $this-&gt;checkClearCancel();
<span class="ln">533</span>             $this-&gt;setPrevStep();
<span class="ln">534</span>             $this-&gt;checkIfFinished();
<span class="ln">535</span>             $this-&gt;setStep();
<span class="ln">536</span> 
</pre></div>			</td>
		</tr>
						<tr class="trace app collapsed">
			<td class="number">
				#6			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\limesurvey\application\helpers\SurveyRuntimeHelper.php(104): <strong>SurveyRuntimeHelper</strong>-><strong>initMove</strong>()				</div>

				<div class="code"><pre><span class="ln">099</span>         if (!isset($_SESSION[$this-&gt;LEMsessid][&#039;step&#039;])) {
<span class="ln">100</span>             $this-&gt;showTokenOrCaptchaFormsIfNeeded();
<span class="ln">101</span>         }
<span class="ln">102</span> 
<span class="ln">103</span>         if (!$this-&gt;previewgrp &amp;&amp; !$this-&gt;previewquestion) {
<span class="error"><span class="ln error-ln">104</span>             $this-&gt;initMove(); // main methods to init session, LEM, moves, errors, etc
</span><span class="ln">105</span>             $this-&gt;checkForDataSecurityAccepted(); // must be called after initMove to allow LEM to be initialized
<span class="ln">106</span>             $this-&gt;checkQuotas(); // check quotas (then the process will stop here)
<span class="ln">107</span>             $this-&gt;displayFirstPageIfNeeded();
<span class="ln">108</span>             $this-&gt;saveAllIfNeeded();
<span class="ln">109</span>             $this-&gt;saveSubmitIfNeeded();
</pre></div>			</td>
		</tr>
						<tr class="trace app collapsed">
			<td class="number">
				#7			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\limesurvey\application\controllers\survey\index.php(595): <strong>SurveyRuntimeHelper</strong>-><strong>run</strong>(&quot;148366&quot;, array(&quot;surveyid&quot; =&gt; &quot;148366&quot;, &quot;thissurvey&quot; =&gt; array(&quot;htmlemail&quot; =&gt; &quot;Y&quot;, &quot;format&quot; =&gt; &quot;G&quot;, &quot;template&quot; =&gt; &quot;oecd&quot;, &quot;language&quot; =&gt; &quot;en&quot;, ...), &quot;thisstep&quot; =&gt; &quot;1&quot;, &quot;tokensexist&quot; =&gt; 0, ...))				</div>

				<div class="code"><pre><span class="ln">590</span>         unset($redata);
<span class="ln">591</span>         $redata = compact(array_keys(get_defined_vars()));
<span class="ln">592</span>         Yii::import(&#039;application.helpers.SurveyRuntimeHelper&#039;);
<span class="ln">593</span>         $tmp = new SurveyRuntimeHelper();
<span class="ln">594</span>         // try {
<span class="error"><span class="ln error-ln">595</span>             $tmp-&gt;run($surveyid, $redata);
</span><span class="ln">596</span>         // } catch (WrongTemplateVersionException $ex) {
<span class="ln">597</span>         //     echo $ex-&gt;getMessage();
<span class="ln">598</span>         // }
<span class="ln">599</span>     }
<span class="ln">600</span> 
</pre></div>			</td>
		</tr>
						<tr class="trace app collapsed">
			<td class="number">
				#8			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\limesurvey\application\controllers\survey\index.php(24): <strong>index</strong>-><strong>action</strong>()				</div>

				<div class="code"><pre><span class="ln">19</span>     public $oTemplate;
<span class="ln">20</span> 
<span class="ln">21</span>     public function run()
<span class="ln">22</span>     {
<span class="ln">23</span>         useFirebug();
<span class="error"><span class="ln error-ln">24</span>         $this-&gt;action();
</span><span class="ln">25</span>     }
<span class="ln">26</span> 
<span class="ln">27</span>     public function action()
<span class="ln">28</span>     {
<span class="ln">29</span>         global $surveyid;
</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;E:\WebSite\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">
				#10			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\limesurvey\framework\web\CController.php(308): <strong>CAction</strong>-><strong>runWithParams</strong>(array(&quot;r&quot; =&gt; &quot;survey/index&quot;, &quot;sid&quot; =&gt; &quot;148366&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">
				#11			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\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">
				#12			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\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">
				#13			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\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">
				#14			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\limesurvey\framework\web\CWebApplication.php(141): <strong>CWebApplication</strong>-><strong>runController</strong>(&quot;survey/index&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">
				#15			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\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">
				#16			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\limesurvey\index.php(194): <strong>CApplication</strong>-><strong>run</strong>()				</div>

				<div class="code"><pre><span class="ln">189</span> require_once APPPATH . &#039;core/LSYii_Application&#039; . EXT;
<span class="ln">190</span> 
<span class="ln">191</span> $config = require_once(APPPATH . &#039;config/internal&#039; . EXT);
<span class="ln">192</span> 
<span class="ln">193</span> Yii::$enableIncludePath = false;
<span class="error"><span class="ln error-ln">194</span> Yii::createApplication(&#039;LSYii_Application&#039;, $config)-&gt;run();
</span><span class="ln">195</span> 
<span class="ln">196</span> /* End of file index.php */
<span class="ln">197</span> /* Location: ./index.php */
</pre></div>			</td>
		</tr>
				</table>
	</div>

	<div class="version">
		2021-03-26 11:26:56 Microsoft-IIS/10.0 <a href="http://www.yiiframework.com/">Yii Framework</a>/1.1.22-dev	</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>
CDbException.html (27,098 bytes)   
Bug heat2
Complete LimeSurvey version number (& build)3.25.15
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionmssql ?
Server OS (if known)Windows Server
Webserver software & version (if known)IIS
PHP Versionphp7.4

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2021-03-27 12:39

developer   ~63662

https://github.com/LimeSurvey/LimeSurvey/pull/1825
DenisChenu

DenisChenu

2021-04-03 23:08

developer   ~63792

Fix committed to 3.x-LTS branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=31472

Related Changesets

LimeSurvey: 3.x-LTS b9555efe

2021-04-03 23:08:52

DenisChenu


Committer: GitHub Details Diff 		Fixed issue 17208: avoid column name must be either a string or an array during survey taking (#1825)

Dev: some response table can have broken primaryKey, avoid public DB issue		 Affected Issues
17208
mod - application/models/Response.php Diff File

Issue History

Date Modified Username Field Change
2021-03-26 15:12 DenisChenu New Issue
2021-03-26 15:12 DenisChenu File Added: CDbException.html
2021-03-27 12:26 DenisChenu Assigned To => DenisChenu
2021-03-27 12:26 DenisChenu Status new => assigned
2021-03-27 12:39 DenisChenu Assigned To DenisChenu =>
2021-03-27 12:39 DenisChenu Status assigned => ready for testing
2021-03-27 12:39 DenisChenu Note Added: 63662
2021-04-03 23:08 DenisChenu Changeset attached => LimeSurvey 3.x-LTS b9555efe
2021-04-03 23:08 DenisChenu Note Added: 63792
2021-04-03 23:08 DenisChenu Assigned To => DenisChenu
2021-04-03 23:08 DenisChenu Resolution open => fixed
2021-04-05 09:48 DenisChenu Status ready for testing => resolved
2021-04-05 09:48 DenisChenu Fixed in Version => 3.25.20
2021-07-12 11:54 c_schmitz Status resolved => closed