CakePHP: the rapid development php framework: Errors

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 MySQL server version for the right syntax to use near '* FROM `tienhastee_comvn`.`nodes` AS `Node` INNER JOIN ON (`Node`.`id`=.node_i' at line 1

SQL Query: SELECT `Node`.*, .* FROM `tienhastee_comvn`.`nodes` AS `Node` INNER JOIN ON (`Node`.`id`=.node_id) WHERE `Node`.`status` = 1 AND `Node`.`type` IS NULL AND `Node`.`category_id` IS NULL 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 `tienhastee_comvn`.`nodes` AS `Node` INNER JOIN   ON (`Node`.`id`=.node_id)  WHERE `Node`.`status` = 1 AND `Node`.`type` IS NULL AND `Node`.`category_id` IS NULL    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 `tienhastee_comvn`.`nodes` AS `Node` INNER JOIN   ON (`Node`.`id`=.node_id)  WHERE `Node`.`status` = 1 AND `Node`.`type` IS NULL AND `Node`.`category_id` IS NULL    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 `tienhastee_comvn`.`nodes` AS `Node` INNER JOIN   ON (`Node`.`id`=.node_id)  WHERE `Node`.`status` = 1 AND `Node`.`type` IS NULL AND `Node`.`category_id` IS NULL    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 => 'tienhastee_comvn'
	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(AppModel) {}
	[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,
		'Node.category_id' => array([maximum depth reached])
	),
	'fields' => array(
		(int) 0 => 'Node.*',
		(int) 1 => '.*'
	),
	'joins' => array(
		(int) 0 => array(
			[maximum depth reached]
		)
	),
	'limit' => (int) 10,
	'offset' => null,
	'order' => array(
		(int) 0 => array([maximum depth reached])
	),
	'page' => (int) 1,
	'group' => null,
	'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,
		'Node.category_id' => array([maximum depth reached])
	),
	'fields' => array(
		(int) 0 => 'Node.*',
		(int) 1 => '.*'
	),
	'joins' => array(
		(int) 0 => array(
			[maximum depth reached]
		)
	),
	'limit' => (int) 10,
	'offset' => null,
	'order' => array(
		(int) 0 => array([maximum depth reached])
	),
	'page' => (int) 1,
	'group' => null,
	'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,
		'Node.category_id' => array([maximum depth reached])
	),
	'fields' => array(
		(int) 0 => 'Node.*',
		(int) 1 => '.*'
	),
	'order' => array(),
	'limit' => (int) 10,
	'page' => (int) 1,
	'maxLimit' => (int) 10,
	'paramType' => 'named',
	'joins' => array(
		(int) 0 => array(
			[maximum depth reached]
		)
	)
)

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 61 → Controller->paginate(string)

        
        $this->Controller->paginate = $this->Controller->Node->getPaginate($this->Controller->currentCategory['Category']['id'], $node_type, $limit);
        $this->Controller->set('is_archive', 1);
        return $this->Controller->paginate('Node');
    }

'Node'

APP/Controller/Component/CcontentComponent.php line 33 → CcontentComponent->getArchive(null, integer)

            return $this->Controller->{$queryParams['modal']}->{$queryParams['action']}($node_id);
        }
        
        return $this->getArchive($node_id, $limit);
    }

null
(int) 10

APP/Plugin/Default/Controller/NodeController.php line 21 → CcontentComponent->getContent(null, null)

    public function index($slug = null) {
        $slug = str_replace('.html', '', $slug);
        $this->nodeData = $this->Node->findBySlug($slug);
        $this->data = $this->Ccontent->getContent($this->nodeData['Node']['type'], $this->nodeData['Node']['id']);
    }

null
null

[internal function] → NodeController->index(string, string)
```
'net-con'
'.html'
```

CORE/Cake/Controller/Controller.php line 490 → ReflectionMethod->invokeArgs(NodeController, array)

                    'action' => $request->params['action']
                ));
            }
            return $method->invokeArgs($this, $request->params['pass']);

object(NodeController) {
	components => array(
		[maximum depth reached]
	)
	uses => array(
		[maximum depth reached]
	)
	Controller => null
	theme => 'Default'
	lang => 'vi'
	settings => array(
		[maximum depth reached]
	)
	nodeData => array([maximum depth reached])
	cModalName => ''
	cActionName => null
	cFlagPage => false
	currentCategory => array([maximum depth reached])
	action_array => array(
		[maximum depth reached]
	)
	cBuff => array(
		[maximum depth reached]
	)
	product_pagination_limit => (int) 6
	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) {}
	Setting => object(AppModel) {}
	title_for_layout => 'Thép Tiến Hà'
	keyword_for_layout => 'dây thép mạ kẽm, lưới thép mạ kẽm, lưới b40, lưới mắt cáo, lưới thép hàn, dây thép gai, dây thép đen, tấm lưới thép hàn, lưới mắt cáo bọc nhựa, thép tiến hà'
	description_for_layout => 'công ty cổ phần tiến hà nhiều năm liền dẫn đầu về cung cấp các loại dây thép mạ kẽm và lưới thép mạ kẽm'
	Category => object(AppModel) {}
	Hangxe => object(AppModel) {}
	Banner => object(AppModel) {}
	Node => object(Node) {}
	[protected] _responseClass => 'CakeResponse'
	[protected] _mergeParent => 'AppController'
	[protected] _eventManager => object(CakeEventManager) {}
}
array(
	(int) 0 => 'net-con',
	(int) 1 => '.html'
)

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 => 'net-con.html'
	base => ''
	webroot => '/'
	here => '/net-con.html'
	[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) {
	components => array(
		[maximum depth reached]
	)
	uses => array(
		[maximum depth reached]
	)
	Controller => null
	theme => 'Default'
	lang => 'vi'
	settings => array(
		[maximum depth reached]
	)
	nodeData => array([maximum depth reached])
	cModalName => ''
	cActionName => null
	cFlagPage => false
	currentCategory => array([maximum depth reached])
	action_array => array(
		[maximum depth reached]
	)
	cBuff => array(
		[maximum depth reached]
	)
	product_pagination_limit => (int) 6
	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) {}
	Setting => object(AppModel) {}
	title_for_layout => 'Thép Tiến Hà'
	keyword_for_layout => 'dây thép mạ kẽm, lưới thép mạ kẽm, lưới b40, lưới mắt cáo, lưới thép hàn, dây thép gai, dây thép đen, tấm lưới thép hàn, lưới mắt cáo bọc nhựa, thép tiến hà'
	description_for_layout => 'công ty cổ phần tiến hà nhiều năm liền dẫn đầu về cung cấp các loại dây thép mạ kẽm và lưới thép mạ kẽm'
	Category => object(AppModel) {}
	Hangxe => object(AppModel) {}
	Banner => 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 => 'net-con.html'
	base => ''
	webroot => '/'
	here => '/net-con.html'
	[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 111 → 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 => 'net-con.html'
	base => ''
	webroot => '/'
	here => '/net-con.html'
	[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])
}