Page 2 of 2
Re: Migration from Joomla 1.5 to Joomla 1.7
Posted: 17 Nov 2011, 23:07
by 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
Re: Migration from Joomla 1.5 to Joomla 1.7
Posted: 18 Nov 2011, 13:16
by 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
Re: Migration from Joomla 1.5 to Joomla 1.7
Posted: 23 Nov 2011, 19:02
by 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";
Re: Migration from Joomla 1.5 to Joomla 1.7
Posted: 24 Nov 2011, 13:32
by jamfx
Hi Jan,
I don't know what the problem is. But I copied now every entry by hand.
Cheers
JamFX
Re: Migration from Joomla 1.5 to Joomla 1.7
Posted: 24 Nov 2011, 15:31
by Jan
Ok