Lähde:
[one] getMedia() /var/www/html/app/models/Media.php : 443
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'f.spoiler' 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(f.spoiler, 0) as nsfw
FROM medias Media
WHERE Media.deleted <> 1 AND NOT EXISTS (SELECT 1
FROM content_hides ch
WHERE ch.fk_content_id = Media.fk_user_id AND ch.fk_user_id = :curr_usr AND ch.content_type = 2) AND NOT EXISTS ( SELECT 1
FROM channel_medias cm
JOIN content_hides ch ON ch.fk_channel_hide_id = cm.fk_media_channel_id
WHERE cm.fk_media_id = Media.id AND ch.fk_user_id = :curr_usr ) AND Media.id > 1706 AND Media.deleted <> 1
ORDER BY Media.id ASC
LIMIT 1
array(1) {
["curr_usr"]=>
array(2) {
[0]=>
int(1)
[1]=>
int(1)
}
}
#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(443): Mahti\Phalcon\Select::one(Object(Mahti\Phalcon\Select), '\\Media')
#5 /var/www/html/app/controllers/MediaController.php(663): Media->getMedia('prev', NULL, NULL)
#6 /var/www/html/app/controllers/MediaController.php(716): MediaController->jumpToMediaAction()
#7 [internal function]: MediaController->prevAction('1706')
#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(489): Phalcon\Mvc\Application->handle('/m/1706/prev')
#11 {main}