DB function failed with error number 1054

[Rimmon]

Witam! Kiedy w panelu administratora chcę wejść na "wszystkie artykuły" to od jakiegoś czasu pojawia mi się komunikat

DB function failed with error number 1054
Unknown column 'c.access' in 'on clause' SQL=SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author FROM mos_content AS c, mos_categories AS cc, mos_sections AS s LEFT JOIN mos_groups AS g ON g.id = c.access LEFT JOIN mos_users AS u ON u.id = c.checked_out LEFT JOIN mos_users AS v ON v.id = c.created_by LEFT JOIN mos_content_frontpage AS f ON f.content_id = c.id WHERE c.state >= 0 AND c.catid=cc.id AND cc.section=s.id AND s.scope='content' ORDER BY s.title, c.catid, cc.ordering, cc.title, c.ordering LIMIT 0,10

Mam pytanie co on oznacza i jak mogę rozwiązać ten problem.
Z góry dziękuję i pozdrawiam!

[vj_]

Tu poczytaj

[Rimmon]

Niestety ten opis mi nie rozwiązał mojego problemu, ponieważ w moim pliku admin.content.php nie było takiego wpisu. Aczkolwiek zmieniłem

$query = "SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author"
. "\n FROM #__content AS c, #__categories AS cc, #__sections AS s"
. "\n LEFT JOIN #__groups AS g ON g.id = c.access"
. "\n LEFT JOIN #__users AS u ON u.id = c.checked_out"
. "\n LEFT JOIN #__users AS v ON v.id = c.created_by"
. "\n LEFT JOIN #__content_frontpage AS f ON f.content_id = c.id"
. ( count( $where ) ? "\nWHERE " . implode( ' AND ', $where ) : '' )
. $order
. "\n LIMIT $pageNav->limitstart,$pageNav->limit"
;

na

$query = "SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author"
. "\n FROM #__content AS c" //, #__categories AS cc, #__sections AS s"
. "\n LEFT JOIN #__groups AS g ON g.id = c.access"
. "\n LEFT JOIN #__users AS u ON u.id = c.checked_out"
. "\n LEFT JOIN #__users AS v ON v.id = c.created_by"
. "\n LEFT JOIN #__content_frontpage AS f ON f.content_id = c.id"
. "\n LEFT OUTER JOIN #__categories AS cc ON c.catid=cc.id"
. "\n LEFT OUTER JOIN #__sections AS s ON cc.section=s.id"
. ( count( $where ) ? "\nWHERE " . implode( ' AND ', $where ) : '' )
. $order
. "\n LIMIT $pageNav->limitstart,$pageNav->limit"
;

i zadziałało. Dzięki za pomoc

[vj_]

Spoko, świąteczna pomoc

[simonegaliano]

Great Rimmon!!!!!!!

I do not understand a word of polish, but you saved my life!!
I spent 1 day trying to fix this f***ing error 1054

Thank you.
Simone