07328: Quotas can not be viewed / processed in an active poll

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

07328	Bug reports	Other	public	2013-02-25 11:33	2013-03-05 08:45

Reporter	sgle01	Assigned To	c_schmitz
Priority	high	Severity	block
Status	closed	Resolution	fixed
Product Version	2.00+
Fixed in Version	2.00+

Summary	07328: Quotas can not be viewed / processed in an active poll
Description	If you create a survey with quotas, you can't edit or view the quotas in the admin panel any more, after the first survey has completet. An internal server error occurs. Browser: Internal Server Error CDbCommand failed to execute the SQL statement: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "X252X6194" LINE 1: ...UNT() FROM "lime_survey_615259" "t" WHERE (615259X252X6194=... The SQL Server log: CET ERROR: syntax error at or near "X57X909" at character 60 CET STATEMENT: SELECT COUNT() FROM "lime_survey_669915" "t" WHERE (669915X57X909='1') AND (submitdate IS NOT NULL)
Steps To Reproduce	create a new survey with any question add a new quota add a new answer for this quota activate the survey Up to here there is no Problem. fill out the survey open the survey in admin panel go to quotas: Now you get an Error.
Additional Information	The problem is the lack of quotation of the column name "669915X57X909". With MySQL there is no problem.
Tags	No tags attached.
Attached Files	CDbException.html (23,627 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 "X252X6194"<br /> LINE 1: ...UNT() FROM "lime_survey_615259" "t" WHERE (615259X252X6194=...<br /> ^. The SQL statement executed was: SELECT COUNT() FROM "lime_survey_615259" "t" WHERE (615259X252X6194=:ycp0) AND (submitdate IS NOT NULL) </p> <div class="source"> <p class="file">/var/www/limesurvey/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->_connection->enableProfiling) <span class="ln">521</span> Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query'); <span class="ln">522</span> $errorInfo = $e instanceof PDOException ? $e->errorInfo : null; <span class="ln">523</span> $message = $e->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}'=>$method, '{error}'=>$message, '{sql}'=>$this->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->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}'=>$message)),(int)$e->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>  /var/www/limesurvey/framework/db/CDbCommand.php(425): <strong>CDbCommand</strong>-><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->queryInternal('fetchColumn',0,$params); </span><span class="ln">426</span> if(is_resource($result) && 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>  /var/www/limesurvey/framework/db/ar/CActiveRecord.php(1536): <strong>CDbCommand</strong>-><strong>queryScalar</strong>() </div> <div class="code"><pre><span class="ln">1531</span> $builder=$this->getCommandBuilder(); <span class="ln">1532</span> $criteria=$builder->createCriteria($condition,$params); <span class="ln">1533</span> $this->applyScopes($criteria); <span class="ln">1534</span> <span class="ln">1535</span> if(empty($criteria->with)) <span class="error"><span class="ln error-ln">1536</span> return $builder->createCountCommand($this->getTableSchema(),$criteria)->queryScalar(); </span><span class="ln">1537</span> else <span class="ln">1538</span> { <span class="ln">1539</span> $finder=new CActiveFinder($this,$criteria->with); <span class="ln">1540</span> return $finder->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>  /var/www/limesurvey/application/helpers/common_helper.php(5948): <strong>CActiveRecord</strong>-><strong>count</strong>(CDbCriteria) </div> <div class="code"><pre><span class="ln">5943</span> $criteria = new CDbCriteria; <span class="ln">5944</span> <span class="ln">5945</span> foreach ($fields_list as $fieldname) <span class="ln">5946</span> $criteria->mergeWith($fields_query[$fieldname]); <span class="ln">5947</span> $criteria->mergeWith(array('condition'=>"submitdate IS NOT NULL")); <span class="error"><span class="ln error-ln">5948</span> $result = Survey_dynamic::model($iSurveyId)->count($criteria); </span><span class="ln">5949</span> } <span class="ln">5950</span> <span class="ln">5951</span> return $result; <span class="ln">5952</span> } <span class="ln">5953</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>  /var/www/limesurvey/application/controllers/admin/quotas.php(107): <strong>getQuotaCompletedCount</strong>("615259", 20) </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 >= $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">  unknown(0): <strong>quotas</strong>-><strong>index</strong>("615259", 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>  /var/www/limesurvey/framework/web/actions/CAction.php(107): <strong>ReflectionMethod</strong>-><strong>invokeArgs</strong>(quotas, array("615259", false)) </div> <div class="code"><pre><span class="ln">102</span> else if($param->isDefaultValueAvailable()) <span class="ln">103</span> $ps[]=$param->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->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>  /var/www/limesurvey/application/core/Survey_Common_Action.php(100): <strong>CAction</strong>-><strong>runWithParamsInternal</strong>(quotas, ReflectionMethod, array("surveyid" => "615259", "sa" => "index", "iSurveyId" => "615259", "iSurveyID" => "615259")) </div> <div class="code"><pre><span class="ln">095</span> $oMethod = new ReflectionMethod($this, $sDefault); <span class="ln">096</span> } <span class="ln">097</span> <span class="ln">098</span> // We're all good to go, let's execute it <span class="ln">099</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">100</span> return parent::runWithParamsInternal($this, $oMethod, $params); </span><span class="ln">101</span> } <span class="ln">102</span> <span class="ln">103</span> /* <span class="ln">104</span> * Some functions have different parameters, which are just an alias of the <span class="ln">105</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>  /var/www/limesurvey/framework/web/CController.php(309): <strong>Survey_Common_Action</strong>-><strong>runWithParams</strong>(array("surveyid" => "615259", "sa" => "index")) </div> <div class="code"><pre><span class="ln">304</span> { <span class="ln">305</span> $priorAction=$this->_action; <span class="ln">306</span> $this->_action=$action; <span class="ln">307</span> if($this->beforeAction($action)) <span class="ln">308</span> { <span class="error"><span class="ln error-ln">309</span> if($action->runWithParams($this->getActionParams())===false) </span><span class="ln">310</span> $this->invalidActionParams($action); <span class="ln">311</span> else <span class="ln">312</span> $this->afterAction($action); <span class="ln">313</span> } <span class="ln">314</span> $this->_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>  /var/www/limesurvey/framework/web/CController.php(287): <strong>CController</strong>-><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->runAction($action); </span><span class="ln">288</span> else <span class="ln">289</span> { <span class="ln">290</span> $priorAction=$this->_action; <span class="ln">291</span> $this->_action=$action; <span class="ln">292</span> CFilterChain::create($this,$action,$filters)->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>  /var/www/limesurvey/framework/web/CController.php(266): <strong>CController</strong>-><strong>runActionWithFilters</strong>(quotas, array()) </div> <div class="code"><pre><span class="ln">261</span> { <span class="ln">262</span> if(($parent=$this->getModule())===null) <span class="ln">263</span> $parent=Yii::app(); <span class="ln">264</span> if($parent->beforeControllerAction($this,$action)) <span class="ln">265</span> { <span class="error"><span class="ln error-ln">266</span> $this->runActionWithFilters($action,$this->filters()); </span><span class="ln">267</span> $parent->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->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>  /var/www/limesurvey/application/controllers/AdminController.php(169): <strong>CController</strong>-><strong>run</strong>("quotas") </div> <div class="code"><pre><span class="ln">164</span> $this->redirect($this->createUrl('/admin/authentication/sa/login')); <span class="ln">165</span> } <span class="ln">166</span> <span class="ln">167</span> } <span class="ln">168</span> <span class="error"><span class="ln error-ln">169</span> return parent::run($action); </span><span class="ln">170</span> } <span class="ln">171</span> <span class="ln">172</span> /* <span class="ln">173</span> * Routes all the actions to their respective places <span class="ln">174</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>  /var/www/limesurvey/framework/web/CWebApplication.php(276): <strong>AdminController</strong>-><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->_controller; <span class="ln">274</span> $this->_controller=$controller; <span class="ln">275</span> $controller->init(); <span class="error"><span class="ln error-ln">276</span> $controller->run($actionID); </span><span class="ln">277</span> $this->_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}'=>$route===''?$this->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>  /var/www/limesurvey/framework/web/CWebApplication.php(135): <strong>CWebApplication</strong>-><strong>runController</strong>("admin/quotas/sa/index") </div> <div class="code"><pre><span class="ln">130</span> foreach(array_splice($this->catchAllRequest,1) as $name=>$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->getUrlManager()->parseUrl($this->getRequest()); <span class="error"><span class="ln error-ln">135</span> $this->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>  /var/www/limesurvey/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->hasEventHandler('onBeginRequest')) <span class="ln">161</span> $this->onBeginRequest(new CEvent($this)); <span class="error"><span class="ln error-ln">162</span> $this->processRequest(); </span><span class="ln">163</span> if($this->hasEventHandler('onEndRequest')) <span class="ln">164</span> $this->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>  /var/www/limesurvey/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 . '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)->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"> 2013-02-25 11:59:28 Apache/2.2.14 (Ubuntu) <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> CDbException.html (23,627 bytes)

Bug heat	4
Complete LimeSurvey version number (& build)	130219
I will donate to the project if issue is resolved	No
Browser
Database type & version	Postgresql 9.1
Server OS (if known)	Ubuntu Server 10.04
Webserver software & version (if known)	Apache 2.2
PHP Version	5.3.2

User List	There are no users monitoring this issue.

c_schmitz 2013-02-25 11:43 administrator ~24280	Please set debug to 2 in /application/config/config.php and attach the full error dump as html file. Thank you!

sgle01 2013-02-25 12:08 reporter ~24281	I have uploaded the error dump named "CDbException.html".

c_schmitz 2013-03-01 21:48 administrator ~24459	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=11707

c_schmitz 2013-03-02 16:34 administrator ~24488	Fix committed to 2.1 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=11736

c_schmitz 2013-03-05 08:45 administrator ~24539	2.00+ Build 130305 released.

LimeSurvey: master 38cc39b3 2013-03-01 16:23 c_schmitz Details Diff	Fixed issue 07328: Quotas can not be viewed / processed in an active poll	Affected Issues 07328
	mod - application/helpers/common_helper.php	Diff File
LimeSurvey: 2.1 12875b7a 2013-03-02 15:33 c_schmitz Details Diff	Fixed issue 07328: Quotas can not be viewed / processed in an active poll	Affected Issues 07328
	mod - application/helpers/common_helper.php	Diff File

Date Modified	Username	Field	Change
2013-02-25 11:33	sgle01	New Issue
2013-02-25 11:43	c_schmitz	Note Added: 24280
2013-02-25 11:43	c_schmitz	Assigned To	=> c_schmitz
2013-02-25 11:43	c_schmitz	Status	new => feedback
2013-02-25 12:05	sgle01	File Added: CDbException.html
2013-02-25 12:08	sgle01	Note Added: 24281
2013-02-25 12:08	sgle01	Status	feedback => assigned
2013-03-01 16:24	c_schmitz	Status	assigned => resolved
2013-03-01 16:24	c_schmitz	Fixed in Version	=> 2.00+
2013-03-01 16:24	c_schmitz	Resolution	open => fixed
2013-03-01 21:48	c_schmitz	Changeset attached	=> LimeSurvey master 38cc39b3
2013-03-01 21:48	c_schmitz	Note Added: 24459
2013-03-02 16:34	c_schmitz	Changeset attached	=> LimeSurvey 2.1 12875b7a
2013-03-02 16:34	c_schmitz	Note Added: 24488
2013-03-05 08:45	c_schmitz	Note Added: 24539
2013-03-05 08:45	c_schmitz	Status	resolved => closed

View Issue Details

Users monitoring this issue

Activities

Related Changesets

Issue History