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 38 forks source link

error step 5 #46

Open Lvenkin2 opened 5 years ago

Lvenkin2 commented 5 years ago
CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1005 Can't create table `admin_mag`.`catalog_product_entity_tier_price` (errno: 150 "Foreign key constraint is incorrectly formed"). The SQL statement executed was: CREATE TABLE `catalog_product_entity_tier_price` (
`value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
`entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
`all_groups` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Applicable To All Customer Groups',
`customer_group_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer Group ID',
`qty` decimal(12,4) NOT NULL DEFAULT '1.0000' COMMENT 'QTY',
`value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Value',
`website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
PRIMARY KEY (`value_id`),
UNIQUE KEY `UNQ_E8AB433B9ACB00343ABB312AD2FAB087` (`entity_id`,`all_groups`,`customer_group_id`,`qty`,`website_id`),
KEY `CATALOG_PRODUCT_ENTITY_TIER_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`),
KEY `CATALOG_PRODUCT_ENTITY_TIER_PRICE_WEBSITE_ID` (`website_id`),
CONSTRAINT `CAT_PRD_ENTT_TIER_PRICE_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_PRD_ENTT_TIER_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_PRD_ENTT_TIER_PRICE_WS_ID_STORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Tier Price Attribute Backend Table';
UberthemeTeam commented 5 years ago

Hi @Lvenkin2 ,

Thanks for working around with our migration script here at Github.

It's pity that we no longer maintain this outdated script due to our limited resources. We replaced it with a newer Pro version here.

We're biased when referring to our Pro version, yet it will definitely save you pretty much time.

PS. Our Pro version is fully compatible with the latest Magento 2.3.1.

Regards, Ubertheme team