search

ubertheme / module-ubdatamigration

This is a module for Magento 2. This allow migrate data from Magento 1.x to Magento 2.x
https://www.ubertheme.com/magento-extensions-2-x/magento-2-data-migration-pro?utm_source=github&utm_medium=repo&utm_campaign=magento_migration_ce
48 stars 37 forks source link

CDbException #3

Closed vijayhwg closed 8 years ago

vijayhwg commented 8 years ago

Hi, https://github.com/ubertheme/module-ubdatamigration/blob/master/README.md

I have upload your module-ubdatamigration in my local system for data migration magento 1.9.1.1 to magento 2.0. Its working fine till 3 step but Getting error in Step-4 : Migrate Category

Error: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ 'home-1' pour la clef 'URL_REWRITE_REQUEST_PATH_STORE_ID'. The SQL statement executed was: INSERT INTO url_rewrite (redirect_type, is_autogenerated, entity_type, entity_id, request_path, target_path, store_id, description, metadata) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8)

pub\ub-tool\yii\db\CDbCommand.php(358)

Can you please help me? Thanks

quynhvv commented 8 years ago

@vijayhwg : Seem you have added any categories before use this tool? Please note that, you have to install a Magento2 fresh (without any data sample) before use this tool to migrate your data.

vijayhwg commented 8 years ago

Hi Quynh,

I have installed fresh magento 2 without sample data and then I have not created category, product or anything changes in magento 2 frontend or backend.

I have first installed magento 2 after install module-ubdatamigration using command. I follow same step as you define.

Thanks

quynhvv commented 8 years ago

Hi vijayhwg, Let's make reset the step 4 and re-try data migration in this step and tell me know how it goes.

salelsol commented 8 years ago

Hi, I can´t update data of the last three days (new customers registered and new oders recived).

Best Regards Toni Moya

quynhvv commented 8 years ago

@salelsol: If you want to update the latest customers, orders you can re-start the data migration on step 6 and step 7.

salelsol commented 8 years ago

Best Regards Toni Moya

balack commented 8 years ago

Hi Quynh Vu Van, I´ve reset many times steps 9, but not works and error Error 500 Undefined variable: migrated_tax_ids Can you help me, pls ? Thank you so much pic 1: http://pasteboard.co/yQm2YT5.png

pic 2: http://pasteboard.co/yQsxPxX.png

quynhvv commented 8 years ago

@balack : Yes, to solve the issue: http://pasteboard.co/yQsxPxX.png let open the php file in your Magento 2 at path: pub/ub-tool/protected/controllers/MigrateController.php

and find to the code lines:

//variables to log
$migrated_object_ids = array();
$migrated_tax_rule_ids = $migrated_tax_rate_ids = $migrated_catalog_rule_ids = array();

and replace it by code lines:

//variables to log
$migrated_object_ids = $migrated_tax_ids = array();
$migrated_tax_rule_ids = $migrated_tax_rate_ids = $migrated_catalog_rule_ids = array();

and reset the step 9 and restart the data migration on this step.

Do it to solve the issue.

Regards, quynhvv

salelsol commented 8 years ago

Best Regards Toni Moya

salelsol commented 8 years ago

Best Regards Toni

quynhvv commented 8 years ago

@salelsol: Thank you working around with this tool. For technical question, let's submit here: http://www.ubertheme.com/questions/ Regards, Mall.

ashokget commented 4 years ago

Hi, in the migration magento 1 to magento 2 got this error

CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'. The SQL statement executed was: INSERT INTO tax_calculation_rule (tax_calculation_rule_id, code, priority, position, calculate_subtotal) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4) using Migrate Data Tool of uberthme

plz help me out this is just final step 9

UberthemeTeam commented 4 years ago

Hi @ashokget ,

You can delete the record with primary key id=1 in the tax_calculation_rule table to solve that issue.

However, the script on our Github was based on an outdated code base which might lead to unexpected issues. We highly recommend you consider to move forward with our newer module version here.

Regards, Ubertheme team