Filed under:

Error when trying to listing content items in Mambo




Error when trying to listing content items in Mambo

This fix ONLY applies if you are seeing the following error when viewing content items.

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,50You will need to edit the PHP source files to resolve this issue.
  1. Navigate to the httpdocs/administrator/components/com_content/ in your site (This can normally be done through the File Manager in your control panel)
  2. Create a backup (copy) of admin.content.php .
  3. Edit the file named admin.content.php
  4. At line: 201 you should find
    . "\n FROM #__content AS c, #__categories AS cc, #__sections AS s"
  5. Replace this line with:
    . "\n FROM #__categories AS cc, #__sections AS s, #__content AS c "
  6. At line: 312 you should find
    . "\n FROM , #__content AS c, #__categories AS cc, #__sections AS s"
  7. Replace this line with:
    . "\n FROM #__categories AS cc, #__sections AS s, #__content AS c "
  8. You should now be able to view content items, if this does not work for you move/upload the backup copy of the admin.content.php


Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read

Language: