Migration from Joomla 1.5 to Joomla 1.7

[Jan]

Hi, I don't have any other solution for migration then described here:
https://www.phoca.cz/documents/50-phoca/ ... -joomla-17



I didn't found easiest way to migrate (as there are two instances of Joomla! it is not so easy e.g. made by prepared script)

Jan

[jamfx]

Hi Jan,

the migration-steps are quite easy to solve, but they JUST DON'T WORK!
I don't need it easier. I just need a working solution to migrate the markers and maps from J15 to J17.

The SQL-Queries

Code: Select all

UPDATE `jos_phocamaps_map` SET `language` = '*';
UPDATE `jos_phocamaps_marker` SET `language` = '*';

Return errors. Beccause the `language`-Fields are missing (as I wrote already above).

What else can we do? Thanks!
JamFX

[Jan]

Hi, not sure what you mean, both columns are there.

install.bak.sql

Code: Select all

CREATE TABLE `#__phocamaps_map` (
...
  `params` text NOT NULL,
  `language` char(7) NOT NULL Default '',
  PRIMARY KEY  (`id`),
  KEY `cat_idx` (`published`,`access`),
  KEY `idx_access` (`access`),
  KEY `idx_checkout` (`checked_out`)
) ENGINE=MyISAM CHARACTER SET `utf8`;


CREATE TABLE `#__phocamaps_marker` (
 ...
  `params` text NOT NULL,
  `language` char(7) NOT NULL Default '',
  PRIMARY KEY  (`id`),
  KEY `catid` (`catid`,`published`)
) ENGINE=MyISAM CHARACTER SET `utf8`;

The same in script: phocamapsinstall.php

Code: Select all

$query ='CREATE TABLE IF NOT EXISTS `#__phocamaps_map` ('."\n";
$query.=' `hits` int(11) NOT NULL default \'0\','."\n";
...
		$query.=' `params` text NOT NULL,'."\n";
		$query.=' `language` char(7) NOT NULL Default \'\','."\n";
...
$query ='CREATE TABLE IF NOT EXISTS `#__phocamaps_marker` ('."\n";
...
$query.=' `params` text NOT NULL,'."\n";
		$query.=' `language` char(7) NOT NULL Default \'\','."\n";

[jamfx]

Hi Jan,

I don't know what the problem is. But I copied now every entry by hand.
Cheers
JamFX

[Jan]

Ok