/var/www/html/protected/libs/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
#0 |
+
–
/var/www/html/protected/libs/framework/db/CDbCommand.php(415): CDbCommand->queryInternal("fetch", array(2), array()) 410 * @return mixed the first row (in terms of an array) of the query result, false if no result. 411 * @throws CException execution failed 412 */ 413 public function queryRow($fetchAssociative=true,$params=array()) 414 { 415 return $this->queryInternal('fetch',$fetchAssociative ? $this->_fetchMode : PDO::FETCH_NUM, $params); 416 } 417 418 /** 419 * Executes the SQL statement and returns the value of the first column in the first row of data. 420 * This is a convenient method of {@link query} when only a single scalar |
#1 |
+
–
/var/www/html/protected/libs/framework/db/schema/mysql/CMysqlSchema.php(229): CDbCommand->queryRow() 224 * Collects the foreign key column details for the given table. 225 * @param CMysqlTableSchema $table the table metadata 226 */ 227 protected function findConstraints($table) 228 { 229 $row=$this->getDbConnection()->createCommand('SHOW CREATE TABLE '.$table->rawName)->queryRow(); 230 $matches=array(); 231 $regexp='/FOREIGN KEY\s+\(([^\)]+)\)\s+REFERENCES\s+([^\(^\s]+)\s*\(([^\)]+)\)/mi'; 232 foreach($row as $sql) 233 { 234 if(preg_match_all($regexp,$sql,$matches,PREG_SET_ORDER)) |
#2 |
+
–
/var/www/html/protected/libs/framework/db/schema/mysql/CMysqlSchema.php(128): CMysqlSchema->findConstraints(CMysqlTableSchema) 123 $table=new CMysqlTableSchema; 124 $this->resolveTableNames($table,$name); 125 126 if($this->findColumns($table)) 127 { 128 $this->findConstraints($table); 129 return $table; 130 } 131 else 132 return null; 133 } |
#3 |
+
–
/var/www/html/protected/libs/framework/db/schema/CDbSchema.php(96): CMysqlSchema->loadTable("news_article_info") 091 { 092 $key='yii:dbschema'.$this->_connection->connectionString.':'.$this->_connection->username.':'.$name; 093 $table=$cache->get($key); 094 if($refresh===true || $table===false) 095 { 096 $table=$this->loadTable($realName); 097 if($table!==null) 098 $cache->set($key,$table,$duration); 099 } 100 $this->_tables[$name]=$table; 101 } |
#4 |
+
–
/var/www/html/protected/libs/framework/db/ar/CActiveRecord.php(2361): CDbSchema->getTable("{{news_article_info}}") 2356 public function __construct($model) 2357 { 2358 $this->_modelClassName=get_class($model); 2359 2360 $tableName=$model->tableName(); 2361 if(($table=$model->getDbConnection()->getSchema()->getTable($tableName))===null) 2362 throw new CDbException(Yii::t('yii','The table "{table}" for active record class "{class}" cannot be found in the database.', 2363 array('{class}'=>$this->_modelClassName,'{table}'=>$tableName))); 2364 if($table->primaryKey===null) 2365 { 2366 $table->primaryKey=$model->primaryKey(); |
#5 |
+
–
/var/www/html/protected/libs/framework/db/ar/CActiveRecord.php(411): CActiveRecordMetaData->__construct(NewsArticleInfo) 406 { 407 $className=get_class($this); 408 if(!array_key_exists($className,self::$_md)) 409 { 410 self::$_md[$className]=null; // preventing recursive invokes of {@link getMetaData()} via {@link __get()} 411 self::$_md[$className]=new CActiveRecordMetaData($this); 412 } 413 return self::$_md[$className]; 414 } 415 416 /** |
#6 |
+
–
/var/www/html/protected/libs/framework/db/ar/CActiveRecord.php(658): CActiveRecord->getMetaData() 653 * Returns the metadata of the table that this AR belongs to 654 * @return CDbTableSchema the metadata of the table that this AR belongs to 655 */ 656 public function getTableSchema() 657 { 658 return $this->getMetaData()->tableSchema; 659 } 660 661 /** 662 * Returns the command builder used by this AR. 663 * @return CDbCommandBuilder the command builder used by this AR |
#7 |
+
–
/var/www/html/protected/libs/framework/db/ar/CActiveFinder.php(383): CActiveRecord->getTableSchema() 378 $this->_parent=$parent; 379 $this->model=$this->_finder->getModel($relation->className); 380 $this->_builder=$this->model->getCommandBuilder(); 381 $this->tableAlias=$relation->alias===null?$relation->name:$relation->alias; 382 $this->rawTableAlias=$this->_builder->getSchema()->quoteTableName($this->tableAlias); 383 $this->_table=$this->model->getTableSchema(); 384 } 385 else // root element, the first parameter is the model. 386 { 387 $this->model=$relation; 388 $this->_builder=$relation->getCommandBuilder(); |
#8 |
+
–
/var/www/html/protected/libs/framework/db/ar/CActiveFinder.php(278): CJoinElement->__construct(CActiveFinder, CBelongsToRelation, CJoinElement, 1) 273 { 274 $element=$parent->children[$with]; 275 $element->relation=$relation; 276 } 277 else 278 $element=new CJoinElement($this,$relation,$parent,++$this->_joinCount); 279 if(!empty($relation->through)) 280 { 281 $slave=$this->buildJoinTree($parent,$relation->through,array('select'=>'')); 282 $slave->master=$element; 283 $element->slave=$slave; |
#9 |
+
–
/var/www/html/protected/libs/framework/db/ar/CActiveFinder.php(296): CActiveFinder->buildJoinTree(CJoinElement, "newsInfo") 291 292 // $with is an array, keys are relation name, values are relation spec 293 foreach($with as $key=>$value) 294 { 295 if(is_string($value)) // the value is a relation name 296 $this->buildJoinTree($parent,$value); 297 elseif(is_string($key) && is_array($value)) 298 $this->buildJoinTree($parent,$key,$value); 299 } 300 } 301 } |
#10 |
+
–
/var/www/html/protected/libs/framework/db/ar/CActiveFinder.php(48): CActiveFinder->buildJoinTree(CJoinElement, array("newsInfo", "newsInfo.site")) 43 */ 44 public function __construct($model,$with) 45 { 46 $this->_builder=$model->getCommandBuilder(); 47 $this->_joinTree=new CJoinElement($this,$model); 48 $this->buildJoinTree($this->_joinTree,$with); 49 } 50 51 /** 52 * Do not call this method. This method is used internally to perform the relational query 53 * based on the given DB criteria. |
#11 |
+
–
/var/www/html/protected/libs/framework/db/ar/CActiveRecord.php(909): CActiveFinder->__construct(Article, array("newsInfo", "newsInfo.site")) 904 * 905 * @since 1.1.14 906 */ 907 public function getActiveFinder($with) 908 { 909 return new CActiveFinder($this,$with); 910 } 911 912 /** 913 * This event is raised before an AR finder performs a count call. 914 * If you want to access or modify the query criteria used for the |
#12 |
+
–
/var/www/html/protected/libs/framework/db/ar/CActiveRecord.php(1355): CActiveRecord->getActiveFinder(array("newsInfo", "newsInfo.site")) 1350 $command=$this->getCommandBuilder()->createFindCommand($this->getTableSchema(),$criteria,$this->getTableAlias()); 1351 return $all ? $this->populateRecords($command->queryAll(), true, $criteria->index) : $this->populateRecord($command->queryRow()); 1352 } 1353 else 1354 { 1355 $finder=$this->getActiveFinder($criteria->with); 1356 return $finder->query($criteria,$all); 1357 } 1358 } 1359 1360 /** |
#13 |
+
–
/var/www/html/protected/libs/framework/db/ar/CActiveRecord.php(1470): CActiveRecord->query(CDbCriteria, true) 1465 */ 1466 public function findAll($condition='',$params=array()) 1467 { 1468 Yii::trace(get_class($this).'.findAll()','system.db.ar.CActiveRecord'); 1469 $criteria=$this->getCommandBuilder()->createCriteria($condition,$params); 1470 return $this->query($criteria,true); 1471 } 1472 1473 /** 1474 * Finds a single active record with the specified primary key. 1475 * See {@link find()} for detailed explanation about $condition and $params. |
#14 |
+
–
/var/www/html/protected/components/BaseController.php(67): CActiveRecord->findAll(array("condition" => "t.status = "published" AND t.is_verified = "1" AND t.type = "new...", "params" => array(":site_id" => 5), "order" => "newsInfo.starting_date DESC", "limit" => 10)) 62 $this->specialRegionNewsList = Article::model()->with(['newsInfo', 'newsInfo.site'])->findAll([ 63 'condition' => 't.status = "published" AND t.is_verified = "1" AND t.type = "news" AND newsInfo.site_id = :site_id', 64 'params' => [':site_id' => 5], 65 'order' => 'newsInfo.starting_date DESC', 66 'limit' => 10, 67 ]); 68 } 69 70 $this->photoReports = PhotoAlbum::getList(); 71 72 $this->specialNews = News::getSpecialNewsListForMainPage($this->currentSiteId); |
#15 |
+
–
/var/www/html/protected/controllers/SiteController.php(20): BaseController->init() 15 public $bugReportForm; 16 17 public $slogan; 18 19 public function init() { 20 parent::init(); 21 22 if (!Yii::app()->user->isGuest && Yii::app()->user->getState('role') == 'user') { 23 $this->siteUser = User::model()->with(['avatar', 'cityInfo'])->findByPk(Yii::app()->user->id, 'deleted IS NULL'); 24 } elseif (!Yii::app()->user->isGuest && Yii::app()->user->getState('role') == 'admin') { 25 $admin = Admin::model()->with('user')->findByPk(Yii::app()->user->id); |
#16 |
+
–
/var/www/html/protected/libs/framework/web/CWebApplication.php(281): SiteController->init() 276 if(($ca=$this->createController($route))!==null) 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}".', |
#17 |
+
–
/var/www/html/protected/libs/framework/web/CWebApplication.php(141): CWebApplication->runController("site/newsView") 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. |
#18 |
+
–
/var/www/html/protected/libs/framework/base/CApplication.php(180): CWebApplication->processRequest() 175 public function run() 176 { 177 if($this->hasEventHandler('onBeginRequest')) 178 $this->onBeginRequest(new CEvent($this)); 179 register_shutdown_function(array($this,'end'),0,false); 180 $this->processRequest(); 181 if($this->hasEventHandler('onEndRequest')) 182 $this->onEndRequest(new CEvent($this)); 183 } 184 185 /** |
#19 |
+
–
/var/www/html/index.php(17): CApplication->run() 12 defined('YII_DEBUG') or define('YII_DEBUG', Config::$debug); 13 14 require_once ROOT_PATH . '/protected/libs/framework/yii.php' ; 15 $config = ROOT_PATH . '/configs/yii.php'; 16 17 Yii::createWebApplication($config)->run(); |