Warning (512): SQL Error: 1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' [CORE/cake/libs/model/datasources/dbo_source.php, line 684]Code |
Context
if ($this->error) {
$this->showQuery($sql);
$sql = "SELECT `Trail`.`id`, `Trail`.`status`, `Trail`.`name`, `Trail`.`slug`, `Trail`.`region_id`, `Trail`.`sub_region_id`, `Trail`.`closest_town`, `Trail`.`masthead_image_1`, `Trail`.`masthead_image_2`, `Trail`.`masthead_image_3`, `Trail`.`masthead_image_4`, `Trail`.`masthead_image_5`, `Trail`.`image_1`, `Trail`.`image_2`, `Trail`.`image_3`, `Trail`.`trail_logo`, `Trail`.`trail_map`, `Trail`.`difficulty`, `Trail`.`length`, `Trail`.`total_distance_km`, `Trail`.`accessibility`, `Trail`.`surface`, `Trail`.`character`, `Trail`.`activities`, `Trail`.`amenities`, `Trail`.`other`, `Trail`.`season_hours`, `Trail`.`gps_trailhead`, `Trail`.`lat`, `Trail`.`lng`, `Trail`.`popularity`, `Trail`.`description`, `Trail`.`contact_org`, `Trail`.`contact_name`, `Trail`.`contact_phone`, `Trail`.`contact_email`, `Trail`.`website_string`, `Trail`.`contact_url`, `Trail`.`weather_json`, `Trail`.`last_weather_update`, `Trail`.`modified`, `Trail`.`created`, `Trail`.`nearbyamenities`, `Region`.`id`, `Region`.`parent_id`, `Region`.`name`, `Region`.`rto`, `Region`.`slug`, `Region`.`image_url`, `Region`.`image_url_large`, `Region`.`short_description`, `Region`.`description`, `Region`.`legend_colour`, `Region`.`modified`, `Region`.`created`, `SubRegion`.`id`, `SubRegion`.`parent_id`, `SubRegion`.`name`, `SubRegion`.`rto`, `SubRegion`.`slug`, `SubRegion`.`image_url`, `SubRegion`.`image_url_large`, `SubRegion`.`short_description`, `SubRegion`.`description`, `SubRegion`.`legend_colour`, `SubRegion`.`modified`, `SubRegion`.`created` FROM `trails` AS `Trail` LEFT JOIN `regions` AS `Region` ON (`Trail`.`region_id` = `Region`.`id`) LEFT JOIN `regions` AS `SubRegion` ON (`Trail`.`sub_region_id` = `SubRegion`.`id`) WHERE `Trail`.`slug` = 'Patchell���s Path' AND `Trail`.`status` = 'active' LIMIT 1"
$error = "1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='"
$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 2142
TrailsController::view() - APP/plugins/trails/controllers/trails_controller.php, line 406
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 `Trail`.`id`, `Trail`.`status`, `Trail`.`name`, `Trail`.`slug`, `Trail`.`region_id`, `Trail`.`sub_region_id`, `Trail`.`closest_town`, `Trail`.`masthead_image_1`, `Trail`.`masthead_image_2`, `Trail`.`masthead_image_3`, `Trail`.`masthead_image_4`, `Trail`.`masthead_image_5`, `Trail`.`image_1`, `Trail`.`image_2`, `Trail`.`image_3`, `Trail`.`trail_logo`, `Trail`.`trail_map`, `Trail`.`difficulty`, `Trail`.`length`, `Trail`.`total_distance_km`, `Trail`.`accessibility`, `Trail`.`surface`, `Trail`.`character`, `Trail`.`activities`, `Trail`.`amenities`, `Trail`.`other`, `Trail`.`season_hours`, `Trail`.`gps_trailhead`, `Trail`.`lat`, `Trail`.`lng`, `Trail`.`popularity`, `Trail`.`description`, `Trail`.`contact_org`, `Trail`.`contact_name`, `Trail`.`contact_phone`, `Trail`.`contact_email`, `Trail`.`website_string`, `Trail`.`contact_url`, `Trail`.`weather_json`, `Trail`.`last_weather_update`, `Trail`.`modified`, `Trail`.`created`, `Trail`.`nearbyamenities`, `Region`.`id`, `Region`.`parent_id`, `Region`.`name`, `Region`.`rto`, `Region`.`slug`, `Region`.`image_url`, `Region`.`image_url_large`, `Region`.`short_description`, `Region`.`description`, `Region`.`legend_colour`, `Region`.`modified`, `Region`.`created`, `SubRegion`.`id`, `SubRegion`.`parent_id`, `SubRegion`.`name`, `SubRegion`.`rto`, `SubRegion`.`slug`, `SubRegion`.`image_url`, `SubRegion`.`image_url_large`, `SubRegion`.`short_description`, `SubRegion`.`description`, `SubRegion`.`legend_colour`, `SubRegion`.`modified`, `SubRegion`.`created` FROM `trails` AS `Trail` LEFT JOIN `regions` AS `Region` ON (`Trail`.`region_id` = `Region`.`id`) LEFT JOIN `regions` AS `SubRegion` ON (`Trail`.`sub_region_id` = `SubRegion`.`id`) WHERE `Trail`.`slug` = 'Patchell���s Path' AND `Trail`.`status` = 'active' LIMIT 1
Warning (2): Cannot modify header information - headers already sent by (output started at /home/ontrails/ontariotrails.on.ca/cake/libs/debugger.php:686) [CORE/cake/libs/controller/controller.php, line 742]Code |
Context */
function header($status) {
header($status);
$status = "Location: https://www.ontariotrails.on.ca/trails-a-z"
header - [internal], line ??
Controller::header() - CORE/cake/libs/controller/controller.php, line 742
Controller::redirect() - CORE/cake/libs/controller/controller.php, line 721
TrailsController::view() - APP/plugins/trails/controllers/trails_controller.php, line 442
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 86