Lähde:
[all]  getSelectPagePageItems() /var/www/html/lib/Lists.php : 247 

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 
INNER JOIN (SELECT msub.id as page_it_id 
FROM medias msub 
INNER JOIN (SELECT medias_search_filtered.id as mid 
FROM medias medias_search_filtered 
WHERE medias_search_filtered.title = :search or medias_search_filtered.rtitle LIKE :rsearch 
UNION SELECT tc.fk_content_id 
FROM tag_contents tc 
INNER JOIN tag_uniques tu ON tu.id = tc.fk_tag_id 
WHERE tu.tag = :search OR (tu.tag != tu.last_word AND (tu.tag LIKE :lsearch OR tu.last_word = :last_word)) ) AS matched_ids ON msub.id = matched_ids.mid 
WHERE msub.deleted <> 1 
ORDER BY msub.id DESC 
LIMIT 42) page_items ON Media.id = page_items.page_it_id 
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


array(4) {
  ["search"]=>
  array(2) {
    [0]=>
    string(5) "vuoto"
    [1]=>
    int(2)
  }
  ["rsearch"]=>
  array(2) {
    [0]=>
    string(5) "otouv"
    [1]=>
    int(2)
  }
  ["lsearch"]=>
  array(2) {
    [0]=>
    string(7) "vuoto %"
    [1]=>
    int(2)
  }
  ["last_word"]=>
  array(2) {
    [0]=>
    string(5) "vuoto"
    [1]=>
    int(2)
  }
}



#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(152): Mahti\Phalcon\Select->perform()
#4 /var/www/html/lib/Lists.php(247): Mahti\Phalcon\Select::all(Object(Mahti\Phalcon\Select), 'MediaDto')
#5 /var/www/html/lib/Lists.php(172): Mahti\Lists->getSelectPagePageItems(Object(PagiView), 1, 42, Object(Mahti\SearchOpts))
#6 /var/www/html/app/controllers/MediaController.php(325): Mahti\Lists->getMediaListPaginated('/m/', 1, 42, Object(Mahti\SearchOpts))
#7 [internal function]: MediaController->indexAction()
#8 [internal function]: Phalcon\Dispatcher\AbstractDispatcher->callActionMethod(Object(MediaController), 'indexAction', Array)
#9 [internal function]: Phalcon\Dispatcher\AbstractDispatcher->dispatch()
#10 /var/www/html/public/index.php(481): Phalcon\Mvc\Application->handle('/m?q=vuoto')
#11 {main}