Notice (8): Undefined index: category_id [APP/Controller/ItemController.php, line 42]
error

Database Error

Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Item.category_id' in 'where clause'

SQL Query: SELECT `Item`.`id`, `Item`.`title`, `Item`.`url`, `Item`.`click`, `Item`.`site_id`, `Item`.`item_datetime`, `Item`.`twitter_count`, `Item`.`hatena_count`, `Item`.`facebook_count`, `Item`.`twitter_post`, `Item`.`blog_post`, `Item`.`description`, `Item`.`keywords`, `Item`.`img_name`, `Item`.`delete_flg`, `Item`.`modified`, `Item`.`created`, `Site`.`id`, `Site`.`name`, `Site`.`rss_url`, `Site`.`rss_type`, `Site`.`redirect`, `Site`.`updated`, `Site`.`modified`, `Site`.`created` FROM `lifemuch_pazdora`.`items` AS `Item` LEFT JOIN `lifemuch_pazdora`.`sites` AS `Site` ON (`Item`.`site_id` = `Site`.`id`) WHERE `Item`.`category_id` IS NULL AND `Item`.`item_datetime` > '2018-10-16 00:00:00' ORDER BY `Item`.`twitter_count` 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 461PDOStatement->execute(array)
  • CORE/Cake/Model/Datasource/DboSource.php line 427DboSource->_execute(string, array)
  • CORE/Cake/Model/Datasource/DboSource.php line 671DboSource->execute(string, array, array)
  • CORE/Cake/Model/Datasource/DboSource.php line 1082DboSource->fetchAll(string, boolean)
  • CORE/Cake/Model/Model.php line 2630DboSource->read(Item, array)
  • APP/Controller/ItemController.php line 43Model->find(string, array)
  • [internal function]ItemController->index(string)
  • CORE/Cake/Controller/Controller.php line 485ReflectionMethod->invokeArgs(ItemController, array)
  • CORE/Cake/Routing/Dispatcher.php line 186Controller->invokeAction(CakeRequest)
  • CORE/Cake/Routing/Dispatcher.php line 161Dispatcher->_invoke(ItemController, CakeRequest, CakeResponse)
  • APP/webroot/index.php line 92Dispatcher->dispatch(CakeRequest, CakeResponse)