data migration database error

Reply·Subscribe

sanneAdvanced

18 posts

hello everybody,

when i try to migrate the databaes fron 6 to 7 the miration starts for the first 279 profiles,

and then it stops.

Then i get this error mail:

Database error in

Query:

UPDATE `Profiles` SET `ID` = '31078' WHERE `ID` = '15'

Mysql error: Duplicate entry '31078' for key 1

Found error in the file '/var/www/xxxxxxx/html/dolphin7/modules/boonex/data_migration/classes/BxDataMigrationProfiles.php' at line 164.
Called 'query' function with erroneous argument #0.

Debug backtrace:

profile 31078 is the admin profile in dolphin 7

What can i do to fix this problem???

best regards sanne

Quote · 7 Feb 2010

prolaznikAdvanced

2200 posts

hello everybody,

when i try to migrate the databaes fron 6 to 7 the miration starts for the first 279 profiles,

and then it stops.

Then i get this error mail:

Database error in

Query:

UPDATE `Profiles` SET `ID` = '31078' WHERE `ID` = '15'

profile 31078 is the admin profile in dolphin 7

What can i do to fix this problem???

best regards sanne

it tells you right there what the problem is :)
your d6 site and d7 site both have the admin username
all you have do to is rename one

Quote · 7 Feb 2010

SashaEUndefined

2858 posts

hello everybody,

when i try to migrate the databaes fron 6 to 7 the miration starts for the first 279 profiles,

and then it stops.

Then i get this error mail:

Database error in

Query:

UPDATE `Profiles` SET `ID` = '31078' WHERE `ID` = '15'

profile 31078 is the admin profile in dolphin 7

What can i do to fix this problem???

best regards sanne

Hello, I think you attempted profiles transfer twice. Will try to edit you admin id in manual via you phpMyAdmin. Will set id = 1 for your admin profiles and start transfer again

PS: If possible do not write me personally, please try to ask on the forum first

Quote · 7 Feb 2010

Reply ›

data migration database error

Blogs

Help

Product

Company