Migrating from joomla 1.0.15 to 1.5.10

[eddie_konczal]

I installed the Migrator plugins posted as a zip file above (using Migrator 1.5 in a Joomla! 1.0.15 site to migrate data from JEvents v1.4.2).

We're migrating to sites set up in Joomla 1.5 with Joomla! 1.0 Compatiblity mode, which will therefore run JEvents 1.4.3.

When trying to import the sql file into Joomla! 1.5.14, I get the following migration error:

Error at the line 849: ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Query:CREATE TABLE IF NOT EXISTS `jos_events` (
`id` int(12) NOT NULL auto_increment,
`sid` int(11) NOT NULL default '0',
`catid` int(11) NOT NULL default '1',
`title` varchar(100) NOT NULL default '',
`content` longtext NOT NULL,
`adresse_info` varchar(120) NOT NULL default '',
`contact_info` varchar(120) NOT NULL default '',
`extra_info` varchar(240) NOT NULL default '',
`color_bar` varchar(8) NOT NULL default '',
`useCatColor` tinyint(1) NOT NULL default '0',
`state` tinyint(3) NOT NULL default '0',
`mask` int(11) unsigned NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`created_by` int(11) unsigned NOT NULL default '0',
`created_by_alias` varchar(100) NOT NULL default '',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modified_by` int(11) unsigned NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
`images` text NOT NULL,
`reccurtype` tinyint(1) NOT NULL default '0',
`reccurday` varchar(4) NOT NULL default '',
`reccurweekdays` varchar(20) NOT NULL default '',
`reccurweeks` varchar(10) NOT NULL default '',
`approved` tinyint(1) NOT NULL default '1',
`ordering` int(11) NOT NULL default '0',
`archived` tinyint(1) NOT NULL default '0',
`access` int(11) unsigned NOT NULL default '0',
`hits` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
MySQL: You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 34
Stopped on error

The 1.0.15 Joomla! site was using iso-8859-1 encoding, not utf8. Could that be the showstopper?

Thanks,
Eddie

[eddie_konczal]

additional.... the old Joomla! site's table prefix is mos_, not jos_ (which seems to be what JEvents uses).

[eddie_konczal]

I'm unclear how to follow these directions:

Use the migrator tool to create an SQL data extract from joomla 1.0.15.

Then edit this file.

Just keep the line relating to jos_events and jos_events_categories together with the rows from jos_categories that have "section=events".

Then import this data into Joomla 1.5 using phpmyadmin or similar tool

I can use migrator, but how should I edit the file? Can it be done in a text editor? It seems all those lines are already together, but when I try importing into Joomla! 1.5.14 I get the error (see 2 posts back).

Can the data be imported upon Joomla! 1.5.14 configuration, along with all the rest of the Joomla! data in the 1.0.x sql file, or must it be done separately using phpmyadmin or similar tool?

Thanks,
Eddie

[eddie_konczal]

No longer an issue after upgrades to MySQL 5.0.26 / Joomla! 1.5.15