/home/birdcom/domains/birdwatchingvietnam.net/public_html/framework/db/CDbCommand.php(541)
529 { 530 if($this->_connection->enableProfiling) 531 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query'); 532 533 $errorInfo=$e instanceof PDOException ? $e->errorInfo : null; 534 $message=$e->getMessage(); 535 Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.', 536 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand'); 537 538 if(YII_DEBUG) 539 $message.='. The SQL statement executed was: '.$this->getText().$par; 540 541 throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}', 542 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo); 543 } 544 } 545 546 /** 547 * Builds a SQL SELECT statement from the given query specification. 548 * @param array $query the query specification in name-value pairs. The following 549 * query options are supported: {@link select}, {@link distinct}, {@link from}, 550 * {@link where}, {@link join}, {@link group}, {@link having}, {@link order}, 551 * {@link limit}, {@link offset} and {@link union}. 552 * @return string the SQL statement 553 * @since 1.1.6
#0 |
+
–
/home/birdcom/domains/birdwatchingvietnam.net/public_html/framework/db/CDbCommand.php(395): CDbCommand->queryInternal("fetchAll", array(2), array()) 390 * An empty array is returned if the query results in nothing. 391 * @throws CException execution failed 392 */ 393 public function queryAll($fetchAssociative=true,$params=array()) 394 { 395 return $this->queryInternal('fetchAll',$fetchAssociative ? $this->_fetchMode : PDO::FETCH_NUM, $params); 396 } 397 398 /** 399 * Executes the SQL statement and returns the first row of the result. 400 * This is a convenient method of {@link query} when only the first row of data is needed. |
#1 |
+
–
/home/birdcom/domains/birdwatchingvietnam.net/public_html/protected/models/Bird.php(188): CDbCommand->queryAll() 183 184 //$sql = 'select c.birdID, c.tenen, c.imagePC, substring(tenen,pos+1) AS last_name from (SELECT b.*, instr(b.tenen," ") AS pos FROM bird b) as c order by last_name ASC '; 185 $sql = "select birdID, tenen, tenkhoahoc, tenvn, imagePC, SUBSTRING_INDEX(tenen, ' ', -1) AS last_name from bird b where birdID in (" . $ids . ") order by last_name ASC "; 186 $data = Yii::app()->db 187 ->createCommand($sql) 188 ->queryAll(); 189 190 $birdlist = array(); 191 192 for($x=0;$x<count($data); $x++){ 193 $obj = new Bird();//Bird::model(); |
#2 |
+
–
/home/birdcom/domains/birdwatchingvietnam.net/public_html/protected/controllers/PhotographerController.php(17): Bird->getBirdByEnglishNameAndIds("") 12 $criteria->select = 'birdID'; 13 $listbirdid = Birdimages::model()->findAll($criteria); 14 15 $arr = CHtml::listData($listbirdid, 'birdID', 'birdID'); 16 $ids = implode(",",$arr); 17 $birdlist = Bird::model()->getBirdByEnglishNameAndIds($ids); 18 19 $tempBirdimages = Birdimages::model()->find("photographer like '" . $searchby . "'"); 20 } 21 // Data 22 $data = array( |
#3 |
+
–
/home/birdcom/domains/birdwatchingvietnam.net/public_html/framework/web/actions/CInlineAction.php(49): PhotographerController->actionIndex() 44 $controller=$this->getController(); 45 $method=new ReflectionMethod($controller, $methodName); 46 if($method->getNumberOfParameters()>0) 47 return $this->runWithParamsInternal($controller, $method, $params); 48 else 49 return $controller->$methodName(); 50 } 51 52 } |
#4 |
+
–
/home/birdcom/domains/birdwatchingvietnam.net/public_html/framework/web/CController.php(308): CInlineAction->runWithParams(array("title" => "matsumura")) 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; |
#5 |
+
–
/home/birdcom/domains/birdwatchingvietnam.net/public_html/framework/web/CController.php(286): CController->runAction(CInlineAction) 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(); |
#6 |
+
–
/home/birdcom/domains/birdwatchingvietnam.net/public_html/framework/web/CController.php(265): CController->runActionWithFilters(CInlineAction, array()) 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); |
#7 |
+
–
/home/birdcom/domains/birdwatchingvietnam.net/public_html/framework/web/CWebApplication.php(282): CController->run("index") 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))); |
#8 |
+
–
/home/birdcom/domains/birdwatchingvietnam.net/public_html/framework/web/CWebApplication.php(141): CWebApplication->runController("photographer/index") 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. |
#9 |
+
–
/home/birdcom/domains/birdwatchingvietnam.net/public_html/framework/base/CApplication.php(169): CWebApplication->processRequest() 164 public function run() 165 { 166 if($this->hasEventHandler('onBeginRequest')) 167 $this->onBeginRequest(new CEvent($this)); 168 register_shutdown_function(array($this,'end'),0,false); 169 $this->processRequest(); 170 if($this->hasEventHandler('onEndRequest')) 171 $this->onEndRequest(new CEvent($this)); 172 } 173 174 /** |
#10 |
+
–
/home/birdcom/domains/birdwatchingvietnam.net/public_html/index.php(12): CApplication->run() 07 defined('YII_DEBUG') or define('YII_DEBUG',true); 08 // specify how many levels of call stack should be shown in each log message 09 //defined('YII_TRACE_LEVEL') or define('YII_TRACE_LEVEL',3); 10 require_once($yii); 11 12 Yii::createWebApplication($config)->run(); 13 14 |