Lähde:
[one] getMedia() /var/www/html/app/models/Media.php : 393
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Media.title_safe' in 'SELECT'
SELECT Media.id AS id, Media.title_safe AS title_safe, CONCAT('/m/', Media.id, '/') as uri, Media.media_type as media_type, COALESCE(cf.counter, 0) as view_count, COALESCE(pc.counter, 0) as plus_count, COALESCE( (SELECT COUNT(msg.id)
FROM messages msg
WHERE msg.content_type = 1 AND msg.fk_content_id = Media.id), 0) AS message_count, IF ( ft.id IS NOT NULL, CONCAT(fs.url, ft.file_name), (SELECT CASE WHEN f.embedded_type = 'youtube' THEN CONCAT ( 'https://img.youtube.com/vi/', f.embedded_id, '/hqdefault.jpg' ) ELSE 'asd' END
FROM files f
WHERE f.id = (SELECT cf2.fk_file_id
FROM content_files cf2
WHERE cf2.fk_content_id = Media.id AND cf2.content_type = 1)) ) as thumb_url, COALESCE(ft.w, 0) AS t_w, COALESCE(ft.h, 0) AS t_h
FROM medias Media
LEFT JOIN request_counts as cf ON cf.content_type = 1 AND cf.fk_content_id = Media.id
LEFT JOIN plus_counts as pc ON pc.content_type = 1 AND pc.fk_content_id = Media.id
LEFT JOIN file_thumbs ft ON ft.id = Media.fk_thumb_id
LEFT JOIN file_storages fs ON fs.id = ft.fk_storage_id
WHERE Media.id > 568 AND Media.deleted <> 1
ORDER BY Media.id ASC
LIMIT 1
array(0) {
}
#0 [internal function]: PDOStatement->execute()
#1 [internal function]: Phalcon\DataMapper\Pdo\Connection\AbstractConnection->perform('SELECT Media.id...', Array)
#2 /var/www/html/lib/Phalcon/Select.php(97): Phalcon\DataMapper\Query\AbstractQuery->perform()
#3 /var/www/html/lib/Phalcon/Select.php(159): Mahti\Phalcon\Select->perform()
#4 /var/www/html/app/models/Media.php(393): Mahti\Phalcon\Select::one(Object(Mahti\Phalcon\Select), '\\Media')
#5 /var/www/html/app/controllers/MediaController.php(603): Media->getMedia('prev', NULL, NULL)
#6 /var/www/html/app/controllers/MediaController.php(627): MediaController->jumpToMediaAction()
#7 [internal function]: MediaController->prevAction('568')
#8 [internal function]: Phalcon\Dispatcher\AbstractDispatcher->callActionMethod(Object(MediaController), 'prevAction', Array)
#9 [internal function]: Phalcon\Dispatcher\AbstractDispatcher->dispatch()
#10 /var/www/html/public/index.php(481): Phalcon\Mvc\Application->handle('/m/568/prev')
#11 {main}