Error Migrating 1.0.15 to 1.5 - please help - Joomla! Forum - community, help and support
hi there, i'm trying upgrade/migrate joomla 1.0.15 site joomla 1.5. i've followed instructions, , i'm getting error message:
====
error @ line 355: insert jos_content (`id`,`title`,`title_alias`,`introtext`,`fulltext`,`state`,`sectionid`,`mask`,`catid`,`created`,`created_by`,`created_by_alias`,`modified`,`modified_by`,`checked_out`,`checked_out_time`,`publish_up`,`publish_down`,`images`,`urls`,`attribs`,`version`,`parentid`,`ordering`,`metakey`,`metadesc`,`access`,`hits`,`alias`) values ( '198','rob elliott','rob elliott','
rob elliott \r\nsaturday 21 november - friday 11 december
','','0','7','0','42','2009-08-12 12:59:43','63','','2009-08-12 13:00:44','0','0','0000-00-00 00:00:00','2009-08-12 12:58:56','0000-00-00 00:00:00','','','pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=','1','0','6','','','0','0','rob-elliott');
query:insert jos_content (`id`,`title`,`title_alias`,`introtext`,`fulltext`,`state`,`sectionid`,`mask`,`catid`,`created`,`created_by`,`created_by_alias`,`modified`,`modified_by`,`checked_out`,`checked_out_time`,`publish_up`,`publish_down`,`images`,`urls`,`attribs`,`version`,`parentid`,`ordering`,`metakey`,`metadesc`,`access`,`hits`,`alias`) values ( '198','rob elliott','rob elliott','<p>rob elliott<br />\r\nsaturday 21 november - friday 11 december</p>','','0','7','0','42','2009-08-12 12:59:43','63','','2009-08-12 13:00:44','0','0','0000-00-00 00:00:00','2009-08-12 12:58:56','0000-00-00 00:00:00','','','pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=','1','0','6','','','0','0','rob-elliott');
mysql: duplicate entry '198' key 1
stopped on error
=====
i've tried 3 times, getting same error message. times creating new migration sql file 1.0.15 site. i've tried uploading 'migration.sql' file 'installation/sql/migration' directory well. keep getting same error.
can help?
thanks much.
====
error @ line 355: insert jos_content (`id`,`title`,`title_alias`,`introtext`,`fulltext`,`state`,`sectionid`,`mask`,`catid`,`created`,`created_by`,`created_by_alias`,`modified`,`modified_by`,`checked_out`,`checked_out_time`,`publish_up`,`publish_down`,`images`,`urls`,`attribs`,`version`,`parentid`,`ordering`,`metakey`,`metadesc`,`access`,`hits`,`alias`) values ( '198','rob elliott','rob elliott','
rob elliott \r\nsaturday 21 november - friday 11 december
','','0','7','0','42','2009-08-12 12:59:43','63','','2009-08-12 13:00:44','0','0','0000-00-00 00:00:00','2009-08-12 12:58:56','0000-00-00 00:00:00','','','pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=','1','0','6','','','0','0','rob-elliott');
query:insert jos_content (`id`,`title`,`title_alias`,`introtext`,`fulltext`,`state`,`sectionid`,`mask`,`catid`,`created`,`created_by`,`created_by_alias`,`modified`,`modified_by`,`checked_out`,`checked_out_time`,`publish_up`,`publish_down`,`images`,`urls`,`attribs`,`version`,`parentid`,`ordering`,`metakey`,`metadesc`,`access`,`hits`,`alias`) values ( '198','rob elliott','rob elliott','<p>rob elliott<br />\r\nsaturday 21 november - friday 11 december</p>','','0','7','0','42','2009-08-12 12:59:43','63','','2009-08-12 13:00:44','0','0','0000-00-00 00:00:00','2009-08-12 12:58:56','0000-00-00 00:00:00','','','pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=','1','0','6','','','0','0','rob-elliott');
mysql: duplicate entry '198' key 1
stopped on error
=====
i've tried 3 times, getting same error message. times creating new migration sql file 1.0.15 site. i've tried uploading 'migration.sql' file 'installation/sql/migration' directory well. keep getting same error.
can help?
thanks much.
for instructions on how migrate go here : http://docs.joomla.org/migrating_from_1 ... 1.5_stable
Comments
Post a Comment