Hi I have installed Exportcontent_1.7.0 on the Mambo 4.5.2 but i was not able to export data due to a sql error.

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

I have read the different posts on ths topic and there is a url to a patch, but the link is broken. (http://www.bestdownloadsites.com/export/mambo_patch/ admin.export_content.zip)

Does anyone know where to find this patch? or is there another way to fix this?

Regards Powder

Hi Powder

QUOTE:
Hi I have installed Exportcontent_1.7.0 on the Mambo 4.5.2 but i was not able to export data due to a sql error.

You have the wrong version installed.

Export Content 1.7.0 is for Joomla 1.0+ series.
Export Content 2.0.0 is for Joomla 1.5+ series.
Export Content 1.0.0 is for Mambo.

Hi Steve

I have a a website Mambo 4.5.2 version and i would like to export content and import it to Jommla 1.0.13

1. Do i install Version Exportcontent_1.0.0 on the Mambo site and Joomla site?
2. Do i install Version Exportcontent_1.0.0 on the Mambo site and Version Exportcontent_1.7.0 on the Joomla site?
3. Do i install Version Exportcontent_1.0.0 on the Mambo site and Version Exportcontent_1.0.0 on the Joomla site?

What is the best practise to sucsessfully do this?

Regards Powder

Export Content 1.7.0 is for Joomla 1.0+ series only.
Export Content 2.0.0 is for Joomla 1.5+ series only.
Export Content 1.0.0 is for Mambo only.

Each version of Export Content may only be installed on the Joomla version it has been made for and 1.0.0 is for Mambo all versions.

So in your case you would install Export Content version 1.0.0 on Mambo 4.5.2.
And Export Content version 1.7.0 on Joomla 1.0.13

Hi Steve !

Thanks for your quick reply.

I almost did the trix, but i also had to change the encoding of the xml file.

Regards Powder

QUOTE:
I almost did the trix, but i also had to change the encoding of the _xml_ file.

This will be addressed in the next release?

More info here

Ciao, I'm having troubles exporting from Mambo 4.5.2 and importing in Joomla 1.0.15

I have an SQL error and I noticed there is a patch to solve this problem, but the link is broken...

http://www.bestdownloadsites.com/export/mambo_patch/ admin.export_content.zip


Can you help me?

Thanks...

QUOTE:
Ciao, I'm having troubles exporting from Mambo 4.5.2 and importing in Joomla 1.0.15

I have an SQL error and I noticed there is a patch to solve this problem, but the _link_ is broken...

Have you got the correct versions of Export Content installed?

Export Content 1.7.0 is for Joomla 1.0+ series only.

Export Content 2.0.0 is for Joomla 1.5+ series only.

Export Content 1.0.0 is for Mambo only.

What SQL error are you getting?

Yes the versions are correct, I'm having error 1064...

QUOTE:
Yes the versions are correct, I'm having error 1064...

Can you paste the error here so I can see it.