Database Error
Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '* FROM `esirzgxhosting_shop`.`nodes` AS `Node` INNER JOIN ON (`Node`.`id`=....' at line 1
SQL Query: SELECT `Node`.*, .* FROM `esirzgxhosting_shop`.`nodes` AS `Node` INNER JOIN ON (`Node`.`id`=.node_id) INNER JOIN `esirzgxhosting_shop`.`category_linkeds` AS `CategoryLinked` ON (`Node`.`id` = `CategoryLinked`.`node_id`) WHERE `Node`.`status` = 1 AND `Node`.`type` IS NULL AND `CategoryLinked`.`category_id` IS NULL GROUP BY `CategoryLinked`.`node_id` ORDER BY `Node`.`pos` desc, `Node`.`id` desc LIMIT 10
Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp
Stack Trace
- CORE/Cake/Model/Datasource/DboSource.php line 460 → PDOStatement->execute(array)
try {
$query = $this->_connection->prepare($sql, $prepareOptions);
$query->setFetchMode(PDO::FETCH_LAZY);
if (!$query->execute($params)) {
$this->_results = $query;
array()
- CORE/Cake/Model/Datasource/DboSource.php line 426 → DboSource->_execute(string, array)
$options += array('log' => $this->fullDebug);
$t = microtime(true);
$this->_result = $this->_execute($sql, $params);
'SELECT `Node`.*, .* FROM `esirzgxhosting_shop`.`nodes` AS `Node` INNER JOIN ON (`Node`.`id`=.node_id) INNER JOIN `esirzgxhosting_shop`.`category_linkeds` AS `CategoryLinked` ON (`Node`.`id` = `CategoryLinked`.`node_id`) WHERE `Node`.`status` = 1 AND `Node`.`type` IS NULL AND `CategoryLinked`.`category_id` IS NULL GROUP BY `CategoryLinked`.`node_id` ORDER BY `Node`.`pos` desc, `Node`.`id` desc LIMIT 10' array()
- CORE/Cake/Model/Datasource/DboSource.php line 666 → DboSource->execute(string, array, array)
if ($cache && ($cached = $this->getQueryCache($sql, $params)) !== false) {
return $cached;
}
if ($result = $this->execute($sql, array(), $params)) {
$out = array();
'SELECT `Node`.*, .* FROM `esirzgxhosting_shop`.`nodes` AS `Node` INNER JOIN ON (`Node`.`id`=.node_id) INNER JOIN `esirzgxhosting_shop`.`category_linkeds` AS `CategoryLinked` ON (`Node`.`id` = `CategoryLinked`.`node_id`) WHERE `Node`.`status` = 1 AND `Node`.`type` IS NULL AND `CategoryLinked`.`category_id` IS NULL GROUP BY `CategoryLinked`.`node_id` ORDER BY `Node`.`pos` desc, `Node`.`id` desc LIMIT 10' array() array()
- CORE/Cake/Model/Datasource/DboSource.php line 1077 → DboSource->fetchAll(string, boolean)
$query = $this->generateAssociationQuery($model, null, null, null, null, $queryData, false, $null);
$resultSet = $this->fetchAll($query, $model->cacheQueries);
'SELECT `Node`.*, .* FROM `esirzgxhosting_shop`.`nodes` AS `Node` INNER JOIN ON (`Node`.`id`=.node_id) INNER JOIN `esirzgxhosting_shop`.`category_linkeds` AS `CategoryLinked` ON (`Node`.`id` = `CategoryLinked`.`node_id`) WHERE `Node`.`status` = 1 AND `Node`.`type` IS NULL AND `CategoryLinked`.`category_id` IS NULL GROUP BY `CategoryLinked`.`node_id` ORDER BY `Node`.`pos` desc, `Node`.`id` desc LIMIT 10' false
- CORE/Cake/Model/Model.php line 2880 → DboSource->read(Node, array)
* @return array
*/
protected function _readDataSource($type, $query) {
$results = $this->getDataSource()->read($this, $query);
$this->resetAssociations();
object(Node) { name => 'Node' useTable => 'nodes' useDbConfig => 'default' id => false data => array([maximum depth reached]) schemaName => 'esirzgxhosting_shop' table => 'nodes' primaryKey => 'id' validate => array([maximum depth reached]) validationErrors => array([maximum depth reached]) validationDomain => null tablePrefix => '' plugin => 'Default' alias => 'Node' tableToModel => array( [maximum depth reached] ) cacheQueries => false belongsTo => array([maximum depth reached]) hasOne => array([maximum depth reached]) hasMany => array([maximum depth reached]) hasAndBelongsToMany => array([maximum depth reached]) actsAs => null Behaviors => object(BehaviorCollection) {} whitelist => array([maximum depth reached]) cacheSources => true findQueryType => 'all' recursive => (int) 1 order => null virtualFields => array([maximum depth reached]) __backAssociation => array([maximum depth reached]) __backInnerAssociation => array([maximum depth reached]) __backOriginalAssociation => array([maximum depth reached]) __backContainableAssociation => array([maximum depth reached]) findMethods => array( [maximum depth reached] ) Category => object(Category) {} [protected] _schema => array( [maximum depth reached] ) [protected] _associationKeys => array( [maximum depth reached] ) [protected] _associations => array( [maximum depth reached] ) [protected] _insertID => null [protected] _sourceConfigured => true [protected] _eventManager => object(CakeEventManager) {} [protected] _validator => null } array( 'conditions' => array( 'Node.status' => (int) 1, 'Node.type' => null, 'CategoryLinked.category_id' => array([maximum depth reached]) ), 'fields' => array( (int) 0 => 'Node.*', (int) 1 => '.*' ), 'joins' => array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ) ), 'limit' => (int) 10, 'offset' => null, 'order' => array( (int) 0 => 'Node.pos desc, Node.id desc' ), 'page' => (int) 1, 'group' => 'CategoryLinked.node_id', 'callbacks' => true, 'maxLimit' => (int) 10, 'paramType' => 'named' )
- CORE/Cake/Model/Model.php line 2852 → Model->_readDataSource(string, array)
return null;
}
return $this->_readDataSource($type, $query);
}
'all' array( 'conditions' => array( 'Node.status' => (int) 1, 'Node.type' => null, 'CategoryLinked.category_id' => array([maximum depth reached]) ), 'fields' => array( (int) 0 => 'Node.*', (int) 1 => '.*' ), 'joins' => array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ) ), 'limit' => (int) 10, 'offset' => null, 'order' => array( (int) 0 => 'Node.pos desc, Node.id desc' ), 'page' => (int) 1, 'group' => 'CategoryLinked.node_id', 'callbacks' => true, 'maxLimit' => (int) 10, 'paramType' => 'named' )
- CORE/Cake/Controller/Component/PaginatorComponent.php line 198 → Model->find(string, array)
if ($recursive != $object->recursive) {
$parameters['recursive'] = $recursive;
}
$results = $object->find($type, array_merge($parameters, $extra));
}
'all' array( 'conditions' => array( 'Node.status' => (int) 1, 'Node.type' => null, 'CategoryLinked.category_id' => array([maximum depth reached]) ), 'fields' => array( (int) 0 => 'Node.*', (int) 1 => '.*' ), 'order' => 'Node.pos desc, Node.id desc', 'limit' => (int) 10, 'page' => (int) 1, 'maxLimit' => (int) 10, 'paramType' => 'named', 'joins' => array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ) ), 'group' => 'CategoryLinked.node_id' )
- CORE/Cake/Controller/Controller.php line 1079 → PaginatorComponent->paginate(string, array, array)
* @deprecated Will be removed in 3.0. Use PaginatorComponent instead.
*/
public function paginate($object = null, $scope = array(), $whitelist = array()) {
return $this->Components->load('Paginator', $this->paginate)->paginate($object, $scope, $whitelist);
}
'Node' array() array()
- APP/Controller/Component/CcontentComponent.php line 121 → Controller->paginate(string)
$this->Controller->paginate = $this->Controller->{$mdl}->archive($this->Controller->currentCategory['Category']['id']);
}
$data = $this->Controller->paginate('Node');
'Node'
- APP/Controller/Component/CcontentComponent.php line 62 → CcontentComponent->getArchive(string, integer)
return $data;
}
return $this->getArchive($node_id, $limit);
}
'1672' (int) 10
- APP/Plugin/Default/Controller/NodeController.php line 369 → CcontentComponent->getContent(string, string)
$slug = str_replace('.html', '', $slug);
$this->nodeData = $this->Node->findBySlug($slug);
if(!is_array($this->nodeData) || count($this->nodeData) <=0) die('Empty');
$this->data = $this->Ccontent->getContent($this->nodeData['Node']['type'], $this->nodeData['Node']['id']);
}
'tag' '1672'
- [internal function] → NodeController->index(string)
'qua-tang-khuyen-mai-gia-re'
- CORE/Cake/Controller/Controller.php line 490 → ReflectionMethod->invokeArgs(NodeController, array)
'action' => $request->params['action']
));
}
return $method->invokeArgs($this, $request->params['pass']);
object(NodeController) { theme => 'Default' product_pagination_limit => (int) 15 news_pagination_limit => (int) 15 collection_pagination_limit => (int) 8 document_pagination_limit => (int) 10 hook => array([maximum depth reached]) components => array( [maximum depth reached] ) uses => array( [maximum depth reached] ) is_mobile => false Controller => null default_lang => 'vi' lang => 'vi' lang_array => array( [maximum depth reached] ) settings => array( [maximum depth reached] ) nodeData => array( [maximum depth reached] ) cModalName => 'Tag' cActionName => null cFlagPage => false currentCategory => array([maximum depth reached]) currentCategoryChildren => null order_price => '' action_array => array( [maximum depth reached] ) cBuff => array( [maximum depth reached] ) dongho_type => array( [maximum depth reached] ) dongho_day => array( [maximum depth reached] ) name => 'Node' helpers => array([maximum depth reached]) request => object(CakeRequest) {} response => object(CakeResponse) {} viewPath => 'Node' layoutPath => null viewVars => array( [maximum depth reached] ) view => 'index' layout => 'default' autoRender => true autoLayout => true Components => object(ComponentCollection) {} viewClass => 'View' View => null ext => '.ctp' plugin => 'Default' cacheAction => false passedArgs => array( [maximum depth reached] ) scaffold => false methods => array( [maximum depth reached] ) modelClass => 'Category' modelKey => 'node' validationErrors => null Session => object(SessionComponent) {} Cookie => object(CookieComponent) {} Ccontent => object(CcontentComponent) {} Cmodal => object(CmodalComponent) {} Cmeta => object(CmetaComponent) {} Capp => object(CappComponent) {} Clayout => object(ClayoutComponent) {} RequestHandler => object(RequestHandlerComponent) {} sort => array([maximum depth reached]) Lang => object(AppModel) {} pageImageLogo => 'wp-content/uploads/2017/05/Su-thuy-tinh.png' Setting => object(AppModel) {} title_for_layout => 'Đại Lý Phân Phối Sản Xuất Độc Quyền Hàng Tiêu Dùng - Đồ Gia Dụng Gốm Sứ Thủy Tinh Pha lê Cao Cấp' keyword_for_layout => '' description_for_layout => 'Phân phối sản xuất Gốm Sứ Thủy Tinh Pha Lê - Mẫu Mã Đa Dạng Thiết Kế Tinh Sảo.LH Thanh Mai 0989 490 910' Category => object(Category) {} Banner => object(AppModel) {} banners => array( [maximum depth reached] ) Faq => object(AppModel) {} Rate => object(AppModel) {} Team => object(AppModel) {} Node => object(Node) {} [protected] _responseClass => 'CakeResponse' [protected] _mergeParent => 'AppController' [protected] _eventManager => object(CakeEventManager) {} } array( (int) 0 => 'qua-tang-khuyen-mai-gia-re' )
- CORE/Cake/Routing/Dispatcher.php line 187 → Controller->invokeAction(CakeRequest)
$controller->startupProcess();
$render = true;
$result = $controller->invokeAction($request);
if ($result instanceof CakeResponse) {
object(CakeRequest) { params => array( [maximum depth reached] ) data => array([maximum depth reached]) query => array([maximum depth reached]) url => 'qua-tang-khuyen-mai-gia-re' base => '' webroot => '/' here => '/qua-tang-khuyen-mai-gia-re' [protected] _detectors => array( [maximum depth reached] ) [protected] _input => '' }
- CORE/Cake/Routing/Dispatcher.php line 162 → Dispatcher->_invoke(NodeController, CakeRequest, CakeResponse)
));
}
$response = $this->_invoke($controller, $request, $response);
if (isset($request->params['return'])) {
object(NodeController) { theme => 'Default' product_pagination_limit => (int) 15 news_pagination_limit => (int) 15 collection_pagination_limit => (int) 8 document_pagination_limit => (int) 10 hook => array([maximum depth reached]) components => array( [maximum depth reached] ) uses => array( [maximum depth reached] ) is_mobile => false Controller => null default_lang => 'vi' lang => 'vi' lang_array => array( [maximum depth reached] ) settings => array( [maximum depth reached] ) nodeData => array( [maximum depth reached] ) cModalName => 'Tag' cActionName => null cFlagPage => false currentCategory => array([maximum depth reached]) currentCategoryChildren => null order_price => '' action_array => array( [maximum depth reached] ) cBuff => array( [maximum depth reached] ) dongho_type => array( [maximum depth reached] ) dongho_day => array( [maximum depth reached] ) name => 'Node' helpers => array([maximum depth reached]) request => object(CakeRequest) {} response => object(CakeResponse) {} viewPath => 'Node' layoutPath => null viewVars => array( [maximum depth reached] ) view => 'index' layout => 'default' autoRender => true autoLayout => true Components => object(ComponentCollection) {} viewClass => 'View' View => null ext => '.ctp' plugin => 'Default' cacheAction => false passedArgs => array( [maximum depth reached] ) scaffold => false methods => array( [maximum depth reached] ) modelClass => 'Category' modelKey => 'node' validationErrors => null Session => object(SessionComponent) {} Cookie => object(CookieComponent) {} Ccontent => object(CcontentComponent) {} Cmodal => object(CmodalComponent) {} Cmeta => object(CmetaComponent) {} Capp => object(CappComponent) {} Clayout => object(ClayoutComponent) {} RequestHandler => object(RequestHandlerComponent) {} sort => array([maximum depth reached]) Lang => object(AppModel) {} pageImageLogo => 'wp-content/uploads/2017/05/Su-thuy-tinh.png' Setting => object(AppModel) {} title_for_layout => 'Đại Lý Phân Phối Sản Xuất Độc Quyền Hàng Tiêu Dùng - Đồ Gia Dụng Gốm Sứ Thủy Tinh Pha lê Cao Cấp' keyword_for_layout => '' description_for_layout => 'Phân phối sản xuất Gốm Sứ Thủy Tinh Pha Lê - Mẫu Mã Đa Dạng Thiết Kế Tinh Sảo.LH Thanh Mai 0989 490 910' Category => object(Category) {} Banner => object(AppModel) {} banners => array( [maximum depth reached] ) Faq => object(AppModel) {} Rate => object(AppModel) {} Team => object(AppModel) {} Node => object(Node) {} [protected] _responseClass => 'CakeResponse' [protected] _mergeParent => 'AppController' [protected] _eventManager => object(CakeEventManager) {} } object(CakeRequest) { params => array( [maximum depth reached] ) data => array([maximum depth reached]) query => array([maximum depth reached]) url => 'qua-tang-khuyen-mai-gia-re' base => '' webroot => '/' here => '/qua-tang-khuyen-mai-gia-re' [protected] _detectors => array( [maximum depth reached] ) [protected] _input => '' } object(CakeResponse) { [protected] _statusCodes => array( [maximum depth reached] ) [protected] _mimeTypes => array( [maximum depth reached] ) [protected] _protocol => 'HTTP/1.1' [protected] _status => (int) 200 [protected] _contentType => 'text/html' [protected] _headers => array([maximum depth reached]) [protected] _body => null [protected] _file => null [protected] _fileRange => null [protected] _charset => 'UTF-8' [protected] _cacheDirectives => array([maximum depth reached]) [protected] _cookies => array([maximum depth reached]) }
- APP/webroot/index.php line 110 → Dispatcher->dispatch(CakeRequest, CakeResponse)
$Dispatcher->dispatch(
new CakeRequest(),
new CakeResponse()
);
object(CakeRequest) { params => array( [maximum depth reached] ) data => array([maximum depth reached]) query => array([maximum depth reached]) url => 'qua-tang-khuyen-mai-gia-re' base => '' webroot => '/' here => '/qua-tang-khuyen-mai-gia-re' [protected] _detectors => array( [maximum depth reached] ) [protected] _input => '' } object(CakeResponse) { [protected] _statusCodes => array( [maximum depth reached] ) [protected] _mimeTypes => array( [maximum depth reached] ) [protected] _protocol => 'HTTP/1.1' [protected] _status => (int) 200 [protected] _contentType => 'text/html' [protected] _headers => array([maximum depth reached]) [protected] _body => null [protected] _file => null [protected] _fileRange => null [protected] _charset => 'UTF-8' [protected] _cacheDirectives => array([maximum depth reached]) [protected] _cookies => array([maximum depth reached]) }