/home/visitfloridakeys/public_html/yii/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
#0 |
+
–
/home/visitfloridakeys/public_html/yii/framework/db/CDbCommand.php(390): CDbCommand->queryInternal("fetchAll", array(2), array()) 385 * An empty array is returned if the query results in nothing. 386 * @throws CException execution failed 387 */ 388 public function queryAll($fetchAssociative=true,$params=array()) 389 { 390 return $this->queryInternal('fetchAll',$fetchAssociative ? $this->_fetchMode : PDO::FETCH_NUM, $params); 391 } 392 393 /** 394 * Executes the SQL statement and returns the first row of the result. 395 * This is a convenient method of {@link query} when only the first row of data is needed. |
#1 |
+
–
/home/visitfloridakeys/public_html/protected/controllers/SiteController.php(1356): CDbCommand->queryAll() 1351 1352 if(isset($_GET['scid'])){ 1353 $scid = " and FIND_IN_SET(".$_GET['scid'].", subcatId) > 0 "; 1354 }else{$scid = '';} 1355 $matching ="select * from florida_keys_property_listing where listingstatus='Approve' and catId=".$_GET['cid']." ".$scid." order by featuredPost='Yes' desc, id asc LIMIT $start, $limit "; 1356 $mtchdata=Yii::app()->db->createCommand($matching)->queryAll(); 1357 1358 //$matching_featured ="select * from florida_keys_property_listing where listingstatus='Approve' and featuredPost='Yes' and catId=".$_GET['cid']." ".$scid." LIMIT $start, $limit "; 1359 //$mtchdata_featured=Yii::app()->db->createCommand($matching_featured)->queryAll(); 1360 1361 |
#2 |
+
–
/home/visitfloridakeys/public_html/yii/framework/web/actions/CInlineAction.php(50): SiteController->actionCategory() 45 $controller=$this->getController(); 46 $method=new ReflectionMethod($controller, $methodName); 47 if($method->getNumberOfParameters()>0) 48 return $this->runWithParamsInternal($controller, $method, $params); 49 else 50 return $controller->$methodName(); 51 } 52 53 } |
#3 |
+
–
/home/visitfloridakeys/public_html/yii/framework/web/CController.php(309): CInlineAction->runWithParams(array("begin" => "30BB40D2A8AA4341C78FE07E8B0B", "action" => "analysisapplemartingordon")) 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; |
#4 |
+
–
/home/visitfloridakeys/public_html/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 } |
#5 |
+
–
/home/visitfloridakeys/public_html/yii/framework/web/filters/CFilter.php(41): CFilterChain->run() 36 */ 37 public function filter($filterChain) 38 { 39 if($this->preFilter($filterChain)) 40 { 41 $filterChain->run(); 42 $this->postFilter($filterChain); 43 } 44 } 45 46 /** |
#6 |
+
–
/home/visitfloridakeys/public_html/yii/framework/web/CController.php(1146): CFilter->filter(CFilterChain) 1141 */ 1142 public function filterAccessControl($filterChain) 1143 { 1144 $filter=new CAccessControlFilter; 1145 $filter->setRules($this->accessRules()); 1146 $filter->filter($filterChain); 1147 } 1148 1149 /** 1150 * Returns a persistent page state value. 1151 * A page state is a variable that is persistent across POST requests of the same page. |
#7 |
+
–
/home/visitfloridakeys/public_html/yii/framework/web/filters/CInlineFilter.php(59): CController->filterAccessControl(CFilterChain) 54 * @param CFilterChain $filterChain the filter chain that the filter is on. 55 */ 56 public function filter($filterChain) 57 { 58 $method='filter'.$this->name; 59 $filterChain->controller->$method($filterChain); 60 } 61 } |
#8 |
+
–
/home/visitfloridakeys/public_html/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 } |
#9 |
+
–
/home/visitfloridakeys/public_html/yii/framework/web/CController.php(292): CFilterChain->run() 287 $this->runAction($action); 288 else 289 { 290 $priorAction=$this->_action; 291 $this->_action=$action; 292 CFilterChain::create($this,$action,$filters)->run(); 293 $this->_action=$priorAction; 294 } 295 } 296 297 /** |
#10 |
+
–
/home/visitfloridakeys/public_html/yii/framework/web/CController.php(266): CController->runActionWithFilters(CInlineAction, array("accessControl")) 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); |
#11 |
+
–
/home/visitfloridakeys/public_html/yii/framework/web/CWebApplication.php(283): CController->run("category") 278 { 279 list($controller,$actionID)=$ca; 280 $oldController=$this->_controller; 281 $this->_controller=$controller; 282 $controller->init(); 283 $controller->run($actionID); 284 $this->_controller=$oldController; 285 } 286 else 287 throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".', 288 array('{route}'=>$route===''?$this->defaultController:$route))); |
#12 |
+
–
/home/visitfloridakeys/public_html/yii/framework/web/CWebApplication.php(142): CWebApplication->runController("site/category") 137 foreach(array_splice($this->catchAllRequest,1) as $name=>$value) 138 $_GET[$name]=$value; 139 } 140 else 141 $route=$this->getUrlManager()->parseUrl($this->getRequest()); 142 $this->runController($route); 143 } 144 145 /** 146 * Registers the core application components. 147 * This method overrides the parent implementation by registering additional core components. |
#13 |
+
–
/home/visitfloridakeys/public_html/yii/framework/base/CApplication.php(162): CWebApplication->processRequest() 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 |
+
–
/home/visitfloridakeys/public_html/index.php(13): CApplication->run() 08 defined('YII_DEBUG') or define('YII_DEBUG',true); 09 // specify how many levels of call stack should be shown in each log message 10 defined('YII_TRACE_LEVEL') or define('YII_TRACE_LEVEL',3); 11 12 require_once($yii); 13 Yii::createWebApplication($config)->run(); |