CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[HY093]: Invalid parameter number: no parameters were bound. The SQL statement executed was: SELECT `id`, `name_en`, `parent_id`, `parent_name_en`, `level`
FROM `lc_destination`
WHERE id = :id

/www/wwwroot/yii/framework/yiilite.php(9341)

9329             return $result;
9330         }
9331         catch(Exception $e)
9332         {
9333             if($this->_connection->enableProfiling)
9334                 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query');
9335             $errorInfo=$e instanceof PDOException ? $e->errorInfo : null;
9336             $message=$e->getMessage();
9337             Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',
9338                 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
9339             if(YII_DEBUG)
9340                 $message.='. The SQL statement executed was: '.$this->getText().$par;
9341             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
9342                 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
9343         }
9344     }
9345     public function buildQuery($query)
9346     {
9347         $sql=!empty($query['distinct']) ? 'SELECT DISTINCT' : 'SELECT';
9348         $sql.=' '.(!empty($query['select']) ? $query['select'] : '*');
9349         if(!empty($query['from']))
9350             $sql.="\nFROM ".$query['from'];
9351         else
9352             throw new CDbException(Yii::t('yii','The DB query must contain the "from" portion.'));
9353         if(!empty($query['join']))

Stack Trace

#0	+ – /www/wwwroot/yii/framework/yiilite.php(9268): CDbCommand->queryInternal("fetch", array(2), array()) 9263 { 9264 return $this->queryInternal('fetchAll',$fetchAssociative ? $this->_fetchMode : PDO::FETCH_NUM, $params); 9265 } 9266 public function queryRow($fetchAssociative=true,$params=array()) 9267 { 9268 return $this->queryInternal('fetch',$fetchAssociative ? $this->_fetchMode : PDO::FETCH_NUM, $params); 9269 } 9270 public function queryScalar($params=array()) 9271 { 9272 $result=$this->queryInternal('fetchColumn',0,$params); 9273 if(is_resource($result) && get_resource_type($result)==='stream')
#1	+ – /www/wwwroot/myVibe-api/protected/modules/api/controllers/HotelController.php(1158): CDbCommand->queryRow() 1153 $info['destinationId'] = $destination_id; 1154 $desInfo = Yii::app()->db2->createCommand() 1155 ->select('id,name_en,parent_id,parent_name_en,level') 1156 ->from('lc_destination') 1157 ->where('id = ' . $destination_id) 1158 ->queryRow(); 1159 1160 $desInfoData = []; 1161 if ($desInfo['level'] == 4) { 1162 $desInfoData[] = [ 1163 'id' => $desInfo['id'],
#2	+ – /www/wwwroot/yii/framework/yiilite.php(4058): HotelController->actionList() 4053 $controller=$this->getController(); 4054 $method=new ReflectionMethod($controller, $methodName); 4055 if($method->getNumberOfParameters()>0) 4056 return $this->runWithParamsInternal($controller, $method, $params); 4057 else 4058 return $controller->$methodName(); 4059 } 4060 } 4061 class CWebUser extends CApplicationComponent implements IWebUser 4062 { 4063 const FLASH_KEY_PREFIX='Yii.CWebUser.flash.';
#3	+ – /www/wwwroot/yii/framework/yiilite.php(3570): CInlineAction->runWithParams(array("s" => "/api/hotel/list", "destination_id" => ":id", "page" => "1", "order" => "0")) 3565 { 3566 $priorAction=$this->_action; 3567 $this->_action=$action; 3568 if($this->beforeAction($action)) 3569 { 3570 if($action->runWithParams($this->getActionParams())===false) 3571 $this->invalidActionParams($action); 3572 else 3573 $this->afterAction($action); 3574 } 3575 $this->_action=$priorAction;
#4	+ – /www/wwwroot/yii/framework/yiilite.php(3555): CController->runAction(CInlineAction) 3550 $this->missingAction($actionID); 3551 } 3552 public function runActionWithFilters($action,$filters) 3553 { 3554 if(empty($filters)) 3555 $this->runAction($action); 3556 else 3557 { 3558 $priorAction=$this->_action; 3559 $this->_action=$action; 3560 CFilterChain::create($this,$action,$filters)->run();
#5	+ – /www/wwwroot/yii/framework/yiilite.php(3545): CController->runActionWithFilters(CInlineAction, array()) 3540 { 3541 if(($parent=$this->getModule())===null) 3542 $parent=Yii::app(); 3543 if($parent->beforeControllerAction($this,$action)) 3544 { 3545 $this->runActionWithFilters($action,$this->filters()); 3546 $parent->afterControllerAction($this,$action); 3547 } 3548 } 3549 else 3550 $this->missingAction($actionID);
#6	+ – /www/wwwroot/yii/framework/yiilite.php(1746): CController->run("list") 1741 { 1742 list($controller,$actionID)=$ca; 1743 $oldController=$this->_controller; 1744 $this->_controller=$controller; 1745 $controller->init(); 1746 $controller->run($actionID); 1747 $this->_controller=$oldController; 1748 } 1749 else 1750 throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".', 1751 array('{route}'=>$route===''?$this->defaultController:$route)));
#7	+ – /www/wwwroot/yii/framework/yiilite.php(1666): CWebApplication->runController("api/hotel/list") 1661 foreach(array_splice($this->catchAllRequest,1) as $name=>$value) 1662 $_GET[$name]=$value; 1663 } 1664 else 1665 $route=$this->getUrlManager()->parseUrl($this->getRequest()); 1666 $this->runController($route); 1667 } 1668 protected function registerCoreComponents() 1669 { 1670 parent::registerCoreComponents(); 1671 $components=array(
#8	+ – /www/wwwroot/yii/framework/yiilite.php(1191): CWebApplication->processRequest() 1186 public function run() 1187 { 1188 if($this->hasEventHandler('onBeginRequest')) 1189 $this->onBeginRequest(new CEvent($this)); 1190 register_shutdown_function(array($this,'end'),0,false); 1191 $this->processRequest(); 1192 if($this->hasEventHandler('onEndRequest')) 1193 $this->onEndRequest(new CEvent($this)); 1194 } 1195 public function end($status=0,$exit=true) 1196 {
#9	+ – /www/wwwroot/myVibe-api/index.php(85): CApplication->run() 80 } 81 return false; 82 } 83 84 85 Yii::createWebApplication($config)->run();

2026-11-07 02:31:28 nginx/1.26.3 Yii Framework/1.1.14