CDbException CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.. The SQL statement executed was: SELECT a.ugid, a.name, a.owner_id, b.uid FROM lime_user_groups AS a LEFT JOIN lime_user_in_groups AS b ON a.ugid = b.ugid WHERE uid = 1 ORDER BY name /var/www/html/survey/framework/db/CDbCommand.php(528) 516 return $result; 517 } 518 catch(Exception $e) 519 { 520 if($this->_connection->enableProfiling) 521 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query'); 522 $errorInfo = $e instanceof PDOException ? $e->errorInfo : null; 523 $message = $e->getMessage(); 524 Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.', 525 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand'); 526 if(YII_DEBUG) 527 $message .= '. The SQL statement executed was: '.$this->getText().$par; 528 throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}', 529 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo); 530 } 531 } 532 533 /** 534 * Builds a SQL SELECT statement from the given query specification. 535 * @param array $query the query specification in name-value pairs. The following 536 * query options are supported: {@link select}, {@link distinct}, {@link from}, 537 * {@link where}, {@link join}, {@link group}, {@link having}, {@link order}, 538 * {@link limit}, {@link offset} and {@link union}. 539 * @return string the SQL statement 540 * @since 1.1.6 Stack Trace #0 – /var/www/html/survey/framework/db/CDbCommand.php(372): CDbCommand->queryInternal("", 0, array()) 367 * @return CDbDataReader the reader object for fetching the query result 368 * @throws CException execution failed 369 */ 370 public function query($params=array()) 371 { 372 return $this->queryInternal('',0,$params); 373 } 374 375 /** 376 * Executes the SQL statement and returns all rows. 377 * @param boolean $fetchAssociative whether each row should be returned as an associated array with #1 – /var/www/html/survey/application/helpers/common_helper.php(7130): CDbCommand->query() 7125 { 7126 $clang = Yii::app()->lang; 7127 //$squery = "SELECT ugid, name FROM ".db_table_name('user_groups') ." WHERE owner_id = {Yii::app()->session['loginID']} ORDER BY name"; 7128 $squery = "SELECT a.ugid, a.name, a.owner_id, b.uid FROM {{user_groups}} AS a LEFT JOIN {{user_in_groups}} AS b ON a.ugid = b.ugid WHERE uid = ".Yii::app()->session['loginID']." ORDER BY name"; 7129 7130 $sresult = Yii::app()->db->createCommand($squery)->query(); //Checked 7131 if (!$sresult) {return "Database Error";} 7132 $selecter = ""; 7133 foreach ($sresult->readAll() as $row) 7134 { 7135 $groupnames[] = $row; #2 – /var/www/html/survey/application/helpers/common_helper.php(7610): getUserGroupList() 7605 7606 $surveyselecter = ""; 7607 7608 if (Yii::app()->getConfig('usercontrolSameGroupPolicy') == true) 7609 { 7610 $authorizedGroupsList=getUserGroupList(NULL, 'simplegidarray'); 7611 } 7612 7613 foreach($surveyidresult->readAll() as $sv) 7614 { 7615 if (Yii::app()->getConfig('usercontrolSameGroupPolicy') == false || #3 – /var/www/html/survey/application/controllers/admin/surveypermission.php(176): getSurveyUserGroupList() 171 . "gT("Please select a user first","js")."'); return false;}\"/>" 172 . "" 173 . "\n" 174 . "
"; 181 #4 unknown(0): surveypermission->index(null, "simplegidarray") #5 – /var/www/html/survey/framework/web/actions/CAction.php(107): ReflectionMethod->invokeArgs("htmloptions", "428269") 102 else if($param->isDefaultValueAvailable()) 103 $ps[]=$param->getDefaultValue(); 104 else 105 return false; 106 } 107 $method->invokeArgs($object,$ps); 108 return true; 109 } 110 } #6 – /var/www/html/survey/application/core/Survey_Common_Action.php(82): CAction->runWithParamsInternal("428269") 77 $oMethod = new ReflectionMethod($this, $sDefault); 78 } 79 80 // We're all good to go, let's execute it 81 // runWithParamsInternal would automatically get the parameters of the method and populate them as required with the params 82 return parent::runWithParamsInternal($this, $oMethod, $params); 83 } 84 85 /** 86 * Some functions have different parameters, which are just an alias of the 87 * usual parameters we're getting in the url. This function just populates #7 – /var/www/html/survey/framework/web/CController.php(309): Survey_Common_Action->runWithParams(surveypermission, array("428269")) 304 { 305 $priorAction=$this->_action; 306 $this->_action=$action; 307 if($this->beforeAction($action)) 308 { 309 if($action->runWithParams($this->getActionParams())===false) 310 $this->invalidActionParams($action); 311 else 312 $this->afterAction($action); 313 } 314 $this->_action=$priorAction; #8 – /var/www/html/survey/framework/web/CController.php(287): CController->runAction(surveypermission, ReflectionMethod, array("surveyid" => "428269", "sa" => "view", "iSurveyId" => "428269", "iSurveyID" => "428269")) 282 * @see runAction 283 */ 284 public function runActionWithFilters($action,$filters) 285 { 286 if(empty($filters)) 287 $this->runAction($action); 288 else 289 { 290 $priorAction=$this->_action; 291 $this->_action=$action; 292 CFilterChain::create($this,$action,$filters)->run(); #9 – /var/www/html/survey/framework/web/CController.php(266): CController->runActionWithFilters(array("surveyid" => "428269", "sa" => "view")) 261 { 262 if(($parent=$this->getModule())===null) 263 $parent=Yii::app(); 264 if($parent->beforeControllerAction($this,$action)) 265 { 266 $this->runActionWithFilters($action,$this->filters()); 267 $parent->afterControllerAction($this,$action); 268 } 269 } 270 else 271 $this->missingAction($actionID); #10 – /var/www/html/survey/application/controllers/AdminController.php(159): CController->run(surveypermission) 154 Yii::app()->session['redirectopage'] = Yii::app()->request->requestUri; 155 156 $this->redirect($this->createUrl('/admin/authentication/login')); 157 } 158 159 return parent::run($action); 160 } 161 162 /** 163 * Routes all the actions to their respective places 164 * #11 – /var/www/html/survey/framework/web/CWebApplication.php(276): AdminController->run(surveypermission, array()) 271 { 272 list($controller,$actionID)=$ca; 273 $oldController=$this->_controller; 274 $this->_controller=$controller; 275 $controller->init(); 276 $controller->run($actionID); 277 $this->_controller=$oldController; 278 } 279 else 280 throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".', 281 array('{route}'=>$route===''?$this->defaultController:$route))); #12 – /var/www/html/survey/framework/web/CWebApplication.php(135): CWebApplication->runController("surveypermission") 130 foreach(array_splice($this->catchAllRequest,1) as $name=>$value) 131 $_GET[$name]=$value; 132 } 133 else 134 $route=$this->getUrlManager()->parseUrl($this->getRequest()); 135 $this->runController($route); 136 } 137 138 /** 139 * Registers the core application components. 140 * This method overrides the parent implementation by registering additional core components. #13 – /var/www/html/survey/framework/base/CApplication.php(162): CWebApplication->processRequest("surveypermission") 157 */ 158 public function run() 159 { 160 if($this->hasEventHandler('onBeginRequest')) 161 $this->onBeginRequest(new CEvent($this)); 162 $this->processRequest(); 163 if($this->hasEventHandler('onEndRequest')) 164 $this->onEndRequest(new CEvent($this)); 165 } 166 167 /** #14 – /var/www/html/survey/index.php(178): CApplication->run("admin/surveypermission/sa/view") 173 * 174 */ 175 require_once BASEPATH . 'yii' . EXT; 176 require_once APPPATH . 'core/LSYii_Application' . EXT; 177 178 Yii::createApplication('LSYii_Application', APPPATH . 'config/config' . EXT)->run(); 179 180 /* End of file index.php */ 181 /* Location: ./index.php */ 2012-11-14 12:17:12 Apache Yii Framework/1.1.10