Migration from Joomla 1.5 to Joomla 1.7

[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

[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

[Jan]

Hi, try to see:
https://www.phoca.cz/documents/50-phoca/ ... -joomla-17

Jan

[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

[Jan]

Hi, you didn't add the language columns, see:
https://www.phoca.cz/documents/50-phoca/ ... -joomla-17
at the bottom.

Jan

[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

[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

[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

[jamfx]

Hi Jan,

do you have another Idea. Please let me know. Thanks!
JamFX

[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