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]

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 `Story`.`id` IN (SELECT story_id FROM stories_tags WHERE tag_id IN(62) GROUP BY story_id HAVING COUNT(story_id) = 1) ORDER BY `Story`.`published` desc LIMIT 40, 10

Warning (2): Invalid argument supplied for foreach() [APP/models/story.php, line 35]

Query: SELECT `Story`.`headline`, `Story`.`intro_short`, `Story`.`index_mini`, (SUBSTRING(SHA(CONCAT(`Story`.`id`)),5,8)) AS `Story__short_id`, count(fk_id) AS `Story__total_views`, CONCAT(SUBSTRING(SHA(CONCAT(`Story`.id)),5,8),"/",REPLACE(`Story`.headline," ","_")) AS Story__url FROM unit_usage as U INNER JOIN stories AS `Story` ON U.fk_id = `Story`.id WHERE model = "Story" AND `Story`.publication_id = 2 AND U.created > DATE_SUB(CURDATE(), INTERVAL 14 DAY) GROUP BY fk_id ORDER BY `Story__total_views` DESC LIMIT 15

Warning (2): Invalid argument supplied for foreach() [APP/controllers/components/most_popular.php, line 56]

Warning (2): Cannot modify header information - headers already sent by (output started at /home/probus/domains/stagingblueplains/cake/libs/debugger.php:673) [APP/views/layouts/probus.ctp, line 1]
Probus - NSW
JOIN PROBUS TODAY!
AUS: 1300 630 488    NZ: 0800 1477 6287
No stories were found.
Results 41 - 50 of 252 1 2 3 4 5 6 7 8 9