Warning (512): SQL Error: 1270: Illegal mix of collations (utf8mb4_general_ci,COERCIBLE), (utf8mb4_general_ci,COERCIBLE), (latin1_general_ci,IMPLICIT) for operation 'concat' [CORE/cake/libs/model/datasources/dbo_source.php, line 684]Code |
Context $out = null;
if ($error) {
trigger_error('<span style="color:Red;text-align:left"><b>' . __('SQL Error:', true) . "</b> {$this->error}</span>", E_USER_WARNING);
$sql = "SELECT `Story`.`id`, `Story`.`publication_id`, `Story`.`tag_id`, `Story`.`headline`, `Story`.`headline_home`, `Story`.`headline_index`, `Story`.`meta_keywords`, `Story`.`home_spotlight`, `Story`.`home_spotlight_mini`, `Story`.`home_feature`, `Story`.`home_tag`, `Story`.`index_mini`, `Story`.`index_result`, `Story`.`gallery`, `Story`.`gallery_captions`, `Story`.`gallery_hide`, `Story`.`embed_spotlight`, `Story`.`status`, `Story`.`published`, `Story`.`byline`, `Story`.`tagline`, `Story`.`intro_short`, `Story`.`intro_long`, `Story`.`body`, `Story`.`newsletter_name`, `Story`.`printed`, `Story`.`created`, `Story`.`modified`, (SUBSTRING(SHA(CONCAT(`Story`.`id`)),5,8)) AS `Story__short_id`, (CONCAT(SUBSTRING(SHA(CONCAT(`Story`.`id`)),5,8),"/",REPLACE(`Story`.`headline`," ","_"))) AS `Story__url`, (SELECT COUNT(*) FROM unit_usage WHERE `unit_usage`.`fk_id` = `Story`.`id`) AS `Story__total_views`, (SUBSTRING(`Story`.`body`,1, INSTR(`Story`.`body`,'</p>')+3)) AS `Story__intro`, (IF(`Story`.`published` is NULL,DATE(`Story`.`printed`), DATE(`Story`.`published`))) AS `Story__publish_sort_date`, `Publication`.`id`, `Publication`.`name`, `Publication`.`folder`, `Publication`.`url`, `Publication`.`microsite_cms_url`, `Publication`.`meta_keywords`, `Publication`.`meta_description`, `Publication`.`tag_type_id`, `Publication`.`home_spotlight_count`, `Publication`.`home_spotlight_delay`, `Publication`.`home_feature_count`, `Publication`.`index_spotlight_count`, `Publication`.`search_spotlight_count`, `Publication`.`most_viewed_duration`, `Publication`.`most_tagged_duration`, `Publication`.`list_page_size`, `Publication`.`home_ad1`, `Publication`.`home_ad2`, `Publication`.`home_ad3`, `Publication`.`home_ad4`, `Publication`.`story_ad1`, `Publication`.`story_ad2`, `Publication`.`story_ad3`, `Publication`.`story_ad4`, `Publication`.`button_ad1`, `Publication`.`button_ad2`, `Publication`.`button_ad3`, `Publication`.`button_ad4`, `Publication`.`button_ad5`, `Publication`.`leader_ad`, `Publication`.`smtp_port`, `Publication`.`smtp_host`, `Publication`.`smtp_username`, `Publication`.`smtp_password`, `Publication`.`smtp_type`, `Publication`.`secure_widget`, `Publication`.`created`, `Publication`.`modified`, `Tag`.`id`, `Tag`.`tag_type_id`, `Tag`.`publication_id`, `Tag`.`name`, `Tag`.`meta_keywords`, `Tag`.`meta_description`, `Tag`.`tag_head_image`, `Tag`.`tag_ad1`, `Tag`.`tag_ad2`, `Tag`.`parent_id`, `Tag`.`private`, `Tag`.`priority`, `Tag`.`created`, `Tag`.`modified` FROM `stories` AS `Story` LEFT JOIN `publications` AS `Publication` ON (`Story`.`publication_id` = `Publication`.`id`) LEFT JOIN `tags` AS `Tag` ON (`Story`.`tag_id` = `Tag`.`id`) WHERE SUBSTRING(SHA(CONCAT(`Story`.`id`)),5,8) = '66a5d6dd' LIMIT 1"
$error = "1270: Illegal mix of collations (utf8mb4_general_ci,COERCIBLE), (utf8mb4_general_ci,COERCIBLE), (latin1_general_ci,IMPLICIT) for operation 'concat'"
$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 823
Model::find() - CORE/cake/libs/model/model.php, line 2127
AppModel::find() - APP/app_model.php, line 42
StoriesController::display() - APP/controllers/stories_controller.php, line 42
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Query: SELECT `Story`.`id`, `Story`.`publication_id`, `Story`.`tag_id`, `Story`.`headline`, `Story`.`headline_home`, `Story`.`headline_index`, `Story`.`meta_keywords`, `Story`.`home_spotlight`, `Story`.`home_spotlight_mini`, `Story`.`home_feature`, `Story`.`home_tag`, `Story`.`index_mini`, `Story`.`index_result`, `Story`.`gallery`, `Story`.`gallery_captions`, `Story`.`gallery_hide`, `Story`.`embed_spotlight`, `Story`.`status`, `Story`.`published`, `Story`.`byline`, `Story`.`tagline`, `Story`.`intro_short`, `Story`.`intro_long`, `Story`.`body`, `Story`.`newsletter_name`, `Story`.`printed`, `Story`.`created`, `Story`.`modified`, (SUBSTRING(SHA(CONCAT(`Story`.`id`)),5,8)) AS `Story__short_id`, (CONCAT(SUBSTRING(SHA(CONCAT(`Story`.`id`)),5,8),"/",REPLACE(`Story`.`headline`," ","_"))) AS `Story__url`, (SELECT COUNT(*) FROM unit_usage WHERE `unit_usage`.`fk_id` = `Story`.`id`) AS `Story__total_views`, (SUBSTRING(`Story`.`body`,1, INSTR(`Story`.`body`,'
')+3)) AS `Story__intro`, (IF(`Story`.`published` is NULL,DATE(`Story`.`printed`), DATE(`Story`.`published`))) AS `Story__publish_sort_date`, `Publication`.`id`, `Publication`.`name`, `Publication`.`folder`, `Publication`.`url`, `Publication`.`microsite_cms_url`, `Publication`.`meta_keywords`, `Publication`.`meta_description`, `Publication`.`tag_type_id`, `Publication`.`home_spotlight_count`, `Publication`.`home_spotlight_delay`, `Publication`.`home_feature_count`, `Publication`.`index_spotlight_count`, `Publication`.`search_spotlight_count`, `Publication`.`most_viewed_duration`, `Publication`.`most_tagged_duration`, `Publication`.`list_page_size`, `Publication`.`home_ad1`, `Publication`.`home_ad2`, `Publication`.`home_ad3`, `Publication`.`home_ad4`, `Publication`.`story_ad1`, `Publication`.`story_ad2`, `Publication`.`story_ad3`, `Publication`.`story_ad4`, `Publication`.`button_ad1`, `Publication`.`button_ad2`, `Publication`.`button_ad3`, `Publication`.`button_ad4`, `Publication`.`button_ad5`, `Publication`.`leader_ad`, `Publication`.`smtp_port`, `Publication`.`smtp_host`, `Publication`.`smtp_username`, `Publication`.`smtp_password`, `Publication`.`smtp_type`, `Publication`.`secure_widget`, `Publication`.`created`, `Publication`.`modified`, `Tag`.`id`, `Tag`.`tag_type_id`, `Tag`.`publication_id`, `Tag`.`name`, `Tag`.`meta_keywords`, `Tag`.`meta_description`, `Tag`.`tag_head_image`, `Tag`.`tag_ad1`, `Tag`.`tag_ad2`, `Tag`.`parent_id`, `Tag`.`private`, `Tag`.`priority`, `Tag`.`created`, `Tag`.`modified` FROM `stories` AS `Story` LEFT JOIN `publications` AS `Publication` ON (`Story`.`publication_id` = `Publication`.`id`) LEFT JOIN `tags` AS `Tag` ON (`Story`.`tag_id` = `Tag`.`id`) WHERE SUBSTRING(SHA(CONCAT(`Story`.`id`)),5,8) = '66a5d6dd' LIMIT 1
Warning (2): Invalid argument supplied for foreach() [APP/models/story.php, line 35]Code |
Context if($primary) {
foreach ($results as $key => $value) {
$results = false
$primary = true
Story::afterFind() - APP/models/story.php, line 35
Model::__filterResults() - CORE/cake/libs/model/model.php, line 2377
Model::find() - CORE/cake/libs/model/model.php, line 2131
AppModel::find() - APP/app_model.php, line 42
StoriesController::display() - APP/controllers/stories_controller.php, line 42
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Warning (2): Cannot modify header information - headers already sent by (output started at /home/probus/domains/stagingblueplains/cake/libs/debugger.php:673) [CORE/cake/libs/controller/controller.php, line 742]Code |
Context$status = "Location: https://staging.probussouthpacific.org/"
header - [internal], line ??
Controller::header() - CORE/cake/libs/controller/controller.php, line 742
Controller::redirect() - CORE/cake/libs/controller/controller.php, line 721
StoriesController::display() - APP/controllers/stories_controller.php, line 45
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83