CDbException
/webfs/php-packages/older-yii/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 |
+
–
/webfs/php-packages/older-yii/vendor/yiisoft/yii/framework/db/CDbCommand.php(396): CDbCommand->queryInternal("fetchAll", array(2), array()) 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 |
+
–
/webfs/www/webapps/staff-profiles/protected/models/StaffProfile.php(542): CDbCommand->queryAll(5) 537 //$sql="Select profile_group_users_view.order_id, profile_group_users_view.POS_REF, spd.staff_id, spd.forenames, spd.surname, spd.email, spd.title, spd.telephone, spd.telephone, spd.website, spd.twitter, spd.room_number, spd.building_en, spd.building_cy, spd.web_contact_email,spd.web_contact_telephone FROM staff_profile_display".VERSION." AS spd join profile_group_users_view on spd.staff_id=profile_group_users_view.staff_id where spd.staff_id IN (".$criteria.") ORDER BY -order_id DESC;"; 538 $sql="select profile_group_users_view.order_id, profile_group_users_view.POS_REF, staff_profile_display3.staff_id, forenames, surname, email, title, telephone, telephone, website, twitter, google_scholar, room_number, building_en, building_cy, web_contact_email,web_contact_telephone from staff_profile_display3 join profile_group_users_view on staff_profile_display3.staff_id=profile_group_users_view.staff_id where staff_profile_display3.staff_id IN (".$criteria.") AND profile_group_users_view.group_id=".$group_code." ORDER BY -profile_group_users_view.order_id DESC, surname ASC, forenames ASC;"; 539 $staff_details=array(); 540 $sorted=array(); 541 $command = Yii::app()->db->createCommand( $sql ); 542 foreach( $command->queryAll( PDO::FETCH_OBJ) as $row ){ 543 if((array_key_exists($row["staff_id"],$contracts)) AND (array_key_exists($row["POS_REF"], $contracts[$row["staff_id"]]))){ 544 $row['is_telephone']=substr($contracts[$row["staff_id"]][$row["POS_REF"]]['is_telephone'], -4); 545 $row['job_title']=$contracts[$row["staff_id"]][$row["POS_REF"]]['job_title']; 546 } 547 if( isset($row["is_telephone"]) AND !isset($row["telephone"])){ |
#2 |
+
–
/webfs/www/webapps/staff-profiles/protected/controllers/ListingController.php(152): StaffProfile->getGroupList("''", null, null, null, ...) 147 $real_group_name=$group_info[$localised_name]; 148 $group_users=$this->findAPEXGroupUsers($group_id); 149 $criteria="'".implode("' , '", $group_users)."'"; 150 $linktype=null; 151 $staffprofile = StaffProfile::model(); 152 $staffprofile->getGroupList($criteria, $group_id, null, null, $this->staff_list_photo_enabled($dept_code)); 153 $staffprofile->link=$linktype; 154 $staffprofile->render(); 155 $staffprofile->renderer->group_info=array("group_name"=>$real_group_name, "group_desc"=>$group_info['group_desc'], "group_id"=>$group_id); 156 $staffprofile->renderer->is_group=true; 157 |
#3 |
unknown(0): ListingController->actionGroup("academic")
|
#4 |
+
–
/webfs/php-packages/older-yii/vendor/yiisoft/yii/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(ListingController, array("academic")) 104 elseif($param->isDefaultValueAvailable()) 105 $ps[]=$param->getDefaultValue(); 106 else 107 return false; 108 } 109 $method->invokeArgs($object,$ps); 110 return true; 111 } 112 } |
#5 |
+
–
/webfs/php-packages/older-yii/vendor/yiisoft/yii/framework/web/actions/CInlineAction.php(47): CAction->runWithParamsInternal(ListingController, ReflectionMethod, array("id" => "academic", "filter" => "-staff")) 42 { 43 $methodName='action'.$this->getId(); 44 $controller=$this->getController(); 45 $method=new ReflectionMethod($controller, $methodName); 46 if($method->getNumberOfParameters()>0) 47 return $this->runWithParamsInternal($controller, $method, $params); 48 49 $controller->$methodName(); 50 return true; 51 } 52 } |
#6 |
+
–
/webfs/php-packages/older-yii/vendor/yiisoft/yii/framework/web/CController.php(308): CInlineAction->runWithParams(array("id" => "academic", "filter" => "-staff")) 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; |
#7 |
+
–
/webfs/php-packages/older-yii/vendor/yiisoft/yii/framework/web/filters/CFilterChain.php(134): CController->runAction(CInlineAction) 129 $filter=$this->itemAt($this->filterIndex++); 130 Yii::trace('Running filter '.($filter instanceof CInlineFilter ? get_class($this->controller).'.filter'.$filter->name.'()':get_class($filter).'.filter()'),'system.web.filters.CFilterChain'); 131 $filter->filter($this); 132 } 133 else 134 $this->controller->runAction($this->action); 135 } 136 } |
#8 |
+
–
/webfs/php-packages/older-yii/vendor/yiisoft/yii/framework/web/filters/CFilter.php(40): CFilterChain->run() 35 */ 36 public function filter($filterChain) 37 { 38 if($this->preFilter($filterChain)) 39 { 40 $filterChain->run(); 41 $this->postFilter($filterChain); 42 } 43 } 44 45 /** |
#9 |
+
–
/webfs/php-packages/older-yii/vendor/yiisoft/yii/framework/web/CController.php(1148): CFilter->filter(CFilterChain) 1143 */ 1144 public function filterAccessControl($filterChain) 1145 { 1146 $filter=new CAccessControlFilter; 1147 $filter->setRules($this->accessRules()); 1148 $filter->filter($filterChain); 1149 } 1150 1151 /** 1152 * Returns a persistent page state value. 1153 * A page state is a variable that is persistent across POST requests of the same page. |
#10 |
+
–
/webfs/php-packages/older-yii/vendor/yiisoft/yii/framework/web/filters/CInlineFilter.php(58): CController->filterAccessControl(CFilterChain) 53 * @param CFilterChain $filterChain the filter chain that the filter is on. 54 */ 55 public function filter($filterChain) 56 { 57 $method='filter'.$this->name; 58 $filterChain->controller->$method($filterChain); 59 } 60 } |
#11 |
+
–
/webfs/php-packages/older-yii/vendor/yiisoft/yii/framework/web/filters/CFilterChain.php(131): CInlineFilter->filter(CFilterChain) 126 { 127 if($this->offsetExists($this->filterIndex)) 128 { 129 $filter=$this->itemAt($this->filterIndex++); 130 Yii::trace('Running filter '.($filter instanceof CInlineFilter ? get_class($this->controller).'.filter'.$filter->name.'()':get_class($filter).'.filter()'),'system.web.filters.CFilterChain'); 131 $filter->filter($this); 132 } 133 else 134 $this->controller->runAction($this->action); 135 } 136 } |
#12 |
+
–
/webfs/php-packages/older-yii/vendor/yiisoft/yii/framework/web/CController.php(291): CFilterChain->run() 286 $this->runAction($action); 287 else 288 { 289 $priorAction=$this->_action; 290 $this->_action=$action; 291 CFilterChain::create($this,$action,$filters)->run(); 292 $this->_action=$priorAction; 293 } 294 } 295 296 /** |
#13 |
+
–
/webfs/php-packages/older-yii/vendor/yiisoft/yii/framework/web/CController.php(265): CController->runActionWithFilters(CInlineAction, array("accessControl", "postOnly + delete")) 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 |
+
–
/webfs/php-packages/older-yii/vendor/yiisoft/yii/framework/web/CWebApplication.php(282): CController->run("group") 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))); |
#15 |
+
–
/webfs/php-packages/older-yii/vendor/yiisoft/yii/framework/web/CWebApplication.php(141): CWebApplication->runController("listing/group/academic/-staff") 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. |
#16 |
+
–
/webfs/php-packages/older-yii/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 /** |
#17 |
+
–
/webfs/www/webapps/staff-profiles/index.php(90): CApplication->run() 85 } 86 else{ 87 error_reporting(0); 88 } 89 require_once($yii); 90 Yii::createWebApplication($config)->run(); 91 92 function is_internal(){ 93 $internal = null; 94 $revdns = gethostbyaddr($_SERVER['REMOTE_ADDR']); 95 if (($revdns !== $_SERVER['REMOTE_ADDR']) && preg_match('/\.aber\.ac\.uk$/', $revdns)){ |
2022-06-25 09:25:46 Apache/2.4.25 (Debian) Yii Framework/1.1.22