DB function failed with error number 1054

[bruno1983]

Salve ragazzi ho installato mambo 4.5.2 su una macchina unix ma quando vado alla sezione "All Content Items" mi da questo errore:
 
 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
 
 Di mysql ho installato la versione 5.0.15
 Mi dite come posso risolverlo?
 Grazie Ragazzi

[alexred]

credo proprio dipenda dalla versione 5 del Mysql, devo risolvere anche io questo stesso problema 

Se tu puoi tornare ad una verisone 4 vedrai che tutto si risolve......

[alexred]

ho risolto così.... ma non saprei se è una soluzione definitiva e completamente efficace..... però ora riesco ad accedere ai contenuti del Mambo su Mysql 5

apri il file admin.content.php in administrator/components/com_content/

trova questa parte di codice:

Codice: [Seleziona]

$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"
        ;

sostituiscila con:

Codice: [Seleziona]

$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"
        ;

questa soluzione temporanea è valida anche per Joomla, stando alla roadmap ufficiale Joomla! 2.0 sarà perfettamente compatibile con Mysql 5