JEvents 1.4

Migrating from joomla 1.0.15 to 1.5.10

Postby eddie_konczal » Wed Aug 12, 2009 5:34 pm

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
 
Posts: 23
Joined: Wed Aug 12, 2009 2:48 pm

Postby eddie_konczal » Wed Aug 12, 2009 5:36 pm

additional.... the old Joomla! site's table prefix is mos_, not jos_ (which seems to be what JEvents uses).
eddie_konczal
 
Posts: 23
Joined: Wed Aug 12, 2009 2:48 pm

Postby eddie_konczal » Fri Aug 14, 2009 7:31 pm

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
 
Posts: 23
Joined: Wed Aug 12, 2009 2:48 pm

Postby eddie_konczal » Fri Dec 11, 2009 7:57 pm

No longer an issue after upgrades to MySQL 5.0.26 / Joomla! 1.5.15
eddie_konczal
 
Posts: 23
Joined: Wed Aug 12, 2009 2:48 pm

Postby alechs » Mon Jan 27, 2014 4:52 pm

Good evening everyone,
I'm doing a migration of a Joomla from version 1.0 to version 3. To do this migration must first migrate from version 1.0 to version 1.5, but I can not download the plugin events_migrator_plugins.zip more. Can you help?
thanks
alechs
 
Posts: 3
Joined: Mon Jan 27, 2014 4:46 pm

Postby Tonyp » Mon Jan 27, 2014 7:06 pm

Hello,

Why can you not download the plugin? where is it you are trying to get it from?

Thanks
Tony
---------------------------------------
Feel free to PM me if you would like Custom Installs or Joomla! related work for a competitive quote.

User avatar
Tonyp
Team Staff
 
Posts: 23841
Joined: Tue Oct 12, 2010 9:12 pm
Location: Isle of Man

Postby alechs » Mon Jan 27, 2014 8:52 pm

I'm tryng to download to the link at the first page of this thread
alechs
 
Posts: 3
Joined: Mon Jan 27, 2014 4:46 pm

Previous

Return to JEvents 1.4

  • Who is online
  • View new posts
  • View unanswered posts
  • In total there are 0 users online :: 0 registered and 0 hidden (based on users active over the past 5 minutes)
  • Most users ever online was 94 on Tue Sep 01, 2009 12:33 am
  • Users browsing this forum: No registered users