Can't access content in Mambo administrator

[67mustang]

I can login to my Mambo administrator and get to some areas but cannot access content. Here's the error message I get:

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' AND c.sectionid='4' ORDER BY cc.ordering, cc.title, c.ordering LIMIT 0,10

Any suggestions on what to do are appreciated. I need to update this site. The site is ecmsracing.com.

Doug

[YvetteKuhns]

Report mysql error in the SPI. If you look at other posts, you will see that others have posted similar problems, especially yesterday. PowWeb was working on this last night.

[67mustang]

Thanks, Yvette. I submitted a support ticket. I figured it must be related the the mysql update.

Doug

[YvetteKuhns]

Yeah, don't hurt your head or waste time trying to fix something, if it is a server issue and not your website. Of course, if you need to update your script, you will need to do that. ;)

[67mustang]

Still not fixed and no response from the support ticket.

[dmacminn]

There was a fix noted in another thread for this ... it relates to the order of the fields I believe... now where did that go ...

[IanS]

Could this be the one? (http://forum.powweb.com/showthread.php?t=76141) from the discussion in Install Central.

[67mustang]

Yes, the fix by taran on the link IanS posted worked. I knew it would be simple, I just needed somebody to show me where to go. Thanks a lot!

Doug