I've replied in your ticket, but here again I'll copy my response for the other users wondering how to do this:
The only thing you need to do is to copy the tables from your joomla 1.5 to your 2.5 installation. Use phpmyadmin for this. You click export->select the hotspots tables -> export them. And then import them in your new database (make sure that they have the same database prefix as your jooomlma 2.5 site)
Once you have the tables in place - just install hotspots on your new site and it should pick up the data... (you will maybe need to make a new menu entry, but that is all)
I have done this and I am experiencing a lot of problems, locations wont save
ave failed with the following error: TableMarker: :store failed
Unknown column 'publish_up' in 'field list' SQL=UPDATE `jos_hotspots_marker` SET `catid`='1',`name`='Windoor Aluminium Johannesburg',`street`='Makriel Rd ',`plz`='1422',`town`='Germiston',`country`='South Africa',`gmlat`='-26.273155',`gmlng`='28.18733199999997',`description`='',`description_small`='
',`picture`='',`picture_thumb`='',`autor`='gary kirkham',`autorip`='126.96.36.199',`autoruserid`='65',`postdate`='2012-08-13 17:58:42',`vote`='0',`votenum`='0',`published`='1',`publish_up`='2012-11-13 13:57:41',`modified`='2012-11-13 13:57:41',`modified_by`='268' WHERE `id`='5'
Markers are not not showing, cant seem to load custom markers as I am having saving issues
Re: Migrate from Joomla 1.5 to Joomla 1.7/2.5
8 years 2 months ago #18422