CakePHP: the rapid development php framework: Errors

Warning (2): Undefined array key "Category" [APP/Controller/Component/CcontentComponent.php, line 206]

            return $filters;
        } else {
            if (is_numeric($current_category['Category']['parent_id']) && $current_category['Category']['parent_id'] > 0) {

CcontentComponent::get_filter_filter() - APP/Controller/Component/CcontentComponent.php, line 206
CcontentComponent::getArchive() - APP/Controller/Component/CcontentComponent.php, line 290
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 94
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 689
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 217

Warning (2): Trying to access array offset on value of type null [APP/Controller/Component/CcontentComponent.php, line 206]

Code Context

            return $filters;
        } else {
            if (is_numeric($current_category['Category']['parent_id']) && $current_category['Category']['parent_id'] > 0) {

CcontentComponent::get_filter_filter() - APP/Controller/Component/CcontentComponent.php, line 206
CcontentComponent::getArchive() - APP/Controller/Component/CcontentComponent.php, line 290
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 94
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 689
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 217

Warning (2): Undefined array key "Category" [APP/Controller/Component/CcontentComponent.php, line 169]

Code Context

            return $filters;
        } else {
            if (is_numeric($current_category['Category']['parent_id']) && $current_category['Category']['parent_id'] > 0) {

CcontentComponent::get_filter_hang() - APP/Controller/Component/CcontentComponent.php, line 169
CcontentComponent::getArchive() - APP/Controller/Component/CcontentComponent.php, line 291
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 94
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 689
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 217

Warning (2): Trying to access array offset on value of type null [APP/Controller/Component/CcontentComponent.php, line 169]

Code Context

            return $filters;
        } else {
            if (is_numeric($current_category['Category']['parent_id']) && $current_category['Category']['parent_id'] > 0) {

CcontentComponent::get_filter_hang() - APP/Controller/Component/CcontentComponent.php, line 169
CcontentComponent::getArchive() - APP/Controller/Component/CcontentComponent.php, line 291
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 94
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 689
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 217

Warning (2): Undefined array key "Category" [APP/Controller/Component/CcontentComponent.php, line 296]

Code Context

        $this->Controller->currentCategory = $currentCategory;

        $node_type = $this->Controller->currentCategory['Category']['ctype'];

CcontentComponent::getArchive() - APP/Controller/Component/CcontentComponent.php, line 296
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 94
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 689
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 217

Warning (2): Trying to access array offset on value of type null [APP/Controller/Component/CcontentComponent.php, line 296]

Code Context

        $this->Controller->currentCategory = $currentCategory;

        $node_type = $this->Controller->currentCategory['Category']['ctype'];

CcontentComponent::getArchive() - APP/Controller/Component/CcontentComponent.php, line 296
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 94
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 689
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 217

Warning (2): Undefined array key "Category" [APP/Controller/Component/CcontentComponent.php, line 329]

Code Context

        // else

        $this->Controller->paginate = $this->Controller->Node->getPaginate($this->Controller->currentCategory['Category']['id'], $node_type, $limit, $this->Controller->sort, 'desc', $this->Controller->filter_price);

CcontentComponent::getArchive() - APP/Controller/Component/CcontentComponent.php, line 329
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 94
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 689
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 217

Warning (2): Trying to access array offset on value of type null [APP/Controller/Component/CcontentComponent.php, line 329]

Code Context

        // else

        $this->Controller->paginate = $this->Controller->Node->getPaginate($this->Controller->currentCategory['Category']['id'], $node_type, $limit, $this->Controller->sort, 'desc', $this->Controller->filter_price);

CcontentComponent::getArchive() - APP/Controller/Component/CcontentComponent.php, line 329
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 94
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 689
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 217

Warning (2): Undefined array key "Category" [APP/Plugin/Default/Model/Node.php, line 299]

Code Context

                'conditions'=>array(

                    'Category.lft >=' => $check['Category']['lft'],

Node::getCategoryTree() - APP/Plugin/Default/Model/Node.php, line 299
Node::getPaginate() - APP/Plugin/Default/Model/Node.php, line 43
CcontentComponent::getArchive() - APP/Controller/Component/CcontentComponent.php, line 329
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 94
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 689
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 217

Warning (2): Trying to access array offset on value of type null [APP/Plugin/Default/Model/Node.php, line 299]

Code Context

                'conditions'=>array(

                    'Category.lft >=' => $check['Category']['lft'],

Node::getCategoryTree() - APP/Plugin/Default/Model/Node.php, line 299
Node::getPaginate() - APP/Plugin/Default/Model/Node.php, line 43
CcontentComponent::getArchive() - APP/Controller/Component/CcontentComponent.php, line 329
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 94
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 689
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 217

Warning (2): Undefined array key "Category" [APP/Plugin/Default/Model/Node.php, line 301]

Code Context

                    'Category.lft >=' => $check['Category']['lft'],

                    'Category.rght <=' => $check['Category']['rght']

Node::getCategoryTree() - APP/Plugin/Default/Model/Node.php, line 301
Node::getPaginate() - APP/Plugin/Default/Model/Node.php, line 43
CcontentComponent::getArchive() - APP/Controller/Component/CcontentComponent.php, line 329
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 94
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 689
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 217

Warning (2): Trying to access array offset on value of type null [APP/Plugin/Default/Model/Node.php, line 301]

Code Context

                    'Category.lft >=' => $check['Category']['lft'],

                    'Category.rght <=' => $check['Category']['rght']

Node::getCategoryTree() - APP/Plugin/Default/Model/Node.php, line 301
Node::getPaginate() - APP/Plugin/Default/Model/Node.php, line 43
CcontentComponent::getArchive() - APP/Controller/Component/CcontentComponent.php, line 329
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 94
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 689
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 217

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 `webpx_khachhang062411`.`nodes` AS `Node` INNER JOIN ON (`Node`.`id`...' at line 1

SQL Query: SELECT `Node`.*, .* FROM `webpx_khachhang062411`.`nodes` AS `Node` INNER JOIN ON (`Node`.`id`=.node_id) INNER JOIN `webpx_khachhang062411`.`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 502 → PDOStatement->execute()

        try {

            $query = $this->_connection->prepare($sql, $prepareOptions);

            $query->setFetchMode(PDO::FETCH_LAZY);

            if (!$query->execute($params)) {

                $this->_result = $query;

CORE/Cake/Model/Datasource/DboSource.php line 468 → DboSource->_execute()

        $options += array('log' => $this->fullDebug);



        $t = microtime(true);

        $this->_result = $this->_execute($sql, $params);

CORE/Cake/Model/Datasource/DboSource.php line 715 → DboSource->execute()

        if ($cache && ($cached = $this->getQueryCache($sql, $params)) !== false) {

            return $cached;

        }

        $result = $this->execute($sql, array(), $params);

        if ($result) {

CORE/Cake/Model/Datasource/DboSource.php line 1226 → DboSource->fetchAll()

        // Build SQL statement with the primary model, plus hasOne and belongsTo associations

        $query = $this->buildAssociationQuery($Model, $queryData);



        $resultSet = $this->fetchAll($query, $Model->cacheQueries);

        unset($query);

CORE/Cake/Model/Model.php line 3053 → DboSource->read()

 * @return array

 */

    protected function _readDataSource($type, $query) {

        $results = $this->getDataSource()->read($this, $query);

        $this->resetAssociations();

CORE/Cake/Model/Model.php line 3025 → Model->_readDataSource()

            return null;

        }



        return $this->_readDataSource($type, $query);

    }

CORE/Cake/Controller/Component/PaginatorComponent.php line 212 → Model->find()

            if ($recursive != $object->recursive) {

                $parameters['recursive'] = $recursive;

            }

            $results = $object->find($type, array_merge($parameters, $extra));

        }

CORE/Cake/Controller/Controller.php line 1107 → PaginatorComponent->paginate()

 * @link https://book.cakephp.org/2.0/en/controllers.html#Controller::paginate

 */

    public function paginate($object = null, $scope = array(), $whitelist = array()) {

        return $this->Components->load('Paginator', $this->paginate)->paginate($object, $scope, $whitelist);

    }

APP/Controller/Component/CcontentComponent.php line 341 → Controller->paginate()

            $this->Controller->paginate = $this->Controller->{$mdl}->hook($this->Controller->currentCategory, $limit);
        }

        $data = $this->Controller->paginate('Node');

APP/Controller/Component/CcontentComponent.php line 94 → CcontentComponent->getArchive()

            return $data;
        }

        return $this->getArchive($node_id, $limit);
    }

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

        // if (!is_array($this->nodeData) || count($this->nodeData) <= 0) return $this->redirect(DOMAIN . '404.html');
        if (!is_array($this->nodeData) || count($this->nodeData) <= 0) return $this->redirect(DOMAIN . '404.html');

        $this->data = $this->Ccontent->getContent($this->nodeData['Node']['type'], $this->nodeData['Node']['id']);

[internal function] → NodeController->index()

CORE/Cake/Controller/Controller.php line 499 → ReflectionMethod->invokeArgs()

                    'action' => $request->params['action']

                ));

            }

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

CORE/Cake/Routing/Dispatcher.php line 193 → Controller->invokeAction()



        $response = $controller->response;

        $render = true;

        $result = $controller->invokeAction($request);

        if ($result instanceof CakeResponse) {

CORE/Cake/Routing/Dispatcher.php line 167 → Dispatcher->_invoke()

            ));

        }



        $response = $this->_invoke($controller, $request);

        if (isset($request->params['return'])) {

APP/webroot/index.php line 217 → Dispatcher->dispatch()



    new CakeRequest(),



    new CakeResponse()