View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
14996Bug reportsTheme editorpublic2019-06-19 15:212020-03-06 00:52
ReporterDenisChenu Assigned Toc_schmitz  
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Product Version3.17.x 
Fixed in Version3.22.7 
Summary14996: MSSQL issue when try to move to 2nd page of theme list : The multi-part identifier "t.template_name" could not be bound.
Description

When move to 2nd page of theme list : receive a 500 error.
Seems because MSSQL error maybe [t].[template_name] = [template.name] ?

Steps To Reproduce

Find a MSSQL server
Add more than 10 theme
Try to move to 2nd page

TagsNo tags attached.
Attached Files
CDbException.html (45,593 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">
		CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: 
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]The multi-part 
identifier "t.template_name" could not be bound.. The SQL statement 
executed was: SELECT * FROM (SELECT TOP 10 * FROM (SELECT TOP 20 
[t].[id], [t].[template_name], [t].[sid], [t].[gsid], [t].[uid], 
[t].[files_css], [t].[files_js], [t].[files_print_css], [t].[options], 
[t].[cssframework_name], [t].[cssframework_css], [t].[cssframework_js], 
[t].[packages_to_load], [t].[packages_ltr], [t].[packages_rtl] FROM 
[dbo].[lime_template_configuration] [t] INNER JOIN lime_templates AS 
template ON t.template_name = template.name WHERE ((t.sid IS NULL) AND 
(t.gsid IS NULL)) AND (template.name IS NOT NULL) ORDER BY 
t.template_name) as [__inner__] ORDER BY t.template_name DESC) as 
[__outer__] ORDER BY t.template_name ASC	</p>

	<div class="source">
		<p class="file">E:\WebSite\limesurvey\framework\db\CDbCommand.php(543)</p>
		<div class="code"><pre><span class="ln">531</span>         {
<span class="ln">532</span>             if($this-&gt;_connection-&gt;enableProfiling)
<span class="ln">533</span>                 Yii::endProfile('system.db.CDbCommand.query('.$this-&gt;getText().$par.')','system.db.CDbCommand.query');
<span class="ln">534</span> 
<span class="ln">535</span>             $errorInfo=$e instanceof PDOException ? $e-&gt;errorInfo : null;
<span class="ln">536</span>             $message=$e-&gt;getMessage();
<span class="ln">537</span>             Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',
<span class="ln">538</span>                 array('{method}'=&gt;$method, '{error}'=&gt;$message, '{sql}'=&gt;$this-&gt;getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
<span class="ln">539</span> 
<span class="ln">540</span>             if(YII_DEBUG)
<span class="ln">541</span>                 $message.='. The SQL statement executed was: '.$this-&gt;getText().$par;
<span class="ln">542</span> 
<span class="error"><span class="ln error-ln">543</span>             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
</span><span class="ln">544</span>                 array('{error}'=&gt;$message)),(int)$e-&gt;getCode(),$errorInfo);
<span class="ln">545</span>         }
<span class="ln">546</span>     }
<span class="ln">547</span> 
<span class="ln">548</span>     /**
<span class="ln">549</span>      * Builds a SQL SELECT statement from the given query specification.
<span class="ln">550</span>      * @param array $query the query specification in name-value pairs. The following
<span class="ln">551</span>      * query options are supported: {@link select}, {@link distinct}, {@link from},
<span class="ln">552</span>      * {@link where}, {@link join}, {@link group}, {@link having}, {@link order},
<span class="ln">553</span>      * {@link limit}, {@link offset} and {@link union}.
<span class="ln">554</span>      * @throws CDbException if "from" key is not present in given query parameter
<span class="ln">555</span>      * @return string the SQL statement
</pre></div>	</div>

	<div class="traces">
		<h2>Stack Trace</h2>
				<table style="width:100%;">
						<tbody><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\CDbCommand.php(396): <strong>CDbCommand</strong>-&gt;<strong>queryInternal</strong>("fetchAll", array(2), array())				</div>

				<div class="code"><pre><span class="ln">391</span>      * An empty array is returned if the query results in nothing.
<span class="ln">392</span>      * @throws CException execution failed
<span class="ln">393</span>      */
<span class="ln">394</span>     public function queryAll($fetchAssociative=true,$params=array())
<span class="ln">395</span>     {
<span class="error"><span class="ln error-ln">396</span>         return $this-&gt;queryInternal('fetchAll',$fetchAssociative ? $this-&gt;_fetchMode : PDO::FETCH_NUM, $params);
</span><span class="ln">397</span>     }
<span class="ln">398</span> 
<span class="ln">399</span>     /**
<span class="ln">400</span>      * Executes the SQL statement and returns the first row of the result.
<span class="ln">401</span>      * This is a convenient method of {@link query} when only the first row of data is needed.
</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(1359): <strong>CDbCommand</strong>-&gt;<strong>queryAll</strong>()				</div>

				<div class="code"><pre><span class="ln">1354</span>         if(empty($criteria-&gt;with))
<span class="ln">1355</span>         {
<span class="ln">1356</span>             if(!$all)
<span class="ln">1357</span>                 $criteria-&gt;limit=1;
<span class="ln">1358</span>             $command=$this-&gt;getCommandBuilder()-&gt;createFindCommand($this-&gt;getTableSchema(),$criteria);
<span class="error"><span class="ln error-ln">1359</span>             return $all ? $this-&gt;populateRecords($command-&gt;queryAll(), true, $criteria-&gt;index) : $this-&gt;populateRecord($command-&gt;queryRow());
</span><span class="ln">1360</span>         }
<span class="ln">1361</span>         else
<span class="ln">1362</span>         {
<span class="ln">1363</span>             $finder=$this-&gt;getActiveFinder($criteria-&gt;with);
<span class="ln">1364</span>             return $finder-&gt;query($criteria,$all);
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#2			</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(1478): <strong>CActiveRecord</strong>-&gt;<strong>query</strong>(CDbCriteria, true)				</div>

				<div class="code"><pre><span class="ln">1473</span>      */
<span class="ln">1474</span>     public function findAll($condition='',$params=array())
<span class="ln">1475</span>     {
<span class="ln">1476</span>         Yii::trace(get_class($this).'.findAll()','system.db.ar.CActiveRecord');
<span class="ln">1477</span>         $criteria=$this-&gt;getCommandBuilder()-&gt;createCriteria($condition,$params);
<span class="error"><span class="ln error-ln">1478</span>         return $this-&gt;query($criteria,true);
</span><span class="ln">1479</span>     }
<span class="ln">1480</span> 
<span class="ln">1481</span>     /**
<span class="ln">1482</span>      * Finds a single active record with the specified primary key.
<span class="ln">1483</span>      * See {@link find()} for detailed explanation about $condition and $params.
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#3			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\limesurvey\framework\web\CActiveDataProvider.php(199): <strong>CActiveRecord</strong>-&gt;<strong>findAll</strong>(CDbCriteria)				</div>

				<div class="code"><pre><span class="ln">194</span>                 $this-&gt;model-&gt;setDbCriteria($criteria);
<span class="ln">195</span>             $sort-&gt;applyOrder($criteria);
<span class="ln">196</span>         }
<span class="ln">197</span> 
<span class="ln">198</span>         $this-&gt;model-&gt;setDbCriteria($baseCriteria!==null ? clone $baseCriteria : null);
<span class="error"><span class="ln error-ln">199</span>         $data=$this-&gt;model-&gt;findAll($criteria);
</span><span class="ln">200</span>         $this-&gt;model-&gt;setDbCriteria($baseCriteria);  // restore original criteria
<span class="ln">201</span>         return $data;
<span class="ln">202</span>     }
<span class="ln">203</span> 
<span class="ln">204</span>     /**
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#4			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\limesurvey\framework\web\CDataProvider.php(168): <strong>CActiveDataProvider</strong>-&gt;<strong>fetchData</strong>()				</div>

				<div class="code"><pre><span class="ln">163</span>      * @return array the list of data items currently available in this data provider.
<span class="ln">164</span>      */
<span class="ln">165</span>     public function getData($refresh=false)
<span class="ln">166</span>     {
<span class="ln">167</span>         if($this-&gt;_data===null || $refresh)
<span class="error"><span class="ln error-ln">168</span>             $this-&gt;_data=$this-&gt;fetchData();
</span><span class="ln">169</span>         return $this-&gt;_data;
<span class="ln">170</span>     }
<span class="ln">171</span> 
<span class="ln">172</span>     /**
<span class="ln">173</span>      * Sets the data items for this provider.
</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;E:\WebSite\limesurvey\framework\zii\widgets\CBaseListView.php(125): <strong>CDataProvider</strong>-&gt;<strong>getData</strong>()				</div>

				<div class="code"><pre><span class="ln">120</span>     public function init()
<span class="ln">121</span>     {
<span class="ln">122</span>         if($this-&gt;dataProvider===null)
<span class="ln">123</span>             throw new CException(Yii::t('zii','The "dataProvider" property cannot be empty.'));
<span class="ln">124</span> 
<span class="error"><span class="ln error-ln">125</span>         $this-&gt;dataProvider-&gt;getData();
</span><span class="ln">126</span> 
<span class="ln">127</span>         if(isset($this-&gt;htmlOptions['id']))
<span class="ln">128</span>             $this-&gt;id=$this-&gt;htmlOptions['id'];
<span class="ln">129</span>         else
<span class="ln">130</span>             $this-&gt;htmlOptions['id']=$this-&gt;id;
</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;E:\WebSite\limesurvey\framework\zii\widgets\grid\CGridView.php(339): <strong>CBaseListView</strong>-&gt;<strong>init</strong>()				</div>

				<div class="code"><pre><span class="ln">334</span>      * Initializes the grid view.
<span class="ln">335</span>      * This method will initialize required property values and instantiate {@link columns} objects.
<span class="ln">336</span>      */
<span class="ln">337</span>     public function init()
<span class="ln">338</span>     {
<span class="error"><span class="ln error-ln">339</span>         parent::init();
</span><span class="ln">340</span> 
<span class="ln">341</span>         if(empty($this-&gt;updateSelector))
<span class="ln">342</span>             throw new CException(Yii::t('zii','The property updateSelector should be defined.'));
<span class="ln">343</span>         if(empty($this-&gt;filterSelector))
<span class="ln">344</span>             throw new CException(Yii::t('zii','The property filterSelector should be defined.'));
</pre></div>			</td>
		</tr>
						<tr class="trace app expanded">
			<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\extensions\bootstrap\widgets\TbGridView.php(44): <strong>CGridView</strong>-&gt;<strong>init</strong>()				</div>

				<div class="code"><pre><span class="ln">39</span>     /**
<span class="ln">40</span>      * Initializes the widget.
<span class="ln">41</span>      */
<span class="ln">42</span>     public function init()
<span class="ln">43</span>     {
<span class="error"><span class="ln error-ln">44</span>         parent::init();
</span><span class="ln">45</span>         $classes = array('table');
<span class="ln">46</span>         if (isset($this-&gt;type) &amp;&amp; !empty($this-&gt;type)) {
<span class="ln">47</span>             if (is_string($this-&gt;type)) {
<span class="ln">48</span>                 $this-&gt;type = explode(' ', $this-&gt;type);
<span class="ln">49</span>             }
</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;E:\WebSite\limesurvey\framework\web\CBaseController.php(147): <strong>TbGridView</strong>-&gt;<strong>init</strong>()				</div>

				<div class="code"><pre><span class="ln">142</span>      * @return CWidget the fully initialized widget instance.
<span class="ln">143</span>      */
<span class="ln">144</span>     public function createWidget($className,$properties=array())
<span class="ln">145</span>     {
<span class="ln">146</span>         $widget=Yii::app()-&gt;getWidgetFactory()-&gt;createWidget($this,$className,$properties);
<span class="error"><span class="ln error-ln">147</span>         $widget-&gt;init();
</span><span class="ln">148</span>         return $widget;
<span class="ln">149</span>     }
<span class="ln">150</span> 
<span class="ln">151</span>     /**
<span class="ln">152</span>      * Creates a widget and executes it.
</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\CBaseController.php(181): <strong>CBaseController</strong>-&gt;<strong>createWidget</strong>("bootstrap.widgets.TbGridView",
 array("dataProvider" =&gt; CActiveDataProvider, "filter" =&gt; 
TemplateConfiguration, "id" =&gt; "themeoptions-grid", "ajaxUpdate" 
=&gt; true, ...))				</div>

				<div class="code"><pre><span class="ln">176</span>             }
<span class="ln">177</span>             return ob_get_clean();
<span class="ln">178</span>         }
<span class="ln">179</span>         else
<span class="ln">180</span>         {
<span class="error"><span class="ln error-ln">181</span>             $widget=$this-&gt;createWidget($className,$properties);
</span><span class="ln">182</span>             $widget-&gt;run();
<span class="ln">183</span>             return $widget;
<span class="ln">184</span>         }
<span class="ln">185</span>     }
<span class="ln">186</span> 
</pre></div>			</td>
		</tr>
						<tr class="trace app expanded">
			<td class="number">
				#10			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\limesurvey\application\views\admin\themeoptions\surveythemelist.php(6): <strong>CBaseController</strong>-&gt;<strong>widget</strong>("bootstrap.widgets.TbGridView",
 array("dataProvider" =&gt; CActiveDataProvider, "filter" =&gt; 
TemplateConfiguration, "id" =&gt; "themeoptions-grid", "ajaxUpdate" 
=&gt; true, ...))				</div>

				<div class="code"><pre><span class="ln">01</span> 
<span class="ln">02</span> &lt;div class="row"&gt;
<span class="ln">03</span>     &lt;div class="col-sm-12 content-right"&gt;
<span class="ln">04</span>         
<span class="ln">05</span>         &lt;?php $this-&gt;widget('bootstrap.widgets.TbGridView', array(
<span class="error"><span class="ln error-ln">06</span>             'dataProvider' =&gt; $oSurveyTheme-&gt;searchGrid(),
</span><span class="ln">07</span>             'filter'        =&gt; $oSurveyTheme,
<span class="ln">08</span>             'id'            =&gt; 'themeoptions-grid',
<span class="ln">09</span>             'ajaxUpdate'    =&gt; true,
<span class="ln">10</span>             'ajaxType'      =&gt; 'POST',
<span class="ln">11</span>             'summaryText'=&gt;gT('Displaying {start}-{end} of {count} result(s).').' '. sprintf(gT('%s rows per page'),
</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\CBaseController.php(126): <strong>require</strong>("E:\WebSite\limesurvey\application\views\admin\themeoptions\surve...")				</div>

				<div class="code"><pre><span class="ln">121</span>             $data=$_data_;
<span class="ln">122</span>         if($_return_)
<span class="ln">123</span>         {
<span class="ln">124</span>             ob_start();
<span class="ln">125</span>             ob_implicit_flush(false);
<span class="error"><span class="ln error-ln">126</span>             require($_viewFile_);
</span><span class="ln">127</span>             return ob_get_clean();
<span class="ln">128</span>         }
<span class="ln">129</span>         else
<span class="ln">130</span>             require($_viewFile_);
<span class="ln">131</span>     }
</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\CBaseController.php(95): <strong>CBaseController</strong>-&gt;<strong>renderInternal</strong>("E:\WebSite\limesurvey\application\views\admin\themeoptions/surve...",
 array("oSurveyTheme" =&gt; TemplateConfiguration, "pageSize" =&gt; 10),
 true)				</div>

				<div class="code"><pre><span class="ln">090</span>     {
<span class="ln">091</span>         $widgetCount=count($this-&gt;_widgetStack);
<span class="ln">092</span>         if(($renderer=Yii::app()-&gt;getViewRenderer())!==null &amp;&amp; $renderer-&gt;fileExtension==='.'.CFileHelper::getExtension($viewFile))
<span class="ln">093</span>             $content=$renderer-&gt;renderFile($this,$viewFile,$data,$return);
<span class="ln">094</span>         else
<span class="error"><span class="ln error-ln">095</span>             $content=$this-&gt;renderInternal($viewFile,$data,$return);
</span><span class="ln">096</span>         if(count($this-&gt;_widgetStack)===$widgetCount)
<span class="ln">097</span>             return $content;
<span class="ln">098</span>         else
<span class="ln">099</span>         {
<span class="ln">100</span>             $widget=end($this-&gt;_widgetStack);
</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\CController.php(872): <strong>CBaseController</strong>-&gt;<strong>renderFile</strong>("E:\WebSite\limesurvey\application\views\admin\themeoptions/surve...",
 array("oSurveyTheme" =&gt; TemplateConfiguration, "pageSize" =&gt; 10),
 true)				</div>

				<div class="code"><pre><span class="ln">867</span>      */
<span class="ln">868</span>     public function renderPartial($view,$data=null,$return=false,$processOutput=false)
<span class="ln">869</span>     {
<span class="ln">870</span>         if(($viewFile=$this-&gt;getViewFile($view))!==false)
<span class="ln">871</span>         {
<span class="error"><span class="ln error-ln">872</span>             $output=$this-&gt;renderFile($viewFile,$data,true);
</span><span class="ln">873</span>             if($processOutput)
<span class="ln">874</span>                 $output=$this-&gt;processOutput($output);
<span class="ln">875</span>             if($return)
<span class="ln">876</span>                 return $output;
<span class="ln">877</span>             else
</pre></div>			</td>
		</tr>
						<tr class="trace app expanded">
			<td class="number">
				#14			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\limesurvey\application\views\admin\themeoptions\index.php(36): <strong>CController</strong>-&gt;<strong>renderPartial</strong>("themeoptions/surveythemelist", array("oSurveyTheme" =&gt; TemplateConfiguration, "pageSize" =&gt; 10))				</div>

				<div class="code"><pre><span class="ln">31</span>             &lt;div class="col-lg-12 list-surveys"&gt;
<span class="ln">32</span> 
<span class="ln">33</span>                 &lt;?php echo '&lt;h3&gt;'.gT('Installed survey themes:').'&lt;/h3&gt;'; ?&gt;
<span class="ln">34</span> 
<span class="ln">35</span>                 &lt;?php $this-&gt;renderPartial('themeoptions/surveythememenu',['canImport'=&gt;$canImport,'importErrorMessage'=&gt;$importErrorMessage]); ?&gt;
<span class="error"><span class="ln error-ln">36</span>                 &lt;?php $this-&gt;renderPartial('themeoptions/surveythemelist', array( 'oSurveyTheme'=&gt; $oSurveyTheme, 'pageSize'=&gt;$pageSize )); ?&gt;
</span><span class="ln">37</span> 
<span class="ln">38</span>                 &lt;!-- Available Themes --&gt;
<span class="ln">39</span>                 &lt;?php if (count($oSurveyTheme-&gt;templatesWithNoDb) &gt; 0 ):?&gt;
<span class="ln">40</span>                     &lt;h3&gt;&lt;?php eT('Available survey themes:'); ?&gt;&lt;/h3&gt;
<span class="ln">41</span>                     &lt;div class="row"&gt;
</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\web\CBaseController.php(126): <strong>require</strong>("E:\WebSite\limesurvey\application\views\admin\themeoptions\index...")				</div>

				<div class="code"><pre><span class="ln">121</span>             $data=$_data_;
<span class="ln">122</span>         if($_return_)
<span class="ln">123</span>         {
<span class="ln">124</span>             ob_start();
<span class="ln">125</span>             ob_implicit_flush(false);
<span class="error"><span class="ln error-ln">126</span>             require($_viewFile_);
</span><span class="ln">127</span>             return ob_get_clean();
<span class="ln">128</span>         }
<span class="ln">129</span>         else
<span class="ln">130</span>             require($_viewFile_);
<span class="ln">131</span>     }
</pre></div>			</td>
		</tr>
						<tr class="trace core 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\framework\web\CBaseController.php(95): <strong>CBaseController</strong>-&gt;<strong>renderInternal</strong>("E:\WebSite\limesurvey\application\views/admin/themeoptions/index...",
 array("oAdminTheme" =&gt; AdminTheme, "oSurveyTheme" =&gt; 
TemplateConfiguration, "canImport" =&gt; true, "importErrorMessage" 
=&gt; null, ...), true)				</div>

				<div class="code"><pre><span class="ln">090</span>     {
<span class="ln">091</span>         $widgetCount=count($this-&gt;_widgetStack);
<span class="ln">092</span>         if(($renderer=Yii::app()-&gt;getViewRenderer())!==null &amp;&amp; $renderer-&gt;fileExtension==='.'.CFileHelper::getExtension($viewFile))
<span class="ln">093</span>             $content=$renderer-&gt;renderFile($this,$viewFile,$data,$return);
<span class="ln">094</span>         else
<span class="error"><span class="ln error-ln">095</span>             $content=$this-&gt;renderInternal($viewFile,$data,$return);
</span><span class="ln">096</span>         if(count($this-&gt;_widgetStack)===$widgetCount)
<span class="ln">097</span>             return $content;
<span class="ln">098</span>         else
<span class="ln">099</span>         {
<span class="ln">100</span>             $widget=end($this-&gt;_widgetStack);
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#17			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\limesurvey\framework\web\CController.php(872): <strong>CBaseController</strong>-&gt;<strong>renderFile</strong>("E:\WebSite\limesurvey\application\views/admin/themeoptions/index...",
 array("oAdminTheme" =&gt; AdminTheme, "oSurveyTheme" =&gt; 
TemplateConfiguration, "canImport" =&gt; true, "importErrorMessage" 
=&gt; null, ...), true)				</div>

				<div class="code"><pre><span class="ln">867</span>      */
<span class="ln">868</span>     public function renderPartial($view,$data=null,$return=false,$processOutput=false)
<span class="ln">869</span>     {
<span class="ln">870</span>         if(($viewFile=$this-&gt;getViewFile($view))!==false)
<span class="ln">871</span>         {
<span class="error"><span class="ln error-ln">872</span>             $output=$this-&gt;renderFile($viewFile,$data,true);
</span><span class="ln">873</span>             if($processOutput)
<span class="ln">874</span>                 $output=$this-&gt;processOutput($output);
<span class="ln">875</span>             if($return)
<span class="ln">876</span>                 return $output;
<span class="ln">877</span>             else
</pre></div>			</td>
		</tr>
						<tr class="trace app collapsed">
			<td class="number">
				#18			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\limesurvey\application\core\Survey_Common_Action.php(267): <strong>CController</strong>-&gt;<strong>renderPartial</strong>("/admin/themeoptions/index",
 array("oAdminTheme" =&gt; AdminTheme, "oSurveyTheme" =&gt; 
TemplateConfiguration, "canImport" =&gt; true, "importErrorMessage" 
=&gt; null, ...), true)				</div>

				<div class="code"><pre><span class="ln">262</span>         // Load views
<span class="ln">263</span>         $content = "";
<span class="ln">264</span>         foreach ($aViewUrls as $sViewKey =&gt; $viewUrl) {
<span class="ln">265</span>             if (empty($sViewKey) || !in_array($sViewKey, array('message', 'output'))) {
<span class="ln">266</span>                 if (is_numeric($sViewKey)) {
<span class="error"><span class="ln error-ln">267</span>                     $content .= Yii::app()-&gt;getController()-&gt;renderPartial($sViewPath.$viewUrl, $aData, true);
</span><span class="ln">268</span>                 } elseif (is_array($viewUrl)) {
<span class="ln">269</span>                     foreach ($viewUrl as $aSubData) {
<span class="ln">270</span>                         $aSubData = array_merge($aData, $aSubData);
<span class="ln">271</span>                         $content .= Yii::app()-&gt;getController()-&gt;renderPartial($sViewPath.$sViewKey, $aSubData, true);
<span class="ln">272</span>                     }
</pre></div>			</td>
		</tr>
						<tr class="trace app collapsed">
			<td class="number">
				#19			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\limesurvey\application\core\Survey_Common_Action.php(345): <strong>Survey_Common_Action</strong>-&gt;<strong>renderCentralContents</strong>("themeoptions",
 array("index"), array("oAdminTheme" =&gt; AdminTheme, "oSurveyTheme" 
=&gt; TemplateConfiguration, "canImport" =&gt; true, 
"importErrorMessage" =&gt; null, ...))				</div>

				<div class="code"><pre><span class="ln">340</span>             }
<span class="ln">341</span>         } else {
<span class="ln">342</span>             $renderFile = $basePath.'/'.$sRenderFile;
<span class="ln">343</span>         }
<span class="ln">344</span> 
<span class="error"><span class="ln error-ln">345</span>         $content = $this-&gt;renderCentralContents($sAction, $aViewUrls, $aData);
</span><span class="ln">346</span>         $out = $this-&gt;renderInternal($renderFile, ['content' =&gt; $content, 'aData' =&gt; $aData], true);
<span class="ln">347</span> 
<span class="ln">348</span>         App()-&gt;getClientScript()-&gt;render($out);
<span class="ln">349</span>         echo $out;
<span class="ln">350</span>     }
</pre></div>			</td>
		</tr>
						<tr class="trace app collapsed">
			<td class="number">
				#20			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\limesurvey\application\controllers\admin\themeoptions.php(216): <strong>Survey_Common_Action</strong>-&gt;<strong>_renderWrappedTemplate</strong>("themeoptions",
 "index", array("oAdminTheme" =&gt; AdminTheme, "oSurveyTheme" =&gt; 
TemplateConfiguration, "canImport" =&gt; true, "importErrorMessage" 
=&gt; null, ...))				</div>

				<div class="code"><pre><span class="ln">211</span>             $aData['oSurveyTheme'] = $oSurveyTheme;
<span class="ln">212</span>             $aData['canImport']  = $canImport;
<span class="ln">213</span>             $aData['importErrorMessage']  = $importErrorMessage;
<span class="ln">214</span>             $aData['pageSize'] = Yii::app()-&gt;user-&gt;getState('pageSizeTemplateView', Yii::app()-&gt;params['defaultPageSize']); // Page size
<span class="ln">215</span> 
<span class="error"><span class="ln error-ln">216</span>             $this-&gt;_renderWrappedTemplate('themeoptions', 'index', $aData);
</span><span class="ln">217</span>         } else {
<span class="ln">218</span>             Yii::app()-&gt;setFlashMessage(gT("We are sorry but you don't have permissions to do this."), 'error');
<span class="ln">219</span>             $this-&gt;getController()-&gt;redirect(App()-&gt;createUrl("/admin"));
<span class="ln">220</span>         }
<span class="ln">221</span>     }
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#21			</td>
			<td class="content">
				<div class="trace-file">
										&nbsp;unknown(0): <strong>themeoptions</strong>-&gt;<strong>index</strong>()				</div>

							</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#22			</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(109): <strong>ReflectionMethod</strong>-&gt;<strong>invokeArgs</strong>(themeoptions, array())				</div>

				<div class="code"><pre><span class="ln">104</span>             elseif($param-&gt;isDefaultValueAvailable())
<span class="ln">105</span>                 $ps[]=$param-&gt;getDefaultValue();
<span class="ln">106</span>             else
<span class="ln">107</span>                 return false;
<span class="ln">108</span>         }
<span class="error"><span class="ln error-ln">109</span>         $method-&gt;invokeArgs($object,$ps);
</span><span class="ln">110</span>         return true;
<span class="ln">111</span>     }
<span class="ln">112</span> }
</pre></div>			</td>
		</tr>
						<tr class="trace app collapsed">
			<td class="number">
				#23			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\limesurvey\application\core\Survey_Common_Action.php(83): <strong>CAction</strong>-&gt;<strong>runWithParamsInternal</strong>(themeoptions, ReflectionMethod, array("r" =&gt; "admin/themeoptions", "TemplateConfiguration_page" =&gt; "2"))				</div>

				<div class="code"><pre><span class="ln">78</span>             $oMethod = new ReflectionMethod($this, $sDefault);
<span class="ln">79</span>         }
<span class="ln">80</span> 
<span class="ln">81</span>         // We're all good to go, let's execute it
<span class="ln">82</span>         // runWithParamsInternal would automatically get the parameters of the method and populate them as required with the params
<span class="error"><span class="ln error-ln">83</span>         return parent::runWithParamsInternal($this, $oMethod, $params);
</span><span class="ln">84</span>     }
<span class="ln">85</span> 
<span class="ln">86</span>     /**
<span class="ln">87</span>      * Some functions have different parameters, which are just an alias of the
<span class="ln">88</span>      * usual parameters we're getting in the url. This function just populates
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#24			</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>Survey_Common_Action</strong>-&gt;<strong>runWithParams</strong>(array("r" =&gt; "admin/themeoptions", "TemplateConfiguration_page" =&gt; "2"))				</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">
				#25			</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>-&gt;<strong>runAction</strong>(themeoptions)				</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">
				#26			</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>-&gt;<strong>runActionWithFilters</strong>(themeoptions, 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 app collapsed">
			<td class="number">
				#27			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;E:\WebSite\limesurvey\application\controllers\AdminController.php(158): <strong>CController</strong>-&gt;<strong>run</strong>("themeoptions")				</div>

				<div class="code"><pre><span class="ln">153</span>                     $this-&gt;redirect(array('/admin/authentication/sa/login'));
<span class="ln">154</span>                 }
<span class="ln">155</span>             }
<span class="ln">156</span>         }
<span class="ln">157</span> 
<span class="error"><span class="ln error-ln">158</span>         return parent::run($action);
</span><span class="ln">159</span>     }
<span class="ln">160</span> 
<span class="ln">161</span>     /**
<span class="ln">162</span>      * Routes all the actions to their respective places
<span class="ln">163</span>      *
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#28			</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>AdminController</strong>-&gt;<strong>run</strong>("themeoptions")				</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('yii','Unable to resolve the request "{route}".',
<span class="ln">287</span>                 array('{route}'=&gt;$route===''?$this-&gt;defaultController:$route)));
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#29			</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>-&gt;<strong>runController</strong>("admin/themeoptions")				</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">
				#30			</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>-&gt;<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('onBeginRequest'))
<span class="ln">183</span>             $this-&gt;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-&gt;processRequest();
</span><span class="ln">186</span>         if($this-&gt;hasEventHandler('onEndRequest'))
<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">
				#31			</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>-&gt;<strong>run</strong>()				</div>

				<div class="code"><pre><span class="ln">189</span> require_once APPPATH . 'core/LSYii_Application' . EXT;
<span class="ln">190</span> 
<span class="ln">191</span> $config = require_once(APPPATH . 'config/internal' . 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('LSYii_Application', $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>
				</tbody></table>
	</div>

	<div class="version">
		2019-06-19 13:07:54 Microsoft-IIS/10.0 <a href="http://www.yiiframework.com/">Yii Framework</a>/1.1.21	</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 (45,593 bytes)   
Bug heat2
Complete LimeSurvey version number (& build)3.17.5 github
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionMS SQL Server 2012
Server OS (if known)windows
Webserver software & version (if known)IIS
PHP VersionPHP7

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2019-06-19 15:21

developer   ~52463

Oh no …

ORDER BY t.template_name) as [__inner__] ORDER BY t.template_name DESC) as [__outer__] ORDER BY t.template_name ASC ????

Issue History

Date Modified Username Field Change
2019-06-19 15:21 DenisChenu New Issue
2019-06-19 15:21 DenisChenu File Added: CDbException.html
2019-06-19 15:21 DenisChenu Note Added: 52463
2020-03-06 00:52 c_schmitz Assigned To => c_schmitz
2020-03-06 00:52 c_schmitz Status new => closed
2020-03-06 00:52 c_schmitz Resolution open => fixed
2020-03-06 00:52 c_schmitz Fixed in Version => 3.22.7