Greetings Steve,

I have one of my mambo site clients wanting me to migrate them over to Joomla. I am installing Joomla clean and using your Export Content comp. to export their content over.

The Mambo site is running 4.5.4 sp3

EC installs fine but when I go to the Export Content button in your comp I get this error:

DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN #__content AS cc ON c.id = cc.sectionid LEFT JOIN #__users AS u ON u.' at line 3 SQL=SELECT c.*, g.name AS groupname, u.name AS editor FROM #__sections AS c LEFT JOIN #__content AS cc ON c.id = cc.sectionid LEFT JOIN #__users AS u ON u.id = c.checked_out LEFT JOIN #__groups AS g ON g.id = c.access GROUP BY c.id ORDER BY c.ordering, c.name

Any idea what's going on here? if we can get this working I'll be more than happy to donate.

Thanks so much.

Jack
affinityav.com :!:

Hi Jack donations are always very welcome

First of all please make sure that there are no file ownership or permission issues.

Are there any core hacks running?

If that is not the problem it sounds like a tweak of a query or two might get it working.

*************

I went and had a look at it and put a patch together download and unzip it then upload and overwrite "admin.export_content"
to /administrator/components/ com_export_content/admin.export_content.php
Let me know how you go.

www.bestdownloadsites.com/export/ mambo_p...n.export_content.zip

Steve,

that did the trick! Very nice utility you have here. I just donated $50 AUD to your efforts.

Here some ideas I have for future functionality of your comp.

Export Content makes a nice little cloner type comp. Especially useful in migrating from Mambo to Joomla OR hacker attack recovery. I would really like to see it export more than just content. For instance:

Menus: this would be a real time saver.

Modules: first have the user install all the same modules in the destination and then your comp would then construct the settings for the modules and assign them to their positions.

Thanks again. Your comp. really helped make this last minute "emergency" migration possible.

Jack Hughes
Affinityav.com

Another idea for Export Content would be to export content from certain components: Mosets Tree, VirtueMart, Zoom Media Gallery etc.

Just dreamin'

thanks again
jack

Thanks for the donation Jack much appreciated

Export Content makes a nice little cloner type comp. Especially useful in migrating from Mambo to Joomla OR hacker attack recovery. I would really like to see it export more than just content. For instance:

Menus: this would be a real time saver.

Modules: first have the user install all the same modules in the destination and then your comp would then construct the settings for the modules and assign them to their positions.
Yes some good ideas I have give some thought to extending it to cover more things like menus, users etc.

Another idea for Export Content would be to export content from certain components: Mosets Tree, VirtueMart, Zoom Media Gallery etc.
The problem here is getting the other developers onboard otherwise if a change is made to their database structure I would need to make changes as well unless I can come up with a pluggin set-up similar to Community builder.

And a few more people like yourself willing to help with donations so I can allocate more time to work on it.

At the moment I am working on a release for Joomla 1.5+ series where when exporting/compiling content you will be able to choose whether you want to import into either Joomla 1.0+ or 1.5+ as the database is a bit different and there has been a lot of changes to the code base.

So this should allow for the import - export of content between all versions of Joomla and it appears I might need to put something together for any Mambo users wanting to move over to Joomla as well.