Page 1 of 2
Migration from Joomla 1.5 to Joomla 1.7
Posted: 25 Jul 2011, 15:55
by gottfried
Hi, I migrated from Joomla 1.5 to Joomla 1.7 and installed the new version of the Phoca Map. In Joomla 1.5 I created several maps with lots of markers. In Joomla 1.7 none of the previous created maps show up.
Do I have to redo the maps in Joomla 1.7 or is there a way to move the old files into the new version?
Regards, Gottfried
Re: Migration from Joomla 1.5 to Joomla 1.7
Posted: 26 Jul 2011, 18:40
by Jan
Hi, for now I don't know any migration script, try to install it newly, testing now and works ok in 2.0.1
Re: Migration from Joomla 1.5 to Joomla 1.7
Posted: 08 Oct 2011, 22:25
by Jan
Re: Migration from Joomla 1.5 to Joomla 1.7
Posted: 08 Nov 2011, 22:14
by jamfx
Hi Jan,
thanks for your Link. I tried to upgrade from a Joomla 1.5.24 to 1.7.2. On J! 1.5 there is the latest version of Phoca Maps (1.11I) installed. On J! 1.7 i have the version 2.0.2 installed:
I want to migrate all markers and maps to the new Joomla Version. But after following your instructions I got a 500 Error. This is the output:
Code: Select all
Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `j17_phocamaps_map` AS a LEFT JOIN `j17_languages` AS l ON l.lang_code = a.language LEFT JOIN j17_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `j17_phocamaps_map` AS a LEFT JOIN `j17_languages` AS l ON l.lang_code = a.language LEFT JOIN j17_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc LIMIT 0, 20 Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `j17_phocamaps_map` AS a LEFT JOIN `j17_languages` AS l ON l.lang_code = a.language LEFT JOIN j17_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `j17_phocamaps_map` AS a LEFT JOIN `j17_languages` AS l ON l.lang_code = a.language LEFT JOIN j17_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc
I don't know what to do. Please help me out.
Thanks!
JamFX
Re: Migration from Joomla 1.5 to Joomla 1.7
Posted: 09 Nov 2011, 23:17
by Jan
Hi, you didn't add the language columns, see:
https://www.phoca.cz/documents/50-phoca/ ... -joomla-17
at the bottom.
Jan
Re: Migration from Joomla 1.5 to Joomla 1.7
Posted: 10 Nov 2011, 10:18
by jamfx
Hi Jan,
thanks for your support and your hint. If I do the query (and replace jos with my prefix!) i got this sql-error:
Code: Select all
#1054 - Unknown column 'language' in 'field list'
What else did I missed......
Sorry and thanks
JamFX
Re: Migration from Joomla 1.5 to Joomla 1.7
Posted: 10 Nov 2011, 12:11
by jamfx
Ok i found out somtehing interessting, i think:
When I do the upgrade as written above and following your linked instructions, I can not make it work. The language parameter is missing in the db. I tried it with an alter table sql-query to insert the missing field, then it shows the maps and markers in the backend, but no markers in the frontend.
I tried something else: Uninstall all phocamaps extensions, deleted phocamaps tables in db. now I made a testentry and found out that the scheme has changed somehow. (at least language is missing...).
So in the new testentry markers are shown properly and everything works like charme!
Is there anything else I can do to transfer my maps and markers from 1.5 to 1.7 without doing everything by hand? The migrationguide seems not to work properly for phocamaps.
Thanks
JamFX
Re: Migration from Joomla 1.5 to Joomla 1.7
Posted: 11 Nov 2011, 21:50
by jamfx
Hi Jan,
do you have another solution for me. I asked a good friend here in Berlin from our JUG, but he has the same problem while following the migrationinstructions.
Please have another look. If you need anything more, let me know.
What we found out more is: even if you produce a new marker (while migrating with AlterTable and all this stuff) you will not see any marker in the frontend.
Thanks
JamFX
Re: Migration from Joomla 1.5 to Joomla 1.7
Posted: 13 Nov 2011, 10:04
by jamfx
Hi Jan,
do you have another Idea. Please let me know. Thanks!
JamFX
Re: Migration from Joomla 1.5 to Joomla 1.7
Posted: 16 Nov 2011, 09:37
by jamfx
Hi Jan,
as you can see, the thread reached a lot of hits in a short time. I think this solution could be relevant to a lot of people!
Thanks
JamFX