Kiosk.zp.ua Самый большой КАТАЛОГ бердянских сайтов Полная ИНФОРМАЦИЯ об акциях и скидках Наибольшее количество частных ОБЪЯВЛЕНИЙ ГАЛЕРЕЯ фоторабот бердянских мастеров

Warning (512): SQL Error: 1267: Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'regexp' [CORE/cake/libs/model/datasources/dbo_source.php, line 514]

Code | Context

$sql	=	"SELECT COUNT(*) AS `count` FROM `advertisements` AS `Advertisement` LEFT JOIN `users` AS `User` ON (`Advertisement`.`user_id` = `User`.`id`) LEFT JOIN `rubrics` AS `Rubric` ON (`Advertisement`.`rubric_id` = `Rubric`.`id`)  WHERE `Advertisement`.`published`=1 and tags RLIKE '(^|\, )б/у()(\,|$)'   "
$error	=	"1267: Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'regexp'"
$out	=	null

            $out = null;
            if ($error) {
                trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING);

DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 514
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 201
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 337
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 636
Model::find() - CORE/cake/libs/model/model.php, line 1956
Controller::paginate() - CORE/cake/libs/controller/controller.php, line 1037
AppController::bytag() - APP/app_controller.php, line 108
Object::dispatchMethod() - CORE/cake/libs/object.php, line 119
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 243
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 209
[main] - APP/webroot/index.php, line 88

Query: SELECT COUNT(*) AS `count` FROM `advertisements` AS `Advertisement` LEFT JOIN `users` AS `User` ON (`Advertisement`.`user_id` = `User`.`id`) LEFT JOIN `rubrics` AS `Rubric` ON (`Advertisement`.`rubric_id` = `Rubric`.`id`) WHERE `Advertisement`.`published`=1 and tags RLIKE '(^|\, )б/у()(\,|$)'

Query: SELECT `Advertisement`.`id`, `Advertisement`.`rubric_id`, `Advertisement`.`user_id`, `Advertisement`.`tags`, `Advertisement`.`title`, `Advertisement`.`stem_title`, `Advertisement`.`description`, `Advertisement`.`stem_description`, `Advertisement`.`published`, `Advertisement`.`added`, `Advertisement`.`created`, `User`.`id`, `User`.`type`, `User`.`login`, `User`.`password`, `User`.`email`, `User`.`name`, `User`.`icon`, `User`.`created`, `Rubric`.`id`, `Rubric`.`parent_id`, `Rubric`.`title`, `Rubric`.`lft`, `Rubric`.`rght`, `Rubric`.`created` FROM `advertisements` AS `Advertisement` LEFT JOIN `users` AS `User` ON (`Advertisement`.`user_id` = `User`.`id`) LEFT JOIN `rubrics` AS `Rubric` ON (`Advertisement`.`rubric_id` = `Rubric`.`id`) WHERE `Advertisement`.`published`=1 and tags RLIKE '(^|\, )б/у()(\,|$)' LIMIT 10