Warning (512): SQL Error: 1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' [CORE/cake/libs/model/datasources/dbo_source.php, line 684]
$sql = "SELECT COUNT(*) AS `count` FROM `news` AS `News` WHERE `News`.`status` = 1 AND `News`.`tag_en` like '%bàn ghế quán cafe đẹp%' "
$error = "1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'"
$out = null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 684
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 266
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 410
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 821
Model::find() - CORE/cake/libs/model/model.php, line 2153
Controller::paginate() - CORE/cake/libs/controller/controller.php, line 1210
NewsController::tag() - APP/controllers/news_controller.php, line 149
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 86
Query: SELECT COUNT(*) AS `count` FROM `news` AS `News` WHERE `News`.`status` = 1 AND `News`.`tag_en` like '%bàn ghế quán cafe đẹp%'
Query: SELECT `News`.`id`, `News`.`title`, `News`.`titleseo`, `News`.`alias`, `News`.`category_id`, `News`.`category_id1`, `News`.`category_id2`, `News`.`created`, `News`.`hot`, `News`.`status`, `News`.`modified`, `News`.`tag`, `News`.`meta_des`, `News`.`image`, `News`.`order`, `News`.`title_en`, `News`.`titleseo_en`, `News`.`tag_en`, `News`.`meta_des_en` FROM `news` AS `News` WHERE `News`.`status` = 1 AND `News`.`tag_en` like '%bàn ghế quán cafe đẹp%' ORDER BY `News`.`id` DESC LIMIT 5
Query: SELECT `News`.`id`, `News`.`title`, `News`.`titleseo`, `News`.`alias`, `News`.`category_id`, `News`.`category_id1`, `News`.`category_id2`, `News`.`created`, `News`.`hot`, `News`.`status`, `News`.`modified`, `News`.`tag`, `News`.`meta_des`, `News`.`image`, `News`.`order`, `News`.`title_en`, `News`.`titleseo_en`, `News`.`tag_en`, `News`.`meta_des_en` FROM `news` AS `News` WHERE `News`.`status` = 1 AND `News`.`tag_en` like '%bàn ghế quán cafe đẹp%' ORDER BY `News`.`id` DESC
bàn ghế quán cafe đẹp
bàn ghế quán cafe đẹp
Warning (2): Invalid argument supplied for foreach() [APP/views/news/tag.ctp, line 9]
include - APP/views/news/tag.ctp, line 9
View::_render() - CORE/cake/libs/view/view.php, line 736
View::render() - CORE/cake/libs/view/view.php, line 431
Controller::render() - CORE/cake/libs/controller/controller.php, line 909
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 207
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 86