/home/zd3tptgsk5kc/public_html/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 |
+
–
/home/zd3tptgsk5kc/public_html/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 |
+
–
/home/zd3tptgsk5kc/public_html/surigraphics/protected/views/site/itemlist.php(30): CDbCommand->queryAll() 25 { 26 $get_id = 1; 27 } 28 // select first 12 posts 29 $query = "select * from suri_item_details_images where category_id=".$category->id." and display_in_website=1 order by id desc limit $start_num, $limit_num "; 30 $result = Yii::app()->db->createCommand("$query")->queryAll(); 31 32 foreach ($result as $row) { 33 $id = $row['id']; 34 $product_img = $row['product_img']; 35 $category_id = $row['category_id']; |
#2 |
+
–
/home/zd3tptgsk5kc/public_html/framework/web/CBaseController.php(126): require("/home/zd3tptgsk5kc/public_html/surigraphics/protected/views/site...") 121 $data=$_data_; 122 if($_return_) 123 { 124 ob_start(); 125 ob_implicit_flush(false); 126 require($_viewFile_); 127 return ob_get_clean(); 128 } 129 else 130 require($_viewFile_); 131 } |
#3 |
+
–
/home/zd3tptgsk5kc/public_html/framework/web/CBaseController.php(95): CBaseController->renderInternal("/home/zd3tptgsk5kc/public_html/surigraphics/protected/views/site...", array("category" => null, "category_class_id" => "2"), true) 090 { 091 $widgetCount=count($this->_widgetStack); 092 if(($renderer=Yii::app()->getViewRenderer())!==null && $renderer->fileExtension==='.'.CFileHelper::getExtension($viewFile)) 093 $content=$renderer->renderFile($this,$viewFile,$data,$return); 094 else 095 $content=$this->renderInternal($viewFile,$data,$return); 096 if(count($this->_widgetStack)===$widgetCount) 097 return $content; 098 else 099 { 100 $widget=end($this->_widgetStack); |
#4 |
+
–
/home/zd3tptgsk5kc/public_html/framework/web/CController.php(872): CBaseController->renderFile("/home/zd3tptgsk5kc/public_html/surigraphics/protected/views/site...", array("category" => null, "category_class_id" => "2"), true) 867 */ 868 public function renderPartial($view,$data=null,$return=false,$processOutput=false) 869 { 870 if(($viewFile=$this->getViewFile($view))!==false) 871 { 872 $output=$this->renderFile($viewFile,$data,true); 873 if($processOutput) 874 $output=$this->processOutput($output); 875 if($return) 876 return $output; 877 else |
#5 |
+
–
/home/zd3tptgsk5kc/public_html/framework/web/CController.php(785): CController->renderPartial("itemlist", array("category" => null, "category_class_id" => "2"), true) 780 */ 781 public function render($view,$data=null,$return=false) 782 { 783 if($this->beforeRender($view)) 784 { 785 $output=$this->renderPartial($view,$data,true); 786 if(($layoutFile=$this->getLayoutFile($this->layout))!==false) 787 $output=$this->renderFile($layoutFile,array('content'=>$output),true); 788 789 $this->afterRender($view,$output); 790 |
#6 |
+
–
/home/zd3tptgsk5kc/public_html/surigraphics/protected/controllers/SiteController.php(199): CController->render("itemlist", array("category" => null, "category_class_id" => "2")) 194 $category_class_id = $_GET['category_class_id']; 195 $category_id = $_GET['category_id']; 196 197 $this->pageTitle = "Suri Graphics - Item List"; 198 $category = Itemcategory::model()->findByPk($category_id); 199 $this->render('itemlist', array("category" => $category, 'category_class_id' => $category_class_id)); 200 } 201 202 public function actionService_itemlist() { 203 $this->layout = "front"; 204 $category_class_id = $_GET['category_class_id']; |
#7 |
+
–
/home/zd3tptgsk5kc/public_html/framework/web/actions/CInlineAction.php(49): SiteController->actionItemlist() 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 } |
#8 |
+
–
/home/zd3tptgsk5kc/public_html/framework/web/CController.php(308): CInlineAction->runWithParams(array("category_class_id" => "2", "category_id" => "29", "token" => "5f5dedcc016739e77dea19ab02a1cefa30d75cfc")) 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; |
#9 |
+
–
/home/zd3tptgsk5kc/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(); |
#10 |
+
–
/home/zd3tptgsk5kc/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); |
#11 |
+
–
/home/zd3tptgsk5kc/public_html/framework/web/CWebApplication.php(282): CController->run("itemlist") 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))); |
#12 |
+
–
/home/zd3tptgsk5kc/public_html/framework/web/CWebApplication.php(141): CWebApplication->runController("site/itemlist") 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. |
#13 |
+
–
/home/zd3tptgsk5kc/public_html/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 /** |
#14 |
+
–
/home/zd3tptgsk5kc/public_html/surigraphics/index.php(17): CApplication->run() 12 defined('YII_DEBUG') or define('YII_DEBUG',true); 13 // specify how many levels of call stack should be shown in each log message 14 defined('YII_TRACE_LEVEL') or define('YII_TRACE_LEVEL',3); 15 ini_set('error_reporting' , 'E_ALL & ~E_NOTICE'); 16 require_once($yii); 17 Yii::createWebApplication($config)->run(); 18 Yii::app()->setTimeZone('Asia/Kolkata'); 19 $app->run(); |