Nov

24

(2005)

Mambo installer bug

Filed under: Uncategorized. Tags: , , , . 

Just installing Mambo for a demo of various CMS options to the team tomorrow. The Mambo 4.5.2.3 installer borked while creating a table, choking on a missing default value for “rating_sum”.

Easy fix. Line 221 of mambo/installation/sql/mambo.sql is dealing with setting up the content_rating table. Modify the sql thusly:

  `rating_sum` int(11) unsigned NOT NULL default '0',

Aside from that silly sql bug, the Mambo installer is pretty slick. I’ll likely blog my early thoughts of it as a CMS, after I’ve played with it for awhile…

Update: Well, looks like my Mambo installation is pretty much borked. I can’t edit content – keep getting MySQL errors on missing tables or fields. I’ll try nuking and reinstalling, but this was a fresh install from the latest build, so I’m not sure what could be wrong…

Update: Nope. It’s still borked. Install claims to have run successfully, but any attempt to edit content results in this:

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

Update: Mambo was borked, but the Joomla fork of the project installed perfectly…

Similar Posts:

Comments

3 Responses to “Mambo installer bug”

  1. Johan Janssens says:
    December 11, 2005 at 4:05 pm

    Boris – Thanks to set that one straight !

    D’Arcy – Thanks for taking the time to evaluate the project. Looking forward to the rest of your findings. Always interesting to learn how a novice user experiences the system.

    Reply
  2. D'Arcy says:
    November 28, 2005 at 7:17 am

    Boris, thanks for the clarification. You’re right – Joomla isn’t a fork at all, but a rebirth of a project. Joomla installed perfectly, by the way…

    Reply
  3. Boris Mann says:
    November 25, 2005 at 9:24 pm

    D’Arcy — Joomla is not the fork, it’s the “real” project. If you care to go investigate, a corporation tried to take over the community, and basically all the developers (and rest of the community) set up the new name (and continued developing the same codebase) in short order. From a community perspective, it’s not a fork.

    Reply

Leave a Reply