View Issue Details

This issue affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
07042Bug reportsSurvey editingpublic2012-12-07 08:54
Reporternaumbidzovski Assigned Toc_schmitz  
PriorityurgentSeveritypartial_block 
Status closedResolutionunable to reproduce 
Product Version2.00+ 
Summary07042: Cannot add questions for quota
Description

Whenever I try to add question answers that define quota in quota creation screen I get error message. Attachment 1.

After this error message, I cannot manage quotas for that project at all because I get error whenever selecting Quota option for that project from tool box.

Attachment 2.

Steps To Reproduce

Add quota for existing project. Add quota question in quota definition screen and select question value from list. Error will appear. Whole project will not be able to use quota any more.

Additional Information

It looks like Postgres implementation of quota system has issues all-around.

TagsNo tags attached.
Attached Files
994254.htm (23,508 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[42601]: Syntax error: 7 ERROR:  syntax error at or near "X318X3172"<br>
LINE 1: ...OUNT(*) FROM "lime_survey_994254" "t" WHERE 994254X318X3172=...<br>
                                                             ^. The SQL 
statement executed was: SELECT COUNT(*) FROM "lime_survey_994254" "t" 
WHERE 994254X318X3172=:ycp0	</p>

	<div class="source">
		<p class="file">/srv/www/htdocs/survey/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;/srv/www/htdocs/survey/framework/db/CDbCommand.php(425): <strong>CDbCommand</strong>-&gt;<strong>queryInternal</strong>("fetchColumn", 0, array())				</div>

				<div class="code"><pre><span class="ln">420</span>      * @return mixed the value of the first column in the first row of the query result. False is returned if there is no value.
<span class="ln">421</span>      * @throws CException execution failed
<span class="ln">422</span>      */
<span class="ln">423</span>     public function queryScalar($params=array())
<span class="ln">424</span>     {
<span class="error"><span class="ln error-ln">425</span>         $result=$this-&gt;queryInternal('fetchColumn',0,$params);
</span><span class="ln">426</span>         if(is_resource($result) &amp;&amp; get_resource_type($result)==='stream')
<span class="ln">427</span>             return stream_get_contents($result);
<span class="ln">428</span>         else
<span class="ln">429</span>             return $result;
<span class="ln">430</span>     }
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#1			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/srv/www/htdocs/survey/framework/db/ar/CActiveRecord.php(1536): <strong>CDbCommand</strong>-&gt;<strong>queryScalar</strong>()				</div>

				<div class="code"><pre><span class="ln">1531</span>         $builder=$this-&gt;getCommandBuilder();
<span class="ln">1532</span>         $criteria=$builder-&gt;createCriteria($condition,$params);
<span class="ln">1533</span>         $this-&gt;applyScopes($criteria);
<span class="ln">1534</span> 
<span class="ln">1535</span>         if(empty($criteria-&gt;with))
<span class="error"><span class="ln error-ln">1536</span>             return $builder-&gt;createCountCommand($this-&gt;getTableSchema(),$criteria)-&gt;queryScalar();
</span><span class="ln">1537</span>         else
<span class="ln">1538</span>         {
<span class="ln">1539</span>             $finder=new CActiveFinder($this,$criteria-&gt;with);
<span class="ln">1540</span>             return $finder-&gt;count($criteria);
<span class="ln">1541</span>         }
</pre></div>			</td>
		</tr>
						<tr class="trace app expanded">
			<td class="number">
				#2			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/srv/www/htdocs/survey/application/helpers/common_helper.php(5963): <strong>CActiveRecord</strong>-&gt;<strong>count</strong>(CDbCriteria)				</div>

				<div class="code"><pre><span class="ln">5958</span>         $criteria = new CDbCriteria;
<span class="ln">5959</span> 
<span class="ln">5960</span>         foreach ($fields_list as $fieldname)
<span class="ln">5961</span>             $criteria-&gt;mergeWith($fields_query[$fieldname]);
<span class="ln">5962</span> 
<span class="error"><span class="ln error-ln">5963</span>         $result = Survey_dynamic::model($iSurveyId)-&gt;count($criteria);
</span><span class="ln">5964</span>     }
<span class="ln">5965</span> 
<span class="ln">5966</span>     return $result;
<span class="ln">5967</span> }
<span class="ln">5968</span> 
</pre></div>			</td>
		</tr>
						<tr class="trace app expanded">
			<td class="number">
				#3			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/srv/www/htdocs/survey/application/controllers/admin/quotas.php(107): <strong>getQuotaCompletedCount</strong>("994254", 11)				</div>

				<div class="code"><pre><span class="ln">102</span>             $aViewUrls['output'] = '';
<span class="ln">103</span>             //loop through all quotas
<span class="ln">104</span>             foreach ($aResult as $aQuotaListing)
<span class="ln">105</span>             {
<span class="ln">106</span>                 $totalquotas += $aQuotaListing['qlimit'];
<span class="error"><span class="ln error-ln">107</span>                 $completed = getQuotaCompletedCount($iSurveyId, $aQuotaListing['id']);
</span><span class="ln">108</span>                 $highlight = ($completed &gt;= $aQuotaListing['qlimit']) ? '' : "style='color: orange'"; //Incomplete quotas displayed in red
<span class="ln">109</span>                 $totalcompleted = $totalcompleted + $completed;
<span class="ln">110</span>                 $csvoutput[] = $aQuotaListing['name'] . "," . $aQuotaListing['qlimit'] . "," . $completed . "," . ($aQuotaListing['qlimit'] - $completed) . "\r\n";
<span class="ln">111</span> 
<span class="ln">112</span>                 if ($quickreport != false)
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#4			</td>
			<td class="content">
				<div class="trace-file">
										&nbsp;unknown(0): <strong>quotas</strong>-&gt;<strong>index</strong>("994254", false)				</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;/srv/www/htdocs/survey/framework/web/actions/CAction.php(107): <strong>ReflectionMethod</strong>-&gt;<strong>invokeArgs</strong>(quotas, array("994254", false))				</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 app expanded">
			<td class="number">
				#6			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/srv/www/htdocs/survey/application/core/Survey_Common_Action.php(82): <strong>CAction</strong>-&gt;<strong>runWithParamsInternal</strong>(quotas,
 ReflectionMethod, array("surveyid" =&gt; "994254", "sa" =&gt; "index", 
"iSurveyId" =&gt; "994254", "iSurveyID" =&gt; "994254"))				</div>

				<div class="code"><pre><span class="ln">77</span>             $oMethod = new ReflectionMethod($this, $sDefault);
<span class="ln">78</span>         }
<span class="ln">79</span> 
<span class="ln">80</span>         // We're all good to go, let's execute it
<span class="ln">81</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">82</span>         return parent::runWithParamsInternal($this, $oMethod, $params);
</span><span class="ln">83</span>     }
<span class="ln">84</span> 
<span class="ln">85</span>     /**
<span class="ln">86</span>     * Some functions have different parameters, which are just an alias of the
<span class="ln">87</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">
				#7			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/srv/www/htdocs/survey/framework/web/CController.php(309): <strong>Survey_Common_Action</strong>-&gt;<strong>runWithParams</strong>(array("surveyid" =&gt; "994254", "sa" =&gt; "index"))				</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">
				#8			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/srv/www/htdocs/survey/framework/web/CController.php(287): <strong>CController</strong>-&gt;<strong>runAction</strong>(quotas)				</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">
				#9			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/srv/www/htdocs/survey/framework/web/CController.php(266): <strong>CController</strong>-&gt;<strong>runActionWithFilters</strong>(quotas, 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 app collapsed">
			<td class="number">
				#10			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/srv/www/htdocs/survey/application/controllers/AdminController.php(159): <strong>CController</strong>-&gt;<strong>run</strong>("quotas")				</div>

				<div class="code"><pre><span class="ln">154</span>                 Yii::app()-&gt;session['redirectopage'] = Yii::app()-&gt;request-&gt;requestUri;
<span class="ln">155</span> 
<span class="ln">156</span>                 $this-&gt;redirect($this-&gt;createUrl('/admin/authentication/login'));
<span class="ln">157</span>             }
<span class="ln">158</span> 
<span class="error"><span class="ln error-ln">159</span>             return parent::run($action);
</span><span class="ln">160</span>     }
<span class="ln">161</span> 
<span class="ln">162</span>     /**
<span class="ln">163</span>     * Routes all the actions to their respective places
<span class="ln">164</span>     *
</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;/srv/www/htdocs/survey/framework/web/CWebApplication.php(276): <strong>AdminController</strong>-&gt;<strong>run</strong>("quotas")				</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">
				#12			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/srv/www/htdocs/survey/framework/web/CWebApplication.php(135): <strong>CWebApplication</strong>-&gt;<strong>runController</strong>("admin/quotas/sa/index")				</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">
				#13			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/srv/www/htdocs/survey/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 collapsed">
			<td class="number">
				#14			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/srv/www/htdocs/survey/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-12-06 21:50:22 Apache/2.2.21 (Linux/SUSE) <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>
994254.htm (23,508 bytes)   
994255.htm (23,508 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[42601]: Syntax error: 7 ERROR:  syntax error at or near "X318X3172"<br>
LINE 1: ...OUNT(*) FROM "lime_survey_994254" "t" WHERE 994254X318X3172=...<br>
                                                             ^. The SQL 
statement executed was: SELECT COUNT(*) FROM "lime_survey_994254" "t" 
WHERE 994254X318X3172=:ycp0	</p>

	<div class="source">
		<p class="file">/srv/www/htdocs/survey/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;/srv/www/htdocs/survey/framework/db/CDbCommand.php(425): <strong>CDbCommand</strong>-&gt;<strong>queryInternal</strong>("fetchColumn", 0, array())				</div>

				<div class="code"><pre><span class="ln">420</span>      * @return mixed the value of the first column in the first row of the query result. False is returned if there is no value.
<span class="ln">421</span>      * @throws CException execution failed
<span class="ln">422</span>      */
<span class="ln">423</span>     public function queryScalar($params=array())
<span class="ln">424</span>     {
<span class="error"><span class="ln error-ln">425</span>         $result=$this-&gt;queryInternal('fetchColumn',0,$params);
</span><span class="ln">426</span>         if(is_resource($result) &amp;&amp; get_resource_type($result)==='stream')
<span class="ln">427</span>             return stream_get_contents($result);
<span class="ln">428</span>         else
<span class="ln">429</span>             return $result;
<span class="ln">430</span>     }
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#1			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/srv/www/htdocs/survey/framework/db/ar/CActiveRecord.php(1536): <strong>CDbCommand</strong>-&gt;<strong>queryScalar</strong>()				</div>

				<div class="code"><pre><span class="ln">1531</span>         $builder=$this-&gt;getCommandBuilder();
<span class="ln">1532</span>         $criteria=$builder-&gt;createCriteria($condition,$params);
<span class="ln">1533</span>         $this-&gt;applyScopes($criteria);
<span class="ln">1534</span> 
<span class="ln">1535</span>         if(empty($criteria-&gt;with))
<span class="error"><span class="ln error-ln">1536</span>             return $builder-&gt;createCountCommand($this-&gt;getTableSchema(),$criteria)-&gt;queryScalar();
</span><span class="ln">1537</span>         else
<span class="ln">1538</span>         {
<span class="ln">1539</span>             $finder=new CActiveFinder($this,$criteria-&gt;with);
<span class="ln">1540</span>             return $finder-&gt;count($criteria);
<span class="ln">1541</span>         }
</pre></div>			</td>
		</tr>
						<tr class="trace app expanded">
			<td class="number">
				#2			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/srv/www/htdocs/survey/application/helpers/common_helper.php(5963): <strong>CActiveRecord</strong>-&gt;<strong>count</strong>(CDbCriteria)				</div>

				<div class="code"><pre><span class="ln">5958</span>         $criteria = new CDbCriteria;
<span class="ln">5959</span> 
<span class="ln">5960</span>         foreach ($fields_list as $fieldname)
<span class="ln">5961</span>             $criteria-&gt;mergeWith($fields_query[$fieldname]);
<span class="ln">5962</span> 
<span class="error"><span class="ln error-ln">5963</span>         $result = Survey_dynamic::model($iSurveyId)-&gt;count($criteria);
</span><span class="ln">5964</span>     }
<span class="ln">5965</span> 
<span class="ln">5966</span>     return $result;
<span class="ln">5967</span> }
<span class="ln">5968</span> 
</pre></div>			</td>
		</tr>
						<tr class="trace app expanded">
			<td class="number">
				#3			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/srv/www/htdocs/survey/application/controllers/admin/quotas.php(107): <strong>getQuotaCompletedCount</strong>("994254", 11)				</div>

				<div class="code"><pre><span class="ln">102</span>             $aViewUrls['output'] = '';
<span class="ln">103</span>             //loop through all quotas
<span class="ln">104</span>             foreach ($aResult as $aQuotaListing)
<span class="ln">105</span>             {
<span class="ln">106</span>                 $totalquotas += $aQuotaListing['qlimit'];
<span class="error"><span class="ln error-ln">107</span>                 $completed = getQuotaCompletedCount($iSurveyId, $aQuotaListing['id']);
</span><span class="ln">108</span>                 $highlight = ($completed &gt;= $aQuotaListing['qlimit']) ? '' : "style='color: orange'"; //Incomplete quotas displayed in red
<span class="ln">109</span>                 $totalcompleted = $totalcompleted + $completed;
<span class="ln">110</span>                 $csvoutput[] = $aQuotaListing['name'] . "," . $aQuotaListing['qlimit'] . "," . $completed . "," . ($aQuotaListing['qlimit'] - $completed) . "\r\n";
<span class="ln">111</span> 
<span class="ln">112</span>                 if ($quickreport != false)
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#4			</td>
			<td class="content">
				<div class="trace-file">
										&nbsp;unknown(0): <strong>quotas</strong>-&gt;<strong>index</strong>("994254", false)				</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;/srv/www/htdocs/survey/framework/web/actions/CAction.php(107): <strong>ReflectionMethod</strong>-&gt;<strong>invokeArgs</strong>(quotas, array("994254", false))				</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 app expanded">
			<td class="number">
				#6			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/srv/www/htdocs/survey/application/core/Survey_Common_Action.php(82): <strong>CAction</strong>-&gt;<strong>runWithParamsInternal</strong>(quotas,
 ReflectionMethod, array("surveyid" =&gt; "994254", "sa" =&gt; "index", 
"iSurveyId" =&gt; "994254", "iSurveyID" =&gt; "994254"))				</div>

				<div class="code"><pre><span class="ln">77</span>             $oMethod = new ReflectionMethod($this, $sDefault);
<span class="ln">78</span>         }
<span class="ln">79</span> 
<span class="ln">80</span>         // We're all good to go, let's execute it
<span class="ln">81</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">82</span>         return parent::runWithParamsInternal($this, $oMethod, $params);
</span><span class="ln">83</span>     }
<span class="ln">84</span> 
<span class="ln">85</span>     /**
<span class="ln">86</span>     * Some functions have different parameters, which are just an alias of the
<span class="ln">87</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">
				#7			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/srv/www/htdocs/survey/framework/web/CController.php(309): <strong>Survey_Common_Action</strong>-&gt;<strong>runWithParams</strong>(array("surveyid" =&gt; "994254", "sa" =&gt; "index"))				</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">
				#8			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/srv/www/htdocs/survey/framework/web/CController.php(287): <strong>CController</strong>-&gt;<strong>runAction</strong>(quotas)				</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">
				#9			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/srv/www/htdocs/survey/framework/web/CController.php(266): <strong>CController</strong>-&gt;<strong>runActionWithFilters</strong>(quotas, 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 app collapsed">
			<td class="number">
				#10			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/srv/www/htdocs/survey/application/controllers/AdminController.php(159): <strong>CController</strong>-&gt;<strong>run</strong>("quotas")				</div>

				<div class="code"><pre><span class="ln">154</span>                 Yii::app()-&gt;session['redirectopage'] = Yii::app()-&gt;request-&gt;requestUri;
<span class="ln">155</span> 
<span class="ln">156</span>                 $this-&gt;redirect($this-&gt;createUrl('/admin/authentication/login'));
<span class="ln">157</span>             }
<span class="ln">158</span> 
<span class="error"><span class="ln error-ln">159</span>             return parent::run($action);
</span><span class="ln">160</span>     }
<span class="ln">161</span> 
<span class="ln">162</span>     /**
<span class="ln">163</span>     * Routes all the actions to their respective places
<span class="ln">164</span>     *
</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;/srv/www/htdocs/survey/framework/web/CWebApplication.php(276): <strong>AdminController</strong>-&gt;<strong>run</strong>("quotas")				</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">
				#12			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/srv/www/htdocs/survey/framework/web/CWebApplication.php(135): <strong>CWebApplication</strong>-&gt;<strong>runController</strong>("admin/quotas/sa/index")				</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">
				#13			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/srv/www/htdocs/survey/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 collapsed">
			<td class="number">
				#14			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/srv/www/htdocs/survey/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-12-06 21:55:59 Apache/2.2.21 (Linux/SUSE) <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>
994255.htm (23,508 bytes)   
Bug heat2
Complete LimeSurvey version number (& build)121121
I will donate to the project if issue is resolvedNo
BrowserFirefox
Database type & versionPostgres 9.1.1
Server OS (if known)OpenSuse 12.1.7
Webserver software & version (if known)Apache 2.2.21
PHP VersionPHP 5.3.8
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-12-07 08:54

administrator   ~22994

Please update to the latest version and retry. If it still does not work, please re-open the issue.

Issue History

Date Modified Username Field Change
2012-12-06 23:07 naumbidzovski New Issue
2012-12-06 23:07 naumbidzovski File Added: limesurvey_survey_994254(1).lss
2012-12-06 23:08 naumbidzovski File Added: 994254.htm
2012-12-06 23:08 naumbidzovski File Added: 994255.htm
2012-12-07 08:54 c_schmitz Note Added: 22994
2012-12-07 08:54 c_schmitz Status new => closed
2012-12-07 08:54 c_schmitz Assigned To => c_schmitz
2012-12-07 08:54 c_schmitz Resolution open => unable to reproduce
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing