CDbException CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'TQ29460' in 'WHERE'. The SQL statement executed was: SELECT * FROM `lime_responses_498594` `t` WHERE `TQ29460` != '' /var/www/limesurvey.host/htdocs/vendor/yiisoft/yii/framework/db/CDbCommand.php(543) 531 { 532 if($this->_connection->enableProfiling) 533 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query'); 534 535 $errorInfo=$e instanceof PDOException ? $e->errorInfo : null; 536 $message=$e->getMessage(); 537 Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.', 538 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand'); 539 540 if(YII_DEBUG) 541 $message.='. The SQL statement executed was: '.$this->getText().$par; 542 543 throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}', 544 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo); 545 } 546 } 547 548 /** 549 * Builds a SQL SELECT statement from the given query specification. 550 * @param array $query the query specification in name-value pairs. The following 551 * query options are supported: {@link select}, {@link distinct}, {@link from}, 552 * {@link where}, {@link join}, {@link group}, {@link having}, {@link order}, 553 * {@link limit}, {@link offset} and {@link union}. 554 * @throws CDbException if "from" key is not present in given query parameter 555 * @return string the SQL statement Stack Trace #0 + –  /var/www/limesurvey.host/htdocs/vendor/yiisoft/yii/framework/db/CDbCommand.php(396): CDbCommand->queryInternal() 391 * An empty array is returned if the query results in nothing. 392 * @throws CException execution failed 393 */ 394 public function queryAll($fetchAssociative=true,$params=array()) 395 { 396 return $this->queryInternal('fetchAll',$fetchAssociative ? $this->_fetchMode : PDO::FETCH_NUM, $params); 397 } 398 399 /** 400 * Executes the SQL statement and returns the first row of the result. 401 * This is a convenient method of {@link query} when only the first row of data is needed. #1 + –  /var/www/limesurvey.host/htdocs/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(1359): CDbCommand->queryAll() 1354 if(empty($criteria->with)) 1355 { 1356 if(!$all) 1357 $criteria->limit=1; 1358 $command=$this->getCommandBuilder()->createFindCommand($this->getTableSchema(),$criteria); 1359 return $all ? $this->populateRecords($command->queryAll(), true, $criteria->index) : $this->populateRecord($command->queryRow()); 1360 } 1361 else 1362 { 1363 $finder=$this->getActiveFinder($criteria->with); 1364 return $finder->query($criteria,$all); #2 + –  /var/www/limesurvey.host/htdocs/application/models/LSActiveRecord.php(72): CActiveRecord->query() 67 * @since 1.1.7 68 */ 69 protected function query($criteria, $all = false, $asAR = true) 70 { 71 if ($asAR === true) { 72 return parent::query($criteria, $all); 73 } else { 74 $this->beforeFind(); 75 $this->applyScopes($criteria); 76 if (!$all) { 77 $criteria->limit = 1; #3 + –  /var/www/limesurvey.host/htdocs/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(1478): LSActiveRecord->query() 1473 */ 1474 public function findAll($condition='',$params=array()) 1475 { 1476 Yii::trace(get_class($this).'.findAll()','system.db.ar.CActiveRecord'); 1477 $criteria=$this->getCommandBuilder()->createCriteria($condition,$params); 1478 return $this->query($criteria,true); 1479 } 1480 1481 /** 1482 * Finds a single active record with the specified primary key. 1483 * See {@link find()} for detailed explanation about $condition and $params. #4 + –  /var/www/limesurvey.host/htdocs/application/helpers/admin/statistics_helper.php(4262): CActiveRecord->findAll() 4257 if ($sortmethod && !in_array($sortmethod, ['ASC', 'DESC'])) { 4258 $sortmethod = ""; 4259 } 4260 $search['order'] = $sortby . ' ' . $sortmethod; 4261 } 4262 $results = SurveyDynamic::model($surveyid)->findAll($search); 4263 $output = array(); 4264 foreach ($results as $row) { 4265 $row->decrypt(); 4266 $output[] = array("id" => $row['id'], "value" => $row[$column]); 4267 } #5 + –  /var/www/limesurvey.host/htdocs/application/helpers/admin/statistics_helper.php(2406): statistics_helper->_listcolumn() 2401 2402 if ($browse === true && !empty($_POST['showtextinline']) && $outputType == 'xls') { 2403 $headXLS = array(); 2404 $headXLS[] = array(gT("ID"), gT("Response")); 2405 2406 $result2 = $this->_listcolumn($surveyid, $sColumnName); 2407 2408 foreach ($result2 as $row2) { 2409 $tableXLS[] = array($row2['id'], $row2['value']); 2410 } 2411 } #6 + –  /var/www/limesurvey.host/htdocs/application/helpers/admin/statistics_helper.php(4043): statistics_helper->displayResults() 4038 $outputs = $this->buildOutputList($rt, $language, $surveyid, $outputType, $sql, $sLanguageCode); 4039 $sOutputHTML .= $outputs['statisticsoutput']; 4040 //2. Collect and Display results ####################################################################### 4041 if (isset($outputs['alist']) && $outputs['alist']) { 4042 //Make sure there really is an answerlist, and if so: 4043 $display = $this->displayResults($outputs, $results, $rt, $outputType, $surveyid, $sql, $usegraph, $browse, $sLanguageCode); 4044 $sOutputHTML .= $display['statisticsoutput']; 4045 $aStatisticsData = array_merge($aStatisticsData, $display['astatdata']); 4046 } //end if -> collect and display results 4047 4048 #7 + –  /var/www/limesurvey.host/htdocs/application/controllers/admin/Statistics.php(479): statistics_helper->generate_statistics() 474 case 'pdf': 475 $helper->generate_statistics($surveyid, $summary, $summary, $usegraph, $outputType, 'D', $statlang); 476 exit; 477 break; 478 case 'xls': 479 $helper->generate_statistics($surveyid, $summary, $summary, $usegraph, $outputType, 'DD', $statlang); 480 exit; 481 break; 482 default: 483 break; 484 } #8  unknown(0): Statistics->run() #9 + –  /var/www/limesurvey.host/htdocs/vendor/yiisoft/yii/framework/web/actions/CAction.php(114): ReflectionMethod->invokeArgs() 109 elseif($param->isDefaultValueAvailable()) 110 $ps[]=$param->getDefaultValue(); 111 else 112 return false; 113 } 114 $method->invokeArgs($object,$ps); 115 return true; 116 } 117 } #10 + –  /var/www/limesurvey.host/htdocs/application/core/SurveyCommonAction.php(86): CAction->runWithParamsInternal() 81 $oMethod = new ReflectionMethod($this, $sDefault); 82 } 83 84 // We're all good to go, let's execute it 85 // runWithParamsInternal would automatically get the parameters of the method and populate them as required with the params 86 return parent::runWithParamsInternal($this, $oMethod, $params); 87 } 88 89 /** 90 * Some functions have different parameters, which are just an alias of the 91 * usual parameters we're getting in the url. This function just populates #11 + –  /var/www/limesurvey.host/htdocs/vendor/yiisoft/yii/framework/web/CController.php(308): SurveyCommonAction->runWithParams() 303 { 304 $priorAction=$this->_action; 305 $this->_action=$action; 306 if($this->beforeAction($action)) 307 { 308 if($action->runWithParams($this->getActionParams())===false) 309 $this->invalidActionParams($action); 310 else 311 $this->afterAction($action); 312 } 313 $this->_action=$priorAction; #12 + –  /var/www/limesurvey.host/htdocs/vendor/yiisoft/yii/framework/web/CController.php(286): CController->runAction() 281 * @see runAction 282 */ 283 public function runActionWithFilters($action,$filters) 284 { 285 if(empty($filters)) 286 $this->runAction($action); 287 else 288 { 289 $priorAction=$this->_action; 290 $this->_action=$action; 291 CFilterChain::create($this,$action,$filters)->run(); #13 + –  /var/www/limesurvey.host/htdocs/vendor/yiisoft/yii/framework/web/CController.php(265): CController->runActionWithFilters() 260 { 261 if(($parent=$this->getModule())===null) 262 $parent=Yii::app(); 263 if($parent->beforeControllerAction($this,$action)) 264 { 265 $this->runActionWithFilters($action,$this->filters()); 266 $parent->afterControllerAction($this,$action); 267 } 268 } 269 else 270 $this->missingAction($actionID); #14 + –  /var/www/limesurvey.host/htdocs/application/controllers/AdminController.php(203): CController->run() 198 $this->runModuleController($action); 199 // this will redirect the default action to the new controller previously "admin/index" or "admin" to "dashboard/view" 200 if (empty($action) || $action === 'index') { 201 $this->redirect($this->createUrl('dashboard/view')); 202 } 203 return parent::run($action); 204 } 205 206 /** 207 * Starting with LS4, 3rd party developer can extends any of the LimeSurve controllers. 208 * #15 + –  /var/www/limesurvey.host/htdocs/vendor/yiisoft/yii/framework/web/CWebApplication.php(282): AdminController->run() 277 { 278 list($controller,$actionID)=$ca; 279 $oldController=$this->_controller; 280 $this->_controller=$controller; 281 $controller->init(); 282 $controller->run($actionID); 283 $this->_controller=$oldController; 284 } 285 else 286 throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".', 287 array('{route}'=>$route===''?$this->defaultController:$route))); #16 + –  /var/www/limesurvey.host/htdocs/vendor/yiisoft/yii/framework/web/CWebApplication.php(141): CWebApplication->runController() 136 foreach(array_splice($this->catchAllRequest,1) as $name=>$value) 137 $_GET[$name]=$value; 138 } 139 else 140 $route=$this->getUrlManager()->parseUrl($this->getRequest()); 141 $this->runController($route); 142 } 143 144 /** 145 * Registers the core application components. 146 * This method overrides the parent implementation by registering additional core components. #17 + –  /var/www/limesurvey.host/htdocs/vendor/yiisoft/yii/framework/base/CApplication.php(185): CWebApplication->processRequest() 180 public function run() 181 { 182 if($this->hasEventHandler('onBeginRequest')) 183 $this->onBeginRequest(new CEvent($this)); 184 register_shutdown_function(array($this,'end'),0,false); 185 $this->processRequest(); 186 if($this->hasEventHandler('onEndRequest')) 187 $this->onEndRequest(new CEvent($this)); 188 } 189 190 /** #18 + –  /var/www/limesurvey.host/htdocs/index.php(161): CApplication->run() 156 require_once APPPATH . 'core/LSYii_Application' . EXT; 157 158 $config = require_once(APPPATH . 'config/internal' . EXT); 159 160 Yii::$enableIncludePath = false; 161 Yii::createApplication('LSYii_Application', $config)->run(); 162 163 /* End of file index.php */ 164 /* Location: ./index.php */ 2026-06-30 13:22:36 Apache Yii Framework/1.1.32