This is the most asked question on the net regarding Mambo run with Mysql 5!

In Mysql 5.x due to the optimizer changes, it requires to have the join table to be next to the join statement otherwise it will cause a parsing error.

You can read more about this changes here: http://dev.mysql.com/doc/refman/5.0/en/left-join-optimization.html

To solve this problem you just need to make changes in "administrator/components/com_content/admin.content.php" as follow:

On line 201 and line 312:
From this: "\n FROM #__content AS c, #__categories AS cc, #__sections AS s" 
To this:   "\n FROM #__categories AS cc, #__sections AS s, #__content AS c" 

So with this fixes Mambo 4.5.3+ should be good for mysql 5.x for now.

I hope this help those that seek for a solution to this problem

Show (4) - Add comments: