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.

http://www.bestdownloadsites.com/export/mambo_patch/ admin.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

QUOTE:
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.

QUOTE:
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.

Hi Steve,

I'm running Mambo 4.5.2 and get the same error, however the patch did not seem to work for me.

This is the error I get after uploading the patch:

Code:

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.nameansfered'; mosRedirect( 'index2.php?option=com_export_content&task=sections',$msg ); } ?>

Any ideas what it could be? Thanks Steve!

QUOTE:
I'm running Mambo 4.5.2 and get the same error, however the patch did not seem to work for me.

This is the error I get after uploading the patch:

Can you make sure the old file was writable and that the patch went over ok.

Note: It will still be buggy but you should be able to still compile and download the data.

Also you may want to have a look here which may help.
http://bestdownloadsites.com/export/viewtopic.php?t=706

I have the latest release of Export content for Joomla is just about ready.
And will be starting on the Mambo version shortly but it want be ready for a while as it will need a lot of changes to get it working smoothly with different Mambo versions.

If you have no luck with it please post back here and we will see what we can come up with.

Ciao,
can somebody send me the patch mentioned in this post oe publish a valid link?


mambo_patch/admin.export_content.zip


Thanks in advance...

QUOTE:
can somebody send me the patch mentioned in this post oe publish a valid _link_?


mambo_patch/admin.export_content.zip


Thanks in advance...

This thread is old and there have been new releases to fix this error.
You need to install Export Content 1.0.0 on the Mambo site.
And Export Content version 1.7.0 on the Joomla 1.0.15 site.
Or if moving to Joomla 1.5+ series Export Content version 2.0.0 should be installed on the Joomla 1.5+ site.

To be clear all Export Content versions should only ever be installed on the Mambo-Joomla version it was made for.