Notice (8): Undefined index: CatNotice [APP/Controller/HomesController.php, line 777]
Notice (8): Undefined index: CatNotice [APP/Controller/HomesController.php, line 801]
CakePHP: the rapid development php framework: Errors

Database Error

Error: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'taxigo_vn.TagNotice.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SQL Query: SELECT `TagNotice`.`id`, `TagNotice`.`name`, `TagNotice`.`notice_id`, `TagNotice`.`type`, `TagNotice`.`slug` FROM `taxigo_vn`.`tag_notices` AS `TagNotice` WHERE 1 = 1 GROUP BY `TagNotice`.`name`

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

Stack Trace

(default) 7 queries took 12 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `CatNotice`.`id`, `CatNotice`.`name`, `CatNotice`.`slug` FROM `taxigo_vn`.`cat_notices` AS `CatNotice` WHERE `CatNotice`.`slug` = 'bang-gia-dich-vu-taxi-noi-bai-ha-noi' LIMIT 1000
2SELECT `CatNoticeNotice`.`id`, `CatNoticeNotice`.`cat_notice_id`, `CatNoticeNotice`.`notice_id`, `CatNotice`.`id`, `CatNotice`.`name`, `CatNotice`.`slug`, `Notice`.`id`, `Notice`.`title`, `Notice`.`descriptionSeo`, `Notice`.`keywordSeo`, `Notice`.`alt`, `Notice`.`lock`, `Notice`.`status`, `Notice`.`slug`, `Notice`.`image`, `Notice`.`author`, `Notice`.`create_at`, `Notice`.`content`, `Notice`.`description`, `Notice`.`views` FROM `taxigo_vn`.`cat_notice_notices` AS `CatNoticeNotice` LEFT JOIN `taxigo_vn`.`cat_notices` AS `CatNotice` ON (`CatNoticeNotice`.`cat_notice_id` = `CatNotice`.`id`) LEFT JOIN `taxigo_vn`.`notices` AS `Notice` ON (`CatNoticeNotice`.`notice_id` = `Notice`.`id`) WHERE `CatNoticeNotice`.`cat_notice_id` IS NULL001
3SELECT `CatNoticeNotice`.`id`, `CatNoticeNotice`.`cat_notice_id`, `CatNoticeNotice`.`notice_id`, `CatNotice`.`id`, `CatNotice`.`name`, `CatNotice`.`slug`, `Notice`.`id`, `Notice`.`title`, `Notice`.`descriptionSeo`, `Notice`.`keywordSeo`, `Notice`.`alt`, `Notice`.`lock`, `Notice`.`status`, `Notice`.`slug`, `Notice`.`image`, `Notice`.`author`, `Notice`.`create_at`, `Notice`.`content`, `Notice`.`description`, `Notice`.`views` FROM `taxigo_vn`.`cat_notice_notices` AS `CatNoticeNotice` LEFT JOIN `taxigo_vn`.`cat_notices` AS `CatNotice` ON (`CatNoticeNotice`.`cat_notice_id` = `CatNotice`.`id`) LEFT JOIN `taxigo_vn`.`notices` AS `Notice` ON (`CatNoticeNotice`.`notice_id` = `Notice`.`id`) WHERE `cat_notice_id` IS NULL ORDER BY `notice_id` desc LIMIT 4294967284, 12002
4SELECT `Notice`.`id`, `Notice`.`title`, `Notice`.`descriptionSeo`, `Notice`.`keywordSeo`, `Notice`.`alt`, `Notice`.`lock`, `Notice`.`status`, `Notice`.`slug`, `Notice`.`image`, `Notice`.`author`, `Notice`.`create_at`, `Notice`.`content`, `Notice`.`description`, `Notice`.`views` FROM `taxigo_vn`.`notices` AS `Notice` WHERE `Notice`.`lock` = 0 AND `Notice`.`status` = 1 ORDER BY `Notice`.`id` desc12128
5SELECT `CatNoticeNotice`.`id`, `CatNoticeNotice`.`cat_notice_id`, `CatNoticeNotice`.`notice_id` FROM `taxigo_vn`.`cat_notice_notices` AS `CatNoticeNotice` WHERE `CatNoticeNotice`.`notice_id` IN (198, 154, 153, 152, 151, 150, 149, 148, 146, 145, 144, 15)14141
6SELECT `CatNotice`.`id`, `CatNotice`.`name`, `CatNotice`.`slug` FROM `taxigo_vn`.`cat_notices` AS `CatNotice` WHERE 1 = 1330
7SELECT `CatNoticeNotice`.`id`, `CatNoticeNotice`.`cat_notice_id`, `CatNoticeNotice`.`notice_id` FROM `taxigo_vn`.`cat_notice_notices` AS `CatNoticeNotice` WHERE `CatNoticeNotice`.`cat_notice_id` IN (2, 3, 4)1991990