CakePHP: the rapid development php framework: Errors

Notice (8): Undefined index: CategoryLinked [APP/Plugin/Default/Model/News.php, line 175]





        $category_node = $data['CategoryLinked']['category_id'];

$node_id = '27031'
$check = array(
	'Node' => array(
		'id' => '27031',
		'tag_id' => null,
		'title' => 'Thủ tục nhận con nuôi theo quy định',
		'slug' => 'tu-van-thu-tuc-dang-ky-nhan-cha-con-va-thu-tuc-nhan-con-nuoi',
		'link' => null,
		'type' => 'news',
		'pos' => '1',
		'robots' => '1',
		'read' => '247',
		'created' => '1437410289',
		'modified' => '1770157281',
		'edited' => '1687942502',
		'status' => '0'
	)
)
$read = (int) 248
$data = array()

News::news_detail() - APP/Plugin/Default/Model/News.php, line 175
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 37
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 968
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 109

Notice (8): Trying to access array offset on value of type null [APP/Plugin/Default/Model/News.php, line 175]

Code Context





        $category_node = $data['CategoryLinked']['category_id'];

$node_id = '27031'
$check = array(
	'Node' => array(
		'id' => '27031',
		'tag_id' => null,
		'title' => 'Thủ tục nhận con nuôi theo quy định',
		'slug' => 'tu-van-thu-tuc-dang-ky-nhan-cha-con-va-thu-tuc-nhan-con-nuoi',
		'link' => null,
		'type' => 'news',
		'pos' => '1',
		'robots' => '1',
		'read' => '247',
		'created' => '1437410289',
		'modified' => '1770157281',
		'edited' => '1687942502',
		'status' => '0'
	)
)
$read = (int) 248
$data = array()

News::news_detail() - APP/Plugin/Default/Model/News.php, line 175
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 37
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 968
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 109

Notice (8): Undefined index: Node [APP/Plugin/Default/Model/News.php, line 225]

Code Context

        $cats = $this->CategoryLinked->find('all', array(

          'conditions'=>array(

            'CategoryLinked.node_id'=>$data['Node']['id']

$node_id = '27031'
$check = array(
	'Node' => array(
		'id' => '27031',
		'tag_id' => null,
		'title' => 'Thủ tục nhận con nuôi theo quy định',
		'slug' => 'tu-van-thu-tuc-dang-ky-nhan-cha-con-va-thu-tuc-nhan-con-nuoi',
		'link' => null,
		'type' => 'news',
		'pos' => '1',
		'robots' => '1',
		'read' => '247',
		'created' => '1437410289',
		'modified' => '1770157281',
		'edited' => '1687942502',
		'status' => '0'
	)
)
$read = (int) 248
$data = array(
	'extra_data' => array()
)
$category_node = null
$category = array()
$list_cates = array()

News::news_detail() - APP/Plugin/Default/Model/News.php, line 225
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 37
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 968
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 109

Notice (8): Trying to access array offset on value of type null [APP/Plugin/Default/Model/News.php, line 225]

Code Context

        $cats = $this->CategoryLinked->find('all', array(

          'conditions'=>array(

            'CategoryLinked.node_id'=>$data['Node']['id']

$node_id = '27031'
$check = array(
	'Node' => array(
		'id' => '27031',
		'tag_id' => null,
		'title' => 'Thủ tục nhận con nuôi theo quy định',
		'slug' => 'tu-van-thu-tuc-dang-ky-nhan-cha-con-va-thu-tuc-nhan-con-nuoi',
		'link' => null,
		'type' => 'news',
		'pos' => '1',
		'robots' => '1',
		'read' => '247',
		'created' => '1437410289',
		'modified' => '1770157281',
		'edited' => '1687942502',
		'status' => '0'
	)
)
$read = (int) 248
$data = array(
	'extra_data' => array()
)
$category_node = null
$category = array()
$list_cates = array()

News::news_detail() - APP/Plugin/Default/Model/News.php, line 225
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 37
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 968
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 109

Notice (8): Undefined index: Node [APP/Plugin/Default/Model/News.php, line 256]

Code Context

                'CategoryLinked.category_id'=>$ids,

                'NOT'=>array(

                    'Node.id'=>$data['Node']['id']

$node_id = '27031'
$check = array(
	'Node' => array(
		'id' => '27031',
		'tag_id' => null,
		'title' => 'Thủ tục nhận con nuôi theo quy định',
		'slug' => 'tu-van-thu-tuc-dang-ky-nhan-cha-con-va-thu-tuc-nhan-con-nuoi',
		'link' => null,
		'type' => 'news',
		'pos' => '1',
		'robots' => '1',
		'read' => '247',
		'created' => '1437410289',
		'modified' => '1770157281',
		'edited' => '1687942502',
		'status' => '0'
	)
)
$read = (int) 248
$data = array(
	'extra_data' => array()
)
$category_node = null
$category = array()
$list_cates = array()
$cats = array()
$ids = array()

News::news_detail() - APP/Plugin/Default/Model/News.php, line 256
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 37
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 968
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 109

Notice (8): Trying to access array offset on value of type null [APP/Plugin/Default/Model/News.php, line 256]

Code Context

                'CategoryLinked.category_id'=>$ids,

                'NOT'=>array(

                    'Node.id'=>$data['Node']['id']

$node_id = '27031'
$check = array(
	'Node' => array(
		'id' => '27031',
		'tag_id' => null,
		'title' => 'Thủ tục nhận con nuôi theo quy định',
		'slug' => 'tu-van-thu-tuc-dang-ky-nhan-cha-con-va-thu-tuc-nhan-con-nuoi',
		'link' => null,
		'type' => 'news',
		'pos' => '1',
		'robots' => '1',
		'read' => '247',
		'created' => '1437410289',
		'modified' => '1770157281',
		'edited' => '1687942502',
		'status' => '0'
	)
)
$read = (int) 248
$data = array(
	'extra_data' => array()
)
$category_node = null
$category = array()
$list_cates = array()
$cats = array()
$ids = array()

News::news_detail() - APP/Plugin/Default/Model/News.php, line 256
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 37
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 968
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 109

Database Error

Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'rand' in 'order clause'

SQL Query: SELECT `Node`.*, `News`.* FROM `luatminhgia_db`.`news` AS `News` INNER JOIN `luatminhgia_db`.`nodes` AS `Node` ON (`News`.`node_id` = `Node`.`id`) INNER JOIN `luatminhgia_db`.`category_linkeds` AS `CategoryLinked` ON (`Node`.`id` = `CategoryLinked`.`node_id`) WHERE `Node`.`type` = 'news' AND `Node`.`status` = 1 AND `CategoryLinked`.`category_id` IS NULL GROUP BY `CategoryLinked`.`node_id` ORDER BY `rand` ASC 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);
    }

APP/Plugin/Default/Model/News.php line 288 → Model->find()

            'limit'=>10,

            'fields'=>array('Node.*', 'News.*'),

            'group'=>'CategoryLinked.node_id',

            'order'=> 'rand'

        ));

APP/Controller/Component/CcontentComponent.php line 37 → News->news_detail()

            $this->Controller->is_single = 1;

            $this->Controller->set('is_' . $type, 1);
            $data = $this->Controller->{$queryParams['modal']}->{$queryParams['action']}($node_id);

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

            // exit;
        }
        else
        $this->data = $this->Ccontent->getContent($this->nodeData['Node']['type'], $this->nodeData['Node']['id'], 10, '', $this->nodeData);
    }

[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 109 → Dispatcher->dispatch()

$Dispatcher = new Dispatcher();

$Dispatcher->dispatch(

    new CakeRequest(),

    new CakeResponse()

);