View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
06733Bug reportsSurvey takingpublic2012-10-18 14:452012-11-02 21:42
Reporterhelper Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary06733: CDbException When User Attempts to View Statistics
Description

User finishes the survey successfully and clicks on the link "View the statistics for this survey."

See attached stacktrace for details

Steps To Reproduce

User finishes the survey successfully and clicks on the link "View the statistics for this survey."

TagsNo tags attached.
Attached Files
CDbException.htm (19,637 bytes)    
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!-- saved from url=(0081)http://limedev/mssql/index.php/statistics_user/action/surveyid/954656/language/en -->
<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>
<style type="text/css"></style></head>

<body>
<div class="container">
	<h1>CDbException</h1>

	<p class="message">
		CDbCommand failed to execute the SQL statement: SQLSTATE[07002]: [Microsoft][SQL Server Native Client 11.0]COUNT field incorrect or syntax error. The SQL statement executed was: SELECT q.* , group_name, group_order FROM lime_questions q, lime_groups g, lime_question_attributes qa <br>
                    WHERE g.gid = q.gid AND g.language = :lang AND q.language = :lang AND q.sid = :surveyid AND q.qid = qa.qid AND q.parent_qid = 0 AND qa.attribute = 'public_statistics'AND CAST(CAST(qa.value as varchar) as int)='1'<br>
	</p>

	<div class="source">
		<p class="file">C:\etc\Apache\htdocs\MSSQL\framework\db\CDbCommand.php(528)</p>
		<div class="code"><pre><span class="ln">516</span>             return $result;
<span class="ln">517</span>         }
<span class="ln">518</span>         catch(Exception $e)
<span class="ln">519</span>         {
<span class="ln">520</span>             if($this-&gt;_connection-&gt;enableProfiling)
<span class="ln">521</span>                 Yii::endProfile('system.db.CDbCommand.query('.$this-&gt;getText().$par.')','system.db.CDbCommand.query');
<span class="ln">522</span>             $errorInfo = $e instanceof PDOException ? $e-&gt;errorInfo : null;
<span class="ln">523</span>             $message = $e-&gt;getMessage();
<span class="ln">524</span>             Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',
<span class="ln">525</span>                 array('{method}'=&gt;$method, '{error}'=&gt;$message, '{sql}'=&gt;$this-&gt;getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
<span class="ln">526</span>             if(YII_DEBUG)
<span class="ln">527</span>                 $message .= '. The SQL statement executed was: '.$this-&gt;getText().$par;
<span class="error"><span class="ln error-ln">528</span>             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
</span><span class="ln">529</span>                 array('{error}'=&gt;$message)),(int)$e-&gt;getCode(),$errorInfo);
<span class="ln">530</span>         }
<span class="ln">531</span>     }
<span class="ln">532</span> 
<span class="ln">533</span>     /**
<span class="ln">534</span>      * Builds a SQL SELECT statement from the given query specification.
<span class="ln">535</span>      * @param array $query the query specification in name-value pairs. The following
<span class="ln">536</span>      * query options are supported: {@link select}, {@link distinct}, {@link from},
<span class="ln">537</span>      * {@link where}, {@link join}, {@link group}, {@link having}, {@link order},
<span class="ln">538</span>      * {@link limit}, {@link offset} and {@link union}.
<span class="ln">539</span>      * @return string the SQL statement
<span class="ln">540</span>      * @since 1.1.6
</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;C:\etc\Apache\htdocs\MSSQL\framework\db\CDbCommand.php(390): <strong>CDbCommand</strong>-&gt;<strong>queryInternal</strong>("fetchAll", array(2), array())				</div>

				<div class="code"><pre><span class="ln">385</span>      * An empty array is returned if the query results in nothing.
<span class="ln">386</span>      * @throws CException execution failed
<span class="ln">387</span>      */
<span class="ln">388</span>     public function queryAll($fetchAssociative=true,$params=array())
<span class="ln">389</span>     {
<span class="error"><span class="ln error-ln">390</span>         return $this-&gt;queryInternal('fetchAll',$fetchAssociative ? $this-&gt;_fetchMode : PDO::FETCH_NUM, $params);
</span><span class="ln">391</span>     }
<span class="ln">392</span> 
<span class="ln">393</span>     /**
<span class="ln">394</span>      * Executes the SQL statement and returns the first row of the result.
<span class="ln">395</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 app expanded">
			<td class="number">
				#1			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;C:\etc\Apache\htdocs\MSSQL\application\controllers\Statistics_userController.php(206): <strong>CDbCommand</strong>-&gt;<strong>queryAll</strong>()				</div>

				<div class="code"><pre><span class="ln">201</span>         {
<span class="ln">202</span>             $query .="AND qa.value='1'\n";
<span class="ln">203</span>         }
<span class="ln">204</span> 
<span class="ln">205</span>         //execute query
<span class="error"><span class="ln error-ln">206</span>         $result = Yii::app()-&gt;db-&gt;createCommand($query)-&gt;bindParam(":lang", $language, PDO::PARAM_STR)-&gt;bindParam(":surveyid", $iSurveyID, PDO::PARAM_INT)-&gt;queryAll();
</span><span class="ln">207</span> 
<span class="ln">208</span>         //store all the data in $rows
<span class="ln">209</span>         $rows = $result;
<span class="ln">210</span> 
<span class="ln">211</span> 
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#2			</td>
			<td class="content">
				<div class="trace-file">
										&nbsp;unknown(0): <strong>Statistics_userController</strong>-&gt;<strong>actionAction</strong>("954656", "en")				</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;C:\etc\Apache\htdocs\MSSQL\framework\web\actions\CAction.php(107): <strong>ReflectionMethod</strong>-&gt;<strong>invokeArgs</strong>(Statistics_userController, array("954656", "en"))				</div>

				<div class="code"><pre><span class="ln">102</span>             else if($param-&gt;isDefaultValueAvailable())
<span class="ln">103</span>                 $ps[]=$param-&gt;getDefaultValue();
<span class="ln">104</span>             else
<span class="ln">105</span>                 return false;
<span class="ln">106</span>         }
<span class="error"><span class="ln error-ln">107</span>         $method-&gt;invokeArgs($object,$ps);
</span><span class="ln">108</span>         return true;
<span class="ln">109</span>     }
<span class="ln">110</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;C:\etc\Apache\htdocs\MSSQL\framework\web\actions\CInlineAction.php(48): <strong>CAction</strong>-&gt;<strong>runWithParamsInternal</strong>(Statistics_userController, ReflectionMethod, array("surveyid" =&gt; "954656", "language" =&gt; "en"))				</div>

				<div class="code"><pre><span class="ln">43</span>     {
<span class="ln">44</span>         $methodName='action'.$this-&gt;getId();
<span class="ln">45</span>         $controller=$this-&gt;getController();
<span class="ln">46</span>         $method=new ReflectionMethod($controller, $methodName);
<span class="ln">47</span>         if($method-&gt;getNumberOfParameters()&gt;0)
<span class="error"><span class="ln error-ln">48</span>             return $this-&gt;runWithParamsInternal($controller, $method, $params);
</span><span class="ln">49</span>         else
<span class="ln">50</span>             return $controller-&gt;$methodName();
<span class="ln">51</span>     }
<span class="ln">52</span> 
<span class="ln">53</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;C:\etc\Apache\htdocs\MSSQL\framework\web\CController.php(309): <strong>CInlineAction</strong>-&gt;<strong>runWithParams</strong>(array("surveyid" =&gt; "954656", "language" =&gt; "en"))				</div>

				<div class="code"><pre><span class="ln">304</span>     {
<span class="ln">305</span>         $priorAction=$this-&gt;_action;
<span class="ln">306</span>         $this-&gt;_action=$action;
<span class="ln">307</span>         if($this-&gt;beforeAction($action))
<span class="ln">308</span>         {
<span class="error"><span class="ln error-ln">309</span>             if($action-&gt;runWithParams($this-&gt;getActionParams())===false)
</span><span class="ln">310</span>                 $this-&gt;invalidActionParams($action);
<span class="ln">311</span>             else
<span class="ln">312</span>                 $this-&gt;afterAction($action);
<span class="ln">313</span>         }
<span class="ln">314</span>         $this-&gt;_action=$priorAction;
</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;C:\etc\Apache\htdocs\MSSQL\framework\web\CController.php(287): <strong>CController</strong>-&gt;<strong>runAction</strong>(CInlineAction)				</div>

				<div class="code"><pre><span class="ln">282</span>      * @see runAction
<span class="ln">283</span>      */
<span class="ln">284</span>     public function runActionWithFilters($action,$filters)
<span class="ln">285</span>     {
<span class="ln">286</span>         if(empty($filters))
<span class="error"><span class="ln error-ln">287</span>             $this-&gt;runAction($action);
</span><span class="ln">288</span>         else
<span class="ln">289</span>         {
<span class="ln">290</span>             $priorAction=$this-&gt;_action;
<span class="ln">291</span>             $this-&gt;_action=$action;
<span class="ln">292</span>             CFilterChain::create($this,$action,$filters)-&gt;run();
</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;C:\etc\Apache\htdocs\MSSQL\framework\web\CController.php(266): <strong>CController</strong>-&gt;<strong>runActionWithFilters</strong>(CInlineAction, array())				</div>

				<div class="code"><pre><span class="ln">261</span>         {
<span class="ln">262</span>             if(($parent=$this-&gt;getModule())===null)
<span class="ln">263</span>                 $parent=Yii::app();
<span class="ln">264</span>             if($parent-&gt;beforeControllerAction($this,$action))
<span class="ln">265</span>             {
<span class="error"><span class="ln error-ln">266</span>                 $this-&gt;runActionWithFilters($action,$this-&gt;filters());
</span><span class="ln">267</span>                 $parent-&gt;afterControllerAction($this,$action);
<span class="ln">268</span>             }
<span class="ln">269</span>         }
<span class="ln">270</span>         else
<span class="ln">271</span>             $this-&gt;missingAction($actionID);
</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;C:\etc\Apache\htdocs\MSSQL\framework\web\CWebApplication.php(276): <strong>CController</strong>-&gt;<strong>run</strong>("action")				</div>

				<div class="code"><pre><span class="ln">271</span>         {
<span class="ln">272</span>             list($controller,$actionID)=$ca;
<span class="ln">273</span>             $oldController=$this-&gt;_controller;
<span class="ln">274</span>             $this-&gt;_controller=$controller;
<span class="ln">275</span>             $controller-&gt;init();
<span class="error"><span class="ln error-ln">276</span>             $controller-&gt;run($actionID);
</span><span class="ln">277</span>             $this-&gt;_controller=$oldController;
<span class="ln">278</span>         }
<span class="ln">279</span>         else
<span class="ln">280</span>             throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".',
<span class="ln">281</span>                 array('{route}'=&gt;$route===''?$this-&gt;defaultController:$route)));
</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;C:\etc\Apache\htdocs\MSSQL\framework\web\CWebApplication.php(135): <strong>CWebApplication</strong>-&gt;<strong>runController</strong>("statistics_user/action/surveyid/954656/language/en")				</div>

				<div class="code"><pre><span class="ln">130</span>             foreach(array_splice($this-&gt;catchAllRequest,1) as $name=&gt;$value)
<span class="ln">131</span>                 $_GET[$name]=$value;
<span class="ln">132</span>         }
<span class="ln">133</span>         else
<span class="ln">134</span>             $route=$this-&gt;getUrlManager()-&gt;parseUrl($this-&gt;getRequest());
<span class="error"><span class="ln error-ln">135</span>         $this-&gt;runController($route);
</span><span class="ln">136</span>     }
<span class="ln">137</span> 
<span class="ln">138</span>     /**
<span class="ln">139</span>      * Registers the core application components.
<span class="ln">140</span>      * This method overrides the parent implementation by registering additional core components.
</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;C:\etc\Apache\htdocs\MSSQL\framework\base\CApplication.php(162): <strong>CWebApplication</strong>-&gt;<strong>processRequest</strong>()				</div>

				<div class="code"><pre><span class="ln">157</span>      */
<span class="ln">158</span>     public function run()
<span class="ln">159</span>     {
<span class="ln">160</span>         if($this-&gt;hasEventHandler('onBeginRequest'))
<span class="ln">161</span>             $this-&gt;onBeginRequest(new CEvent($this));
<span class="error"><span class="ln error-ln">162</span>         $this-&gt;processRequest();
</span><span class="ln">163</span>         if($this-&gt;hasEventHandler('onEndRequest'))
<span class="ln">164</span>             $this-&gt;onEndRequest(new CEvent($this));
<span class="ln">165</span>     }
<span class="ln">166</span> 
<span class="ln">167</span>     /**
</pre></div>			</td>
		</tr>
						<tr class="trace app expanded">
			<td class="number">
				#11			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;C:\etc\Apache\htdocs\MSSQL\index.php(178): <strong>CApplication</strong>-&gt;<strong>run</strong>()				</div>

				<div class="code"><pre><span class="ln">173</span>  *
<span class="ln">174</span>  */
<span class="ln">175</span> require_once BASEPATH . 'yii' . EXT;
<span class="ln">176</span> require_once APPPATH . 'core/LSYii_Application' . EXT;
<span class="ln">177</span> 
<span class="error"><span class="ln error-ln">178</span> Yii::createApplication('LSYii_Application', APPPATH . 'config/config' . EXT)-&gt;run();
</span><span class="ln">179</span> 
<span class="ln">180</span> /* End of file index.php */
<span class="ln">181</span> /* Location: ./index.php */
</pre></div>			</td>
		</tr>
				</tbody></table>
	</div>

	<div class="version">
		2012-10-18 08:42:19 Apache/2.4.3 (Win32) OpenSSL/1.0.1c PHP/5.4.7 <a href="http://www.yiiframework.com/">Yii Framework</a>/1.1.10	</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><link rel="stylesheet" type="text/css" href="data:text/css,"></html>
CDbException.htm (19,637 bytes)   
CDbException03.htm (19,860 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[07002]: [Microsoft][SQL Server Native Client 11.0]COUNT field incorrect or syntax error. The SQL statement executed was: SELECT q.* , group_name, group_order FROM lime_questions q, lime_groups g, lime_question_attributes qa <br />
                    WHERE g.gid = q.gid AND g.language = :lang AND q.language = :lang AND q.sid = :surveyid AND q.qid = qa.qid AND q.parent_qid = 0 AND qa.attribute = &#039;public_statistics&#039;AND CAST(CAST(qa.value as varchar) as int)=&#039;1&#039;<br />
	</p>

	<div class="source">
		<p class="file">C:\etc\Apache\htdocs\MSSQL\framework\db\CDbCommand.php(528)</p>
		<div class="code"><pre><span class="ln">516</span>             return $result;
<span class="ln">517</span>         }
<span class="ln">518</span>         catch(Exception $e)
<span class="ln">519</span>         {
<span class="ln">520</span>             if($this-&gt;_connection-&gt;enableProfiling)
<span class="ln">521</span>                 Yii::endProfile(&#039;system.db.CDbCommand.query(&#039;.$this-&gt;getText().$par.&#039;)&#039;,&#039;system.db.CDbCommand.query&#039;);
<span class="ln">522</span>             $errorInfo = $e instanceof PDOException ? $e-&gt;errorInfo : null;
<span class="ln">523</span>             $message = $e-&gt;getMessage();
<span class="ln">524</span>             Yii::log(Yii::t(&#039;yii&#039;,&#039;CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.&#039;,
<span class="ln">525</span>                 array(&#039;{method}&#039;=&gt;$method, &#039;{error}&#039;=&gt;$message, &#039;{sql}&#039;=&gt;$this-&gt;getText().$par)),CLogger::LEVEL_ERROR,&#039;system.db.CDbCommand&#039;);
<span class="ln">526</span>             if(YII_DEBUG)
<span class="ln">527</span>                 $message .= &#039;. The SQL statement executed was: &#039;.$this-&gt;getText().$par;
<span class="error"><span class="ln error-ln">528</span>             throw new CDbException(Yii::t(&#039;yii&#039;,&#039;CDbCommand failed to execute the SQL statement: {error}&#039;,
</span><span class="ln">529</span>                 array(&#039;{error}&#039;=&gt;$message)),(int)$e-&gt;getCode(),$errorInfo);
<span class="ln">530</span>         }
<span class="ln">531</span>     }
<span class="ln">532</span> 
<span class="ln">533</span>     /**
<span class="ln">534</span>      * Builds a SQL SELECT statement from the given query specification.
<span class="ln">535</span>      * @param array $query the query specification in name-value pairs. The following
<span class="ln">536</span>      * query options are supported: {@link select}, {@link distinct}, {@link from},
<span class="ln">537</span>      * {@link where}, {@link join}, {@link group}, {@link having}, {@link order},
<span class="ln">538</span>      * {@link limit}, {@link offset} and {@link union}.
<span class="ln">539</span>      * @return string the SQL statement
<span class="ln">540</span>      * @since 1.1.6
</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;C:\etc\Apache\htdocs\MSSQL\framework\db\CDbCommand.php(390): <strong>CDbCommand</strong>-><strong>queryInternal</strong>(&quot;fetchAll&quot;, array(2), array())				</div>

				<div class="code"><pre><span class="ln">385</span>      * An empty array is returned if the query results in nothing.
<span class="ln">386</span>      * @throws CException execution failed
<span class="ln">387</span>      */
<span class="ln">388</span>     public function queryAll($fetchAssociative=true,$params=array())
<span class="ln">389</span>     {
<span class="error"><span class="ln error-ln">390</span>         return $this-&gt;queryInternal(&#039;fetchAll&#039;,$fetchAssociative ? $this-&gt;_fetchMode : PDO::FETCH_NUM, $params);
</span><span class="ln">391</span>     }
<span class="ln">392</span> 
<span class="ln">393</span>     /**
<span class="ln">394</span>      * Executes the SQL statement and returns the first row of the result.
<span class="ln">395</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 app expanded">
			<td class="number">
				#1			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;C:\etc\Apache\htdocs\MSSQL\application\controllers\Statistics_userController.php(206): <strong>CDbCommand</strong>-><strong>queryAll</strong>()				</div>

				<div class="code"><pre><span class="ln">201</span>         {
<span class="ln">202</span>             $query .=&quot;AND qa.value=&#039;1&#039;\n&quot;;
<span class="ln">203</span>         }
<span class="ln">204</span> 
<span class="ln">205</span>         //execute query
<span class="error"><span class="ln error-ln">206</span>         $result = Yii::app()-&gt;db-&gt;createCommand($query)-&gt;bindParam(&quot;:lang&quot;, $language, PDO::PARAM_STR)-&gt;bindParam(&quot;:surveyid&quot;, $iSurveyID, PDO::PARAM_INT)-&gt;queryAll();
</span><span class="ln">207</span> 
<span class="ln">208</span>         //store all the data in $rows
<span class="ln">209</span>         $rows = $result;
<span class="ln">210</span> 
<span class="ln">211</span> 
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#2			</td>
			<td class="content">
				<div class="trace-file">
										&nbsp;unknown(0): <strong>Statistics_userController</strong>-><strong>actionAction</strong>(&quot;954656&quot;, &quot;en&quot;)				</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;C:\etc\Apache\htdocs\MSSQL\framework\web\actions\CAction.php(107): <strong>ReflectionMethod</strong>-><strong>invokeArgs</strong>(Statistics_userController, array(&quot;954656&quot;, &quot;en&quot;))				</div>

				<div class="code"><pre><span class="ln">102</span>             else if($param-&gt;isDefaultValueAvailable())
<span class="ln">103</span>                 $ps[]=$param-&gt;getDefaultValue();
<span class="ln">104</span>             else
<span class="ln">105</span>                 return false;
<span class="ln">106</span>         }
<span class="error"><span class="ln error-ln">107</span>         $method-&gt;invokeArgs($object,$ps);
</span><span class="ln">108</span>         return true;
<span class="ln">109</span>     }
<span class="ln">110</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;C:\etc\Apache\htdocs\MSSQL\framework\web\actions\CInlineAction.php(48): <strong>CAction</strong>-><strong>runWithParamsInternal</strong>(Statistics_userController, ReflectionMethod, array(&quot;surveyid&quot; =&gt; &quot;954656&quot;, &quot;language&quot; =&gt; &quot;en&quot;))				</div>

				<div class="code"><pre><span class="ln">43</span>     {
<span class="ln">44</span>         $methodName=&#039;action&#039;.$this-&gt;getId();
<span class="ln">45</span>         $controller=$this-&gt;getController();
<span class="ln">46</span>         $method=new ReflectionMethod($controller, $methodName);
<span class="ln">47</span>         if($method-&gt;getNumberOfParameters()&gt;0)
<span class="error"><span class="ln error-ln">48</span>             return $this-&gt;runWithParamsInternal($controller, $method, $params);
</span><span class="ln">49</span>         else
<span class="ln">50</span>             return $controller-&gt;$methodName();
<span class="ln">51</span>     }
<span class="ln">52</span> 
<span class="ln">53</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;C:\etc\Apache\htdocs\MSSQL\framework\web\CController.php(309): <strong>CInlineAction</strong>-><strong>runWithParams</strong>(array(&quot;surveyid&quot; =&gt; &quot;954656&quot;, &quot;language&quot; =&gt; &quot;en&quot;))				</div>

				<div class="code"><pre><span class="ln">304</span>     {
<span class="ln">305</span>         $priorAction=$this-&gt;_action;
<span class="ln">306</span>         $this-&gt;_action=$action;
<span class="ln">307</span>         if($this-&gt;beforeAction($action))
<span class="ln">308</span>         {
<span class="error"><span class="ln error-ln">309</span>             if($action-&gt;runWithParams($this-&gt;getActionParams())===false)
</span><span class="ln">310</span>                 $this-&gt;invalidActionParams($action);
<span class="ln">311</span>             else
<span class="ln">312</span>                 $this-&gt;afterAction($action);
<span class="ln">313</span>         }
<span class="ln">314</span>         $this-&gt;_action=$priorAction;
</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;C:\etc\Apache\htdocs\MSSQL\framework\web\CController.php(287): <strong>CController</strong>-><strong>runAction</strong>(CInlineAction)				</div>

				<div class="code"><pre><span class="ln">282</span>      * @see runAction
<span class="ln">283</span>      */
<span class="ln">284</span>     public function runActionWithFilters($action,$filters)
<span class="ln">285</span>     {
<span class="ln">286</span>         if(empty($filters))
<span class="error"><span class="ln error-ln">287</span>             $this-&gt;runAction($action);
</span><span class="ln">288</span>         else
<span class="ln">289</span>         {
<span class="ln">290</span>             $priorAction=$this-&gt;_action;
<span class="ln">291</span>             $this-&gt;_action=$action;
<span class="ln">292</span>             CFilterChain::create($this,$action,$filters)-&gt;run();
</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;C:\etc\Apache\htdocs\MSSQL\framework\web\CController.php(266): <strong>CController</strong>-><strong>runActionWithFilters</strong>(CInlineAction, array())				</div>

				<div class="code"><pre><span class="ln">261</span>         {
<span class="ln">262</span>             if(($parent=$this-&gt;getModule())===null)
<span class="ln">263</span>                 $parent=Yii::app();
<span class="ln">264</span>             if($parent-&gt;beforeControllerAction($this,$action))
<span class="ln">265</span>             {
<span class="error"><span class="ln error-ln">266</span>                 $this-&gt;runActionWithFilters($action,$this-&gt;filters());
</span><span class="ln">267</span>                 $parent-&gt;afterControllerAction($this,$action);
<span class="ln">268</span>             }
<span class="ln">269</span>         }
<span class="ln">270</span>         else
<span class="ln">271</span>             $this-&gt;missingAction($actionID);
</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;C:\etc\Apache\htdocs\MSSQL\framework\web\CWebApplication.php(276): <strong>CController</strong>-><strong>run</strong>(&quot;action&quot;)				</div>

				<div class="code"><pre><span class="ln">271</span>         {
<span class="ln">272</span>             list($controller,$actionID)=$ca;
<span class="ln">273</span>             $oldController=$this-&gt;_controller;
<span class="ln">274</span>             $this-&gt;_controller=$controller;
<span class="ln">275</span>             $controller-&gt;init();
<span class="error"><span class="ln error-ln">276</span>             $controller-&gt;run($actionID);
</span><span class="ln">277</span>             $this-&gt;_controller=$oldController;
<span class="ln">278</span>         }
<span class="ln">279</span>         else
<span class="ln">280</span>             throw new CHttpException(404,Yii::t(&#039;yii&#039;,&#039;Unable to resolve the request &quot;{route}&quot;.&#039;,
<span class="ln">281</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">
				#9			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;C:\etc\Apache\htdocs\MSSQL\framework\web\CWebApplication.php(135): <strong>CWebApplication</strong>-><strong>runController</strong>(&quot;statistics_user/action/surveyid/954656/language/en&quot;)				</div>

				<div class="code"><pre><span class="ln">130</span>             foreach(array_splice($this-&gt;catchAllRequest,1) as $name=&gt;$value)
<span class="ln">131</span>                 $_GET[$name]=$value;
<span class="ln">132</span>         }
<span class="ln">133</span>         else
<span class="ln">134</span>             $route=$this-&gt;getUrlManager()-&gt;parseUrl($this-&gt;getRequest());
<span class="error"><span class="ln error-ln">135</span>         $this-&gt;runController($route);
</span><span class="ln">136</span>     }
<span class="ln">137</span> 
<span class="ln">138</span>     /**
<span class="ln">139</span>      * Registers the core application components.
<span class="ln">140</span>      * This method overrides the parent implementation by registering additional core components.
</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;C:\etc\Apache\htdocs\MSSQL\framework\base\CApplication.php(162): <strong>CWebApplication</strong>-><strong>processRequest</strong>()				</div>

				<div class="code"><pre><span class="ln">157</span>      */
<span class="ln">158</span>     public function run()
<span class="ln">159</span>     {
<span class="ln">160</span>         if($this-&gt;hasEventHandler(&#039;onBeginRequest&#039;))
<span class="ln">161</span>             $this-&gt;onBeginRequest(new CEvent($this));
<span class="error"><span class="ln error-ln">162</span>         $this-&gt;processRequest();
</span><span class="ln">163</span>         if($this-&gt;hasEventHandler(&#039;onEndRequest&#039;))
<span class="ln">164</span>             $this-&gt;onEndRequest(new CEvent($this));
<span class="ln">165</span>     }
<span class="ln">166</span> 
<span class="ln">167</span>     /**
</pre></div>			</td>
		</tr>
						<tr class="trace app expanded">
			<td class="number">
				#11			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;C:\etc\Apache\htdocs\MSSQL\index.php(178): <strong>CApplication</strong>-><strong>run</strong>()				</div>

				<div class="code"><pre><span class="ln">173</span>  *
<span class="ln">174</span>  */
<span class="ln">175</span> require_once BASEPATH . &#039;yii&#039; . EXT;
<span class="ln">176</span> require_once APPPATH . &#039;core/LSYii_Application&#039; . EXT;
<span class="ln">177</span> 
<span class="error"><span class="ln error-ln">178</span> Yii::createApplication(&#039;LSYii_Application&#039;, APPPATH . &#039;config/config&#039; . EXT)-&gt;run();
</span><span class="ln">179</span> 
<span class="ln">180</span> /* End of file index.php */
<span class="ln">181</span> /* Location: ./index.php */
</pre></div>			</td>
		</tr>
				</table>
	</div>

	<div class="version">
		2012-10-19 09:16:42 Apache/2.4.3 (Win32) OpenSSL/1.0.1c PHP/5.4.7 <a href="http://www.yiiframework.com/">Yii Framework</a>/1.1.10	</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>
CDbException03.htm (19,860 bytes)   
en.htm (19,921 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[07002]: 
[Microsoft][SQL Server Native Client 11.0]COUNT field incorrect or 
syntax error. The SQL statement executed was: SELECT q.* , group_name, 
group_order FROM lime_questions q, lime_groups g, 
lime_question_attributes qa <br>
                    WHERE g.gid = q.gid AND g.language = :lang AND 
q.language = :lang AND q.sid = :surveyid AND q.qid = qa.qid AND 
q.parent_qid = 0 AND qa.attribute = 'public_statistics' AND 
CAST(CAST(qa.value as varchar) as int)='1'<br>
	</p>

	<div class="source">
		<p class="file">C:\etc\Apache\htdocs\MSSQL\framework\db\CDbCommand.php(528)</p>
		<div class="code"><pre><span class="ln">516</span>             return $result;
<span class="ln">517</span>         }
<span class="ln">518</span>         catch(Exception $e)
<span class="ln">519</span>         {
<span class="ln">520</span>             if($this-&gt;_connection-&gt;enableProfiling)
<span class="ln">521</span>                 Yii::endProfile('system.db.CDbCommand.query('.$this-&gt;getText().$par.')','system.db.CDbCommand.query');
<span class="ln">522</span>             $errorInfo = $e instanceof PDOException ? $e-&gt;errorInfo : null;
<span class="ln">523</span>             $message = $e-&gt;getMessage();
<span class="ln">524</span>             Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',
<span class="ln">525</span>                 array('{method}'=&gt;$method, '{error}'=&gt;$message, '{sql}'=&gt;$this-&gt;getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
<span class="ln">526</span>             if(YII_DEBUG)
<span class="ln">527</span>                 $message .= '. The SQL statement executed was: '.$this-&gt;getText().$par;
<span class="error"><span class="ln error-ln">528</span>             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
</span><span class="ln">529</span>                 array('{error}'=&gt;$message)),(int)$e-&gt;getCode(),$errorInfo);
<span class="ln">530</span>         }
<span class="ln">531</span>     }
<span class="ln">532</span> 
<span class="ln">533</span>     /**
<span class="ln">534</span>      * Builds a SQL SELECT statement from the given query specification.
<span class="ln">535</span>      * @param array $query the query specification in name-value pairs. The following
<span class="ln">536</span>      * query options are supported: {@link select}, {@link distinct}, {@link from},
<span class="ln">537</span>      * {@link where}, {@link join}, {@link group}, {@link having}, {@link order},
<span class="ln">538</span>      * {@link limit}, {@link offset} and {@link union}.
<span class="ln">539</span>      * @return string the SQL statement
<span class="ln">540</span>      * @since 1.1.6
</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;C:\etc\Apache\htdocs\MSSQL\framework\db\CDbCommand.php(390): <strong>CDbCommand</strong>-&gt;<strong>queryInternal</strong>("fetchAll", array(2), array())				</div>

				<div class="code"><pre><span class="ln">385</span>      * An empty array is returned if the query results in nothing.
<span class="ln">386</span>      * @throws CException execution failed
<span class="ln">387</span>      */
<span class="ln">388</span>     public function queryAll($fetchAssociative=true,$params=array())
<span class="ln">389</span>     {
<span class="error"><span class="ln error-ln">390</span>         return $this-&gt;queryInternal('fetchAll',$fetchAssociative ? $this-&gt;_fetchMode : PDO::FETCH_NUM, $params);
</span><span class="ln">391</span>     }
<span class="ln">392</span> 
<span class="ln">393</span>     /**
<span class="ln">394</span>      * Executes the SQL statement and returns the first row of the result.
<span class="ln">395</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 app expanded">
			<td class="number">
				#1			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;C:\etc\Apache\htdocs\MSSQL\application\controllers\Statistics_userController.php(206): <strong>CDbCommand</strong>-&gt;<strong>queryAll</strong>()				</div>

				<div class="code"><pre><span class="ln">201</span>         {
<span class="ln">202</span>             $query .=" AND qa.value='1'\n";
<span class="ln">203</span>         }
<span class="ln">204</span> 
<span class="ln">205</span>         //execute query
<span class="error"><span class="ln error-ln">206</span>         $result = Yii::app()-&gt;db-&gt;createCommand($query)-&gt;bindParam(":lang", $language, PDO::PARAM_STR)-&gt;bindParam(":surveyid", $iSurveyID, PDO::PARAM_INT)-&gt;queryAll();
</span><span class="ln">207</span> 
<span class="ln">208</span>         //store all the data in $rows
<span class="ln">209</span>         $rows = $result;
<span class="ln">210</span> 
<span class="ln">211</span> 
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#2			</td>
			<td class="content">
				<div class="trace-file">
										&nbsp;unknown(0): <strong>Statistics_userController</strong>-&gt;<strong>actionAction</strong>("945857", "en")				</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;C:\etc\Apache\htdocs\MSSQL\framework\web\actions\CAction.php(107): <strong>ReflectionMethod</strong>-&gt;<strong>invokeArgs</strong>(Statistics_userController, array("945857", "en"))				</div>

				<div class="code"><pre><span class="ln">102</span>             else if($param-&gt;isDefaultValueAvailable())
<span class="ln">103</span>                 $ps[]=$param-&gt;getDefaultValue();
<span class="ln">104</span>             else
<span class="ln">105</span>                 return false;
<span class="ln">106</span>         }
<span class="error"><span class="ln error-ln">107</span>         $method-&gt;invokeArgs($object,$ps);
</span><span class="ln">108</span>         return true;
<span class="ln">109</span>     }
<span class="ln">110</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;C:\etc\Apache\htdocs\MSSQL\framework\web\actions\CInlineAction.php(48): <strong>CAction</strong>-&gt;<strong>runWithParamsInternal</strong>(Statistics_userController, ReflectionMethod, array("surveyid" =&gt; "945857", "language" =&gt; "en"))				</div>

				<div class="code"><pre><span class="ln">43</span>     {
<span class="ln">44</span>         $methodName='action'.$this-&gt;getId();
<span class="ln">45</span>         $controller=$this-&gt;getController();
<span class="ln">46</span>         $method=new ReflectionMethod($controller, $methodName);
<span class="ln">47</span>         if($method-&gt;getNumberOfParameters()&gt;0)
<span class="error"><span class="ln error-ln">48</span>             return $this-&gt;runWithParamsInternal($controller, $method, $params);
</span><span class="ln">49</span>         else
<span class="ln">50</span>             return $controller-&gt;$methodName();
<span class="ln">51</span>     }
<span class="ln">52</span> 
<span class="ln">53</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;C:\etc\Apache\htdocs\MSSQL\framework\web\CController.php(309): <strong>CInlineAction</strong>-&gt;<strong>runWithParams</strong>(array("surveyid" =&gt; "945857", "language" =&gt; "en"))				</div>

				<div class="code"><pre><span class="ln">304</span>     {
<span class="ln">305</span>         $priorAction=$this-&gt;_action;
<span class="ln">306</span>         $this-&gt;_action=$action;
<span class="ln">307</span>         if($this-&gt;beforeAction($action))
<span class="ln">308</span>         {
<span class="error"><span class="ln error-ln">309</span>             if($action-&gt;runWithParams($this-&gt;getActionParams())===false)
</span><span class="ln">310</span>                 $this-&gt;invalidActionParams($action);
<span class="ln">311</span>             else
<span class="ln">312</span>                 $this-&gt;afterAction($action);
<span class="ln">313</span>         }
<span class="ln">314</span>         $this-&gt;_action=$priorAction;
</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;C:\etc\Apache\htdocs\MSSQL\framework\web\CController.php(287): <strong>CController</strong>-&gt;<strong>runAction</strong>(CInlineAction)				</div>

				<div class="code"><pre><span class="ln">282</span>      * @see runAction
<span class="ln">283</span>      */
<span class="ln">284</span>     public function runActionWithFilters($action,$filters)
<span class="ln">285</span>     {
<span class="ln">286</span>         if(empty($filters))
<span class="error"><span class="ln error-ln">287</span>             $this-&gt;runAction($action);
</span><span class="ln">288</span>         else
<span class="ln">289</span>         {
<span class="ln">290</span>             $priorAction=$this-&gt;_action;
<span class="ln">291</span>             $this-&gt;_action=$action;
<span class="ln">292</span>             CFilterChain::create($this,$action,$filters)-&gt;run();
</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;C:\etc\Apache\htdocs\MSSQL\framework\web\CController.php(266): <strong>CController</strong>-&gt;<strong>runActionWithFilters</strong>(CInlineAction, array())				</div>

				<div class="code"><pre><span class="ln">261</span>         {
<span class="ln">262</span>             if(($parent=$this-&gt;getModule())===null)
<span class="ln">263</span>                 $parent=Yii::app();
<span class="ln">264</span>             if($parent-&gt;beforeControllerAction($this,$action))
<span class="ln">265</span>             {
<span class="error"><span class="ln error-ln">266</span>                 $this-&gt;runActionWithFilters($action,$this-&gt;filters());
</span><span class="ln">267</span>                 $parent-&gt;afterControllerAction($this,$action);
<span class="ln">268</span>             }
<span class="ln">269</span>         }
<span class="ln">270</span>         else
<span class="ln">271</span>             $this-&gt;missingAction($actionID);
</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;C:\etc\Apache\htdocs\MSSQL\framework\web\CWebApplication.php(276): <strong>CController</strong>-&gt;<strong>run</strong>("action")				</div>

				<div class="code"><pre><span class="ln">271</span>         {
<span class="ln">272</span>             list($controller,$actionID)=$ca;
<span class="ln">273</span>             $oldController=$this-&gt;_controller;
<span class="ln">274</span>             $this-&gt;_controller=$controller;
<span class="ln">275</span>             $controller-&gt;init();
<span class="error"><span class="ln error-ln">276</span>             $controller-&gt;run($actionID);
</span><span class="ln">277</span>             $this-&gt;_controller=$oldController;
<span class="ln">278</span>         }
<span class="ln">279</span>         else
<span class="ln">280</span>             throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".',
<span class="ln">281</span>                 array('{route}'=&gt;$route===''?$this-&gt;defaultController:$route)));
</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;C:\etc\Apache\htdocs\MSSQL\framework\web\CWebApplication.php(135): <strong>CWebApplication</strong>-&gt;<strong>runController</strong>("statistics_user/action/surveyid/945857/language/en")				</div>

				<div class="code"><pre><span class="ln">130</span>             foreach(array_splice($this-&gt;catchAllRequest,1) as $name=&gt;$value)
<span class="ln">131</span>                 $_GET[$name]=$value;
<span class="ln">132</span>         }
<span class="ln">133</span>         else
<span class="ln">134</span>             $route=$this-&gt;getUrlManager()-&gt;parseUrl($this-&gt;getRequest());
<span class="error"><span class="ln error-ln">135</span>         $this-&gt;runController($route);
</span><span class="ln">136</span>     }
<span class="ln">137</span> 
<span class="ln">138</span>     /**
<span class="ln">139</span>      * Registers the core application components.
<span class="ln">140</span>      * This method overrides the parent implementation by registering additional core components.
</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;C:\etc\Apache\htdocs\MSSQL\framework\base\CApplication.php(162): <strong>CWebApplication</strong>-&gt;<strong>processRequest</strong>()				</div>

				<div class="code"><pre><span class="ln">157</span>      */
<span class="ln">158</span>     public function run()
<span class="ln">159</span>     {
<span class="ln">160</span>         if($this-&gt;hasEventHandler('onBeginRequest'))
<span class="ln">161</span>             $this-&gt;onBeginRequest(new CEvent($this));
<span class="error"><span class="ln error-ln">162</span>         $this-&gt;processRequest();
</span><span class="ln">163</span>         if($this-&gt;hasEventHandler('onEndRequest'))
<span class="ln">164</span>             $this-&gt;onEndRequest(new CEvent($this));
<span class="ln">165</span>     }
<span class="ln">166</span> 
<span class="ln">167</span>     /**
</pre></div>			</td>
		</tr>
						<tr class="trace app expanded">
			<td class="number">
				#11			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;C:\etc\Apache\htdocs\MSSQL\index.php(178): <strong>CApplication</strong>-&gt;<strong>run</strong>()				</div>

				<div class="code"><pre><span class="ln">173</span>  *
<span class="ln">174</span>  */
<span class="ln">175</span> require_once BASEPATH . 'yii' . EXT;
<span class="ln">176</span> require_once APPPATH . 'core/LSYii_Application' . EXT;
<span class="ln">177</span> 
<span class="error"><span class="ln error-ln">178</span> Yii::createApplication('LSYii_Application', APPPATH . 'config/config' . EXT)-&gt;run();
</span><span class="ln">179</span> 
<span class="ln">180</span> /* End of file index.php */
<span class="ln">181</span> /* Location: ./index.php */
</pre></div>			</td>
		</tr>
				</tbody></table>
	</div>

	<div class="version">
		2012-10-29 13:56:46 Apache/2.4.3 (Win32) OpenSSL/1.0.1c PHP/5.4.7 <a href="http://www.yiiframework.com/">Yii Framework</a>/1.1.10	</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>
en.htm (19,921 bytes)   
survey_archive_945857(2).lsa (5,784 bytes)
Bug heat6
Complete LimeSurvey version number (& build)121017
I will donate to the project if issue is resolvedNo
BrowserIE8, FF, Chrome
Database type & versionSQL Server 2008 Full
Server OS (if known)Windows 2008r2
Webserver software & version (if known)Apache 2.4
PHP Version5.4.4

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2012-10-19 14:26

developer   ~21461

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

DenisChenu

2012-10-19 14:28

developer   ~21462

I can't test with SQL server, but if you can apply the patch in your installation and test please :)
helper

helper

2012-10-19 15:18

reporter   ~21471

Testing show the error is still there - attached stack trace.
helper

helper

2012-10-19 18:00

reporter   ~21500

Failure is happening at the "g.language = :lang" and elsewhere where there is a colon for a value. Still happens in Version 2.00+ Build 121019

SELECT q.* , group_name, group_order FROM lime_questions q, lime_groups g, lime_question_attributes qa
WHERE g.gid = q.gid AND g.language = :lang AND q.language = :lang AND q.sid = :surveyid AND q.qid = qa.qid AND q.parent_qid = 0 AND qa.attribute = 'public_statistics'AND CAST(CAST(qa.value as varchar) as int)='1'
helper

helper

2012-10-29 18:58

reporter   ~21748

This is still and issue - attached the latest stack dump and lsa
c_schmitz

c_schmitz

2012-11-02 13:56

administrator   ~21913

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

c_schmitz

2012-11-02 21:42

administrator   ~21932

New version 2.00+ Build 121102 released.

Related Changesets

LimeSurvey: master 4eff3b77

2012-10-19 07:25

DenisChenu


Details Diff		 Fixed issue 06733: CDbException When User Attempts to View Statistics Affected Issues
06733
mod - application/controllers/Statistics_userController.php Diff File

LimeSurvey: master c5f7bdae

2012-11-02 13:55

c_schmitz


Details Diff		 Fixed issue 06733: Exception when viewing public statistics using MSSQL Affected Issues
06733
mod - application/controllers/Statistics_userController.php Diff File

Issue History

Date Modified Username Field Change
2012-10-18 14:45 helper New Issue
2012-10-18 14:45 helper File Added: CDbException.htm
2012-10-19 14:26 DenisChenu Changeset attached => LimeSurvey master 4eff3b77
2012-10-19 14:26 DenisChenu Note Added: 21461
2012-10-19 14:26 DenisChenu Assigned To => DenisChenu
2012-10-19 14:26 DenisChenu Resolution open => fixed
2012-10-19 14:28 DenisChenu Note Added: 21462
2012-10-19 15:18 helper File Added: CDbException03.htm
2012-10-19 15:18 helper Note Added: 21471
2012-10-19 15:46 c_schmitz Status new => assigned
2012-10-19 18:00 helper Note Added: 21500
2012-10-22 09:12 DenisChenu Assigned To DenisChenu =>
2012-10-22 09:12 DenisChenu Status assigned => new
2012-10-22 13:17 c_schmitz Assigned To => Mazi
2012-10-22 13:17 c_schmitz Status new => assigned
2012-10-22 13:17 c_schmitz Assigned To Mazi => mdekker
2012-10-29 18:58 helper Note Added: 21748
2012-10-29 18:58 helper File Added: en.htm
2012-10-29 18:58 helper File Added: survey_archive_945857(2).lsa
2012-10-30 09:15 mdekker Assigned To mdekker =>
2012-11-02 13:41 c_schmitz Assigned To => c_schmitz
2012-11-02 13:56 c_schmitz Changeset attached => LimeSurvey master c5f7bdae
2012-11-02 13:56 c_schmitz Note Added: 21913
2012-11-02 13:56 c_schmitz Status assigned => resolved
2012-11-02 13:56 c_schmitz Fixed in Version => 2.00+
2012-11-02 21:42 c_schmitz Note Added: 21932
2012-11-02 21:42 c_schmitz Status resolved => closed