View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
18423 | Bug reports | Other | public | 2022-10-19 09:05 | 2023-04-25 14:49 |
Reporter | dsi.dvt | Assigned To | DenisChenu | ||
Priority | none | Severity | crash | ||
Status | closed | Resolution | fixed | ||
Product Version | 5.4.x | ||||
Fixed in Version | 5.6.x | ||||
Summary | 18423: SQL error when quota enabled on postgresql | ||||
Description | Enabling quota on a survey when using postgreSQL triggers the following error on first page submit: 500 : Erreur interne au serveur The problem comes from application/helpers/frontend_helper.php, line 1868. ':value' value is an integer (1) but in DB schema, it is a text. Replacing 1 by '1' fixed the problem. | ||||
Steps To Reproduce | Install limesurvey with postgresql as DB. Expected resultswitch to 2nd page of the survey Actual resultSQL error | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 22 | ||||
Complete LimeSurvey version number (& build) | 5.4.5+221010 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Firefox | ||||
Database type & version | Postgresql 13 | ||||
Server OS (if known) | Linux | ||||
Webserver software & version (if known) | nginx 1.18.0 | ||||
PHP Version | php-fpm 8.1.9 | ||||
Ouh ! I have a lot of warning when import your lss in postger/debug set Must check if have same in mariadb |
|
Issue CDbException.html (28,977 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 n'a pas pu exécuter la commande SQL: SQLSTATE[42883]: Undefined function: 7 ERREUR: l'opérateur n'existe pas : text = integer<br> LINE 1: ... "t" WHERE "t"."qid"=69 AND (attribute='hidden' AND value=1)<br> ^<br> HINT: Aucun opérateur ne correspond au nom donné et aux types d'arguments.<br> Vous devez ajouter des conversions explicites de type.. The SQL statement executed was: SELECT COUNT(*) FROM "lime_question_attributes" "t" WHERE "t"."qid"=69 AND (attribute=:attribute AND value=:value) </p> <div class="source"> <p class="file">/data/webdev/pgsql/third_party/yiisoft/yii/framework/db/CDbCommand.php(543)</p> <div class="code"><pre><span class="ln">531</span> { <span class="ln">532</span> if($this->_connection->enableProfiling) <span class="ln">533</span> Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query'); <span class="ln">534</span> <span class="ln">535</span> $errorInfo=$e instanceof PDOException ? $e->errorInfo : null; <span class="ln">536</span> $message=$e->getMessage(); <span class="ln">537</span> Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.', <span class="ln">538</span> array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand'); <span class="ln">539</span> <span class="ln">540</span> if(YII_DEBUG) <span class="ln">541</span> $message.='. The SQL statement executed was: '.$this->getText().$par; <span class="ln">542</span> <span class="error"><span class="ln error-ln">543</span> throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}', </span><span class="ln">544</span> array('{error}'=>$message)),(int)$e->getCode(),$errorInfo); <span class="ln">545</span> } <span class="ln">546</span> } <span class="ln">547</span> <span class="ln">548</span> /** <span class="ln">549</span> * Builds a SQL SELECT statement from the given query specification. <span class="ln">550</span> * @param array $query the query specification in name-value pairs. The following <span class="ln">551</span> * query options are supported: {@link select}, {@link distinct}, {@link from}, <span class="ln">552</span> * {@link where}, {@link join}, {@link group}, {@link having}, {@link order}, <span class="ln">553</span> * {@link limit}, {@link offset} and {@link union}. <span class="ln">554</span> * @throws CDbException if "from" key is not present in given query parameter <span class="ln">555</span> * @return string the SQL statement </pre></div> </div> <div class="traces"> <h2>Stack Trace</h2> <table style="width:100%;"> <tbody><tr class="trace core collapsed"> <td class="number"> #0 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/webdev/pgsql/third_party/yiisoft/yii/framework/db/CDbCommand.php(433): <strong>CDbCommand</strong>-><strong>queryInternal</strong>() </div> <div class="code"><pre><span class="ln">428</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">429</span> * @throws CException execution failed <span class="ln">430</span> */ <span class="ln">431</span> public function queryScalar($params=array()) <span class="ln">432</span> { <span class="error"><span class="ln error-ln">433</span> $result=$this->queryInternal('fetchColumn',0,$params); </span><span class="ln">434</span> if(is_resource($result) && get_resource_type($result)==='stream') <span class="ln">435</span> return stream_get_contents($result); <span class="ln">436</span> else <span class="ln">437</span> return $result; <span class="ln">438</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> /data/webdev/pgsql/third_party/yiisoft/yii/framework/db/ar/CActiveRecord.php(1637): <strong>CDbCommand</strong>-><strong>queryScalar</strong>() </div> <div class="code"><pre><span class="ln">1632</span> $this->beforeCount(); <span class="ln">1633</span> $criteria=$builder->createColumnCriteria($this->getTableSchema(),$attributes,$condition,$params,$prefix); <span class="ln">1634</span> $this->applyScopes($criteria); <span class="ln">1635</span> <span class="ln">1636</span> if(empty($criteria->with)) <span class="error"><span class="ln error-ln">1637</span> return $builder->createCountCommand($this->getTableSchema(),$criteria)->queryScalar(); </span><span class="ln">1638</span> else <span class="ln">1639</span> { <span class="ln">1640</span> $finder=$this->getActiveFinder($criteria->with); <span class="ln">1641</span> return $finder->count($criteria); <span class="ln">1642</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> /data/webdev/pgsql/application/helpers/frontend_helper.php(1868): <strong>CActiveRecord</strong>-><strong>countByAttributes</strong>() </div> <div class="code"><pre><span class="ln">1863</span> <span class="ln">1864</span> // Condition to count quota : <span class="ln">1865</span> // Answers are the same in quota + an answer is submitted at this time (bPostedField) <span class="ln">1866</span> // OR all questions is hidden (bAllHidden) <span class="ln">1867</span> $bAllHidden = QuestionAttribute::model() <span class="error"><span class="ln error-ln">1868</span> ->countByAttributes(array('qid' => $aQuotaQid), 'attribute=:attribute AND value=:value', array(':attribute' => 'hidden',':value' => 1)) == count($aQuotaQid); </span><span class="ln">1869</span> <span class="ln">1870</span> if ($iMatchedAnswers == count($aQuotaFields) && ($bPostedField || $bAllHidden)) { <span class="ln">1871</span> if ($oQuota->qlimit == 0) { <span class="ln">1872</span> // Always add the quota if qlimit==0 <span class="ln">1873</span> $aMatchedQuotas[] = $oQuota->viewArray; </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> /data/webdev/pgsql/application/helpers/expressions/em_manager_helper.php(5198): <strong>checkCompletedQuota</strong>() </div> <div class="code"><pre><span class="ln">5193</span> } <span class="ln">5194</span> } elseif ($this->surveyOptions['allowsave'] && isset($_SESSION[$this->sessid]['scid'])) { <span class="ln">5195</span> SavedControl::model()->updateByPk($_SESSION[$this->sessid]['scid'], ['saved_thisstep' => $_SESSION[$this->sessid]['step']]); <span class="ln">5196</span> } <span class="ln">5197</span> // Check Quotas <span class="error"><span class="ln error-ln">5198</span> $aQuotas = checkCompletedQuota($this->sid, true); </span><span class="ln">5199</span> if ($aQuotas && !empty($aQuotas)) { <span class="ln">5200</span> checkCompletedQuota($this->sid); // will create a page and quit: why not use it directly ? <span class="ln">5201</span> } else { <span class="ln">5202</span> if ($finished && ($oResponse->submitdate == null || Survey::model()->findByPk($this->sid)->alloweditaftercompletion == 'Y')) { <span class="ln">5203</span> /* Less update : just do what you need to to */ </pre></div> </td> </tr> <tr class="trace app expanded"> <td class="number"> #4 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/webdev/pgsql/application/helpers/expressions/em_manager_helper.php(4899): <strong>LimeExpressionManager</strong>-><strong>_UpdateValuesInDatabase</strong>() </div> <div class="code"><pre><span class="ln">4894</span> if (!$result['relevant'] || $result['hidden']) { <span class="ln">4895</span> // then skip this group <span class="ln">4896</span> continue; <span class="ln">4897</span> } else { <span class="ln">4898</span> // display new group <span class="error"><span class="ln error-ln">4899</span> $message .= $LEM->_UpdateValuesInDatabase(); </span><span class="ln">4900</span> $LEM->runtimeTimings[] = [__METHOD__, (microtime(true) - $now)]; <span class="ln">4901</span> $LEM->lastMoveResult = [ <span class="ln">4902</span> 'finished' => false, <span class="ln">4903</span> 'message' => $message, <span class="ln">4904</span> 'gseq' => $LEM->currentGroupSeq, </pre></div> </td> </tr> <tr class="trace app collapsed"> <td class="number"> #5 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/webdev/pgsql/application/helpers/SurveyRuntimeHelper.php(952): <strong>LimeExpressionManager</strong>::<strong>NavigateForwards</strong>() </div> <div class="code"><pre><span class="ln">947</span> $this->aMoveResult = false; // so display welcome page again <span class="ln">948</span> } <span class="ln">949</span> } <span class="ln">950</span> <span class="ln">951</span> if ($this->sMove == "movenext") { <span class="error"><span class="ln error-ln">952</span> $this->aMoveResult = LimeExpressionManager::NavigateForwards(); </span><span class="ln">953</span> } <span class="ln">954</span> <span class="ln">955</span> if (($this->sMove == 'movesubmit')) { <span class="ln">956</span> if ($this->sSurveyMode == 'survey') { <span class="ln">957</span> $this->aMoveResult = LimeExpressionManager::NavigateForwards(); </pre></div> </td> </tr> <tr class="trace app collapsed"> <td class="number"> #6 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/webdev/pgsql/application/helpers/SurveyRuntimeHelper.php(647): <strong>SurveyRuntimeHelper</strong>-><strong>setMoveResult</strong>() </div> <div class="code"><pre><span class="ln">642</span> $this->initFirstStep(); // If it's the first time user load this survey, will init session and LEM <span class="ln">643</span> $this->initTotalAndMaxSteps(); <span class="ln">644</span> $this->checkIfUseBrowserNav(); // Check if user used browser navigation, or relaoded page <span class="ln">645</span> if ($this->sMove != 'clearcancel' && $this->sMove != 'confirmquota') { <span class="ln">646</span> $this->checkPrevStep(); // Check if prev step is set, else set it <span class="error"><span class="ln error-ln">647</span> $this->setMoveResult(); </span><span class="ln">648</span> $this->checkClearCancel(); <span class="ln">649</span> $this->setPrevStep(); <span class="ln">650</span> $this->checkIfFinished(); <span class="ln">651</span> $this->setStep(); <span class="ln">652</span> </pre></div> </td> </tr> <tr class="trace app collapsed"> <td class="number"> #7 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/webdev/pgsql/application/helpers/SurveyRuntimeHelper.php(203): <strong>SurveyRuntimeHelper</strong>-><strong>initMove</strong>() </div> <div class="code"><pre><span class="ln">198</span> // 1: We check if token and/or captcha form shouls be shown <span class="ln">199</span> if (!isset($_SESSION[$this->LEMsessid]['step'])) { <span class="ln">200</span> $this->showTokenOrCaptchaFormsIfNeeded(); <span class="ln">201</span> } <span class="ln">202</span> if (!$this->previewgrp && !$this->previewquestion) { <span class="error"><span class="ln error-ln">203</span> $this->initMove(); // main methods to init session, LEM, moves, errors, etc </span><span class="ln">204</span> $this->checkForDataSecurityAccepted(); // must be called after initMove to allow LEM to be initialized <span class="ln">205</span> if (EmCacheHelper::useCache()) { <span class="ln">206</span> $this->aSurveyInfo['emcache'] = true; <span class="ln">207</span> } <span class="ln">208</span> $this->checkQuotas(); // check quotas (then the process will stop here) </pre></div> </td> </tr> <tr class="trace app collapsed"> <td class="number"> #8 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/webdev/pgsql/application/controllers/survey/index.php(618): <strong>SurveyRuntimeHelper</strong>-><strong>run</strong>() </div> <div class="code"><pre><span class="ln">613</span> unset($redata); <span class="ln">614</span> $redata = compact(array_keys(get_defined_vars())); <span class="ln">615</span> Yii::import('application.helpers.SurveyRuntimeHelper'); <span class="ln">616</span> $tmp = new SurveyRuntimeHelper(); <span class="ln">617</span> // try { <span class="error"><span class="ln error-ln">618</span> $tmp->run($surveyid, $redata); </span><span class="ln">619</span> // } catch (WrongTemplateVersionException $ex) { <span class="ln">620</span> // echo $ex->getMessage(); <span class="ln">621</span> // } <span class="ln">622</span> } <span class="ln">623</span> </pre></div> </td> </tr> <tr class="trace app collapsed"> <td class="number"> #9 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/webdev/pgsql/application/controllers/survey/index.php(22): <strong>Index</strong>-><strong>action</strong>() </div> <div class="code"><pre><span class="ln">17</span> public $oTemplate; <span class="ln">18</span> <span class="ln">19</span> public function run() <span class="ln">20</span> { <span class="ln">21</span> useFirebug(); <span class="error"><span class="ln error-ln">22</span> $this->action(); </span><span class="ln">23</span> } <span class="ln">24</span> <span class="ln">25</span> public function action() <span class="ln">26</span> { <span class="ln">27</span> global $surveyid; </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> /data/webdev/pgsql/third_party/yiisoft/yii/framework/web/actions/CAction.php(76): <strong>Index</strong>-><strong>run</strong>() </div> <div class="code"><pre><span class="ln">71</span> { <span class="ln">72</span> $method=new ReflectionMethod($this, 'run'); <span class="ln">73</span> if($method->getNumberOfParameters()>0) <span class="ln">74</span> return $this->runWithParamsInternal($this, $method, $params); <span class="ln">75</span> <span class="error"><span class="ln error-ln">76</span> $this->run(); </span><span class="ln">77</span> return true; <span class="ln">78</span> } <span class="ln">79</span> <span class="ln">80</span> /** <span class="ln">81</span> * Executes a method of an object with the supplied named parameters. </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #11 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/webdev/pgsql/third_party/yiisoft/yii/framework/web/CController.php(308): <strong>CAction</strong>-><strong>runWithParams</strong>() </div> <div class="code"><pre><span class="ln">303</span> { <span class="ln">304</span> $priorAction=$this->_action; <span class="ln">305</span> $this->_action=$action; <span class="ln">306</span> if($this->beforeAction($action)) <span class="ln">307</span> { <span class="error"><span class="ln error-ln">308</span> if($action->runWithParams($this->getActionParams())===false) </span><span class="ln">309</span> $this->invalidActionParams($action); <span class="ln">310</span> else <span class="ln">311</span> $this->afterAction($action); <span class="ln">312</span> } <span class="ln">313</span> $this->_action=$priorAction; </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> /data/webdev/pgsql/third_party/yiisoft/yii/framework/web/CController.php(286): <strong>CController</strong>-><strong>runAction</strong>() </div> <div class="code"><pre><span class="ln">281</span> * @see runAction <span class="ln">282</span> */ <span class="ln">283</span> public function runActionWithFilters($action,$filters) <span class="ln">284</span> { <span class="ln">285</span> if(empty($filters)) <span class="error"><span class="ln error-ln">286</span> $this->runAction($action); </span><span class="ln">287</span> else <span class="ln">288</span> { <span class="ln">289</span> $priorAction=$this->_action; <span class="ln">290</span> $this->_action=$action; <span class="ln">291</span> CFilterChain::create($this,$action,$filters)->run(); </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> /data/webdev/pgsql/third_party/yiisoft/yii/framework/web/CController.php(265): <strong>CController</strong>-><strong>runActionWithFilters</strong>() </div> <div class="code"><pre><span class="ln">260</span> { <span class="ln">261</span> if(($parent=$this->getModule())===null) <span class="ln">262</span> $parent=Yii::app(); <span class="ln">263</span> if($parent->beforeControllerAction($this,$action)) <span class="ln">264</span> { <span class="error"><span class="ln error-ln">265</span> $this->runActionWithFilters($action,$this->filters()); </span><span class="ln">266</span> $parent->afterControllerAction($this,$action); <span class="ln">267</span> } <span class="ln">268</span> } <span class="ln">269</span> else <span class="ln">270</span> $this->missingAction($actionID); </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #14 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/webdev/pgsql/third_party/yiisoft/yii/framework/web/CWebApplication.php(282): <strong>CController</strong>-><strong>run</strong>() </div> <div class="code"><pre><span class="ln">277</span> { <span class="ln">278</span> list($controller,$actionID)=$ca; <span class="ln">279</span> $oldController=$this->_controller; <span class="ln">280</span> $this->_controller=$controller; <span class="ln">281</span> $controller->init(); <span class="error"><span class="ln error-ln">282</span> $controller->run($actionID); </span><span class="ln">283</span> $this->_controller=$oldController; <span class="ln">284</span> } <span class="ln">285</span> else <span class="ln">286</span> throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".', <span class="ln">287</span> array('{route}'=>$route===''?$this->defaultController:$route))); </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #15 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/webdev/pgsql/third_party/yiisoft/yii/framework/web/CWebApplication.php(141): <strong>CWebApplication</strong>-><strong>runController</strong>() </div> <div class="code"><pre><span class="ln">136</span> foreach(array_splice($this->catchAllRequest,1) as $name=>$value) <span class="ln">137</span> $_GET[$name]=$value; <span class="ln">138</span> } <span class="ln">139</span> else <span class="ln">140</span> $route=$this->getUrlManager()->parseUrl($this->getRequest()); <span class="error"><span class="ln error-ln">141</span> $this->runController($route); </span><span class="ln">142</span> } <span class="ln">143</span> <span class="ln">144</span> /** <span class="ln">145</span> * Registers the core application components. <span class="ln">146</span> * This method overrides the parent implementation by registering additional core components. </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #16 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/webdev/pgsql/third_party/yiisoft/yii/framework/base/CApplication.php(185): <strong>CWebApplication</strong>-><strong>processRequest</strong>() </div> <div class="code"><pre><span class="ln">180</span> public function run() <span class="ln">181</span> { <span class="ln">182</span> if($this->hasEventHandler('onBeginRequest')) <span class="ln">183</span> $this->onBeginRequest(new CEvent($this)); <span class="ln">184</span> register_shutdown_function(array($this,'end'),0,false); <span class="error"><span class="ln error-ln">185</span> $this->processRequest(); </span><span class="ln">186</span> if($this->hasEventHandler('onEndRequest')) <span class="ln">187</span> $this->onEndRequest(new CEvent($this)); <span class="ln">188</span> } <span class="ln">189</span> <span class="ln">190</span> /** </pre></div> </td> </tr> <tr class="trace app collapsed"> <td class="number"> #17 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/webdev/pgsql/index.php(192): <strong>CApplication</strong>-><strong>run</strong>() </div> <div class="code"><pre><span class="ln">187</span> require_once APPPATH . 'core/LSYii_Application' . EXT; <span class="ln">188</span> <span class="ln">189</span> $config = require_once(APPPATH . 'config/internal' . EXT); <span class="ln">190</span> <span class="ln">191</span> Yii::$enableIncludePath = false; <span class="error"><span class="ln error-ln">192</span> Yii::createApplication('LSYii_Application', $config)->run(); </span><span class="ln">193</span> <span class="ln">194</span> /* End of file index.php */ <span class="ln">195</span> /* Location: ./index.php */ </pre></div> </td> </tr> </tbody></table> </div> <div class="version"> 2022-10-19 09:51:17 nginx/1.18.0 <a href="https://www.yiiframework.com/">Yii Framework</a>/1.1.26 </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> <div id="grammalecte_menu_main_button_shadow_host" style="width: 0px; height: 0px;"></div></body><script src="CDbException_files/api.js"></script></html> |
|
I don't know if this can be the reason but my limesurvey was initially installed with version 3.22.10+200323 and then updated to 3.25.2+201131, 5.3.23+220705 and finally to 5.4.5+221010 |
|
I check what is the SQL instruction on 3.X since it work and need same :). |
|
@dsi.dvt : if you find time to test https://github.com/LimeSurvey/LimeSurvey/pull/2688 |
|
Hello, |
|
The PR changed since the last customer test. |
|
I had the same problem and the fix works well (I have LS 5.4.14 plus this hotfix, with PostgreSQL). |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=34468 |
|
Fixed in Release 6.0.1+230411 |
|
Fix committed to 5.x branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=34543 |
|
LimeSurvey: master f4233db8 2023-04-06 14:59:01 Committer: GitHub Details Diff |
Fixed issue 18423: SQL error when quota enabled on postgresql (#2688) |
Affected Issues 18423 |
|
mod - application/helpers/frontend_helper.php | Diff File | ||
LimeSurvey: 5.x 99d75184 2023-04-06 14:59:01 Committer: ollehar Details Diff |
Fixed issue 18423: SQL error when quota enabled on postgresql (#2688) |
Affected Issues 18423 |
|
mod - application/helpers/frontend_helper.php | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2022-10-19 09:05 | dsi.dvt | New Issue | |
2022-10-19 09:05 | dsi.dvt | File Added: limesurvey_survey_418831.lss | |
2022-10-19 09:49 | DenisChenu | Note Added: 72361 | |
2022-10-19 09:49 | DenisChenu | Bug heat | 0 => 2 |
2022-10-19 09:52 | DenisChenu | Note Added: 72362 | |
2022-10-19 09:52 | DenisChenu | File Added: CDbException.html | |
2022-10-19 09:53 | dsi.dvt | Note Added: 72363 | |
2022-10-19 09:53 | dsi.dvt | Bug heat | 2 => 4 |
2022-10-19 09:53 | DenisChenu | Assigned To | => DenisChenu |
2022-10-19 09:53 | DenisChenu | Status | new => confirmed |
2022-10-19 09:53 | DenisChenu | Status | confirmed => assigned |
2022-10-19 09:54 | DenisChenu | Note Added: 72364 | |
2022-10-26 08:57 | DenisChenu | Assigned To | DenisChenu => |
2022-10-26 08:57 | DenisChenu | Status | assigned => ready for code review |
2022-10-26 08:57 | DenisChenu | Note Added: 72425 | |
2023-01-17 17:51 | DenisChenu | Status | ready for code review => ready for testing |
2023-01-17 17:51 | DenisChenu | Note Added: 73490 | |
2023-01-20 12:40 | guest | Bug heat | 4 => 10 |
2023-01-20 12:45 | DarioRoig | Issue Monitored: DarioRoig | |
2023-01-20 12:45 | DarioRoig | Bug heat | 10 => 12 |
2023-02-02 16:52 | riqcles | Note Added: 73640 | |
2023-02-02 16:52 | riqcles | Bug heat | 12 => 14 |
2023-02-02 18:24 | DenisChenu | Assigned To | => ollehar |
2023-02-02 18:24 | DenisChenu | Status | ready for testing => ready for merge |
2023-02-21 14:45 | ollehar | Status | ready for merge => ready for testing |
2023-02-21 14:45 | ollehar | Note Added: 73904 | |
2023-02-21 14:45 | ollehar | Bug heat | 14 => 16 |
2023-04-06 12:21 | seccanj | Issue Monitored: seccanj | |
2023-04-06 12:21 | seccanj | Bug heat | 16 => 18 |
2023-04-06 12:24 | seccanj | Note Added: 74415 | |
2023-04-06 12:24 | seccanj | Bug heat | 18 => 20 |
2023-04-06 14:59 | DenisChenu | Changeset attached | => LimeSurvey master f4233db8 |
2023-04-06 14:59 | DenisChenu | Note Added: 74418 | |
2023-04-06 14:59 | DenisChenu | Assigned To | ollehar => DenisChenu |
2023-04-06 14:59 | DenisChenu | Resolution | open => fixed |
2023-04-07 17:02 | DenisChenu | Status | ready for testing => resolved |
2023-04-07 17:02 | DenisChenu | Fixed in Version | => 5.6.x |
2023-04-11 10:07 | LimeBot | Note Added: 74450 | |
2023-04-11 10:07 | LimeBot | Status | resolved => closed |
2023-04-11 10:07 | LimeBot | Bug heat | 20 => 22 |
2023-04-25 14:49 | ollehar | Changeset attached | => LimeSurvey 5.x 99d75184 |
2023-04-25 14:49 | DenisChenu | Note Added: 74633 |