Error Statement

[Dirigo2]

Hello-
When I click on 'All Content Items' or other sub topics, I get the following statement in Mambo version 4.5.3. I have not changed any settings since my last visit to the site a month or so ago. Can anyone tell me what this means?

"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,30"

Thanks,

Dirigo

[Elpie]

Hi Dirigo,
This error indicates that your server has been upgraded to MySQL5 but you are using a version of Mambo that does not fully support MySQL5.
Go to the downloads tab at the top of this forum and look for the upgrade patches for Mambo that will take you from Mambo 4.5.3 to 4.5.6. Do the upgrades and this error will go away.

Unless you have some very good reasons for staying on the 4.5 branch you should really consider upgrading your site all the way to 4.6.5. There are huge improvements between your version and the latest version.

Hope this helps