Converting 1.5 databases to 2.5 - Joomla! Forum - community, help and support
hi,
i trying migrate old 1.5 website 2.5 using backup files , databases. not able use usual migration extensions it, because there no room left on hosting upload them. instead, have had delete old info , start again 2.5. uploading old files via ftp new public html, seems ok. importing sql database proving problematic.
if try create blank new database , import it, myphp comes sort of thing:
any clues, or walkthroughs this?
many thanks!
i trying migrate old 1.5 website 2.5 using backup files , databases. not able use usual migration extensions it, because there no room left on hosting upload them. instead, have had delete old info , start again 2.5. uploading old files via ftp new public html, seems ok. importing sql database proving problematic.
if try create blank new database , import it, myphp comes sort of thing:
sql query:
-- -- dumping data table `jos_assets` -- insert `jos_assets` (`id`, `parent_id`, `lft`, `rgt`, `level`, `name`, `title`, `rules`) values (1, 0, 1, 71, 0, 'root.1', 'root asset', '{"core.login.site":{"6":1,"2":1},"core.login.admin":{"6":1},"core.login.offline":{"6":1},"core.admin":{"8":1},"core.manage":{"7":1},"core.create":{"6":1,"3":1},"core.delete":{"6":1},"core.edit":{"6":1,"4":1},"core.edit.state":{"6":1,"5":1},"core.edit.own":{"6":1,"3":1}}'), (2, 1, 1, 2, 1, 'com_admin', 'com_admin', '{}'), (3, 1, 3, 6, 1, 'com_banners', 'com_banners', '{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'), (4, 1, 7, 8, 1, 'com_cache', 'com_cache', '{"core.admin":{"7":1},"core.manage":{"7":1}}'), (5, 1, 9, 10, 1, 'com_checkin', 'com_checkin', '{"core.admin":{"7":1},"core.manage":{"7":1}}'), (6, 1, 11, 12, 1, 'com_config', 'com_config', '{}'), (7, 1, 13, 16, 1, 'com_contact', 'com_contact', '{"core.admin":{"7":1},"core.mana[...]
mysql said: documentation
#1062 - duplicate entry '1' key 'primary'
any clues, or walkthroughs this?
many thanks!
the primary key id field check import , make sure there not either 2 inserts same table or row id set "1". i'm pretty sure "root" asset needs 1 other issue might if id being automatically incremented mysql. pretty i've found error messages indicative of happening.
Comments
Post a Comment