Error on reset product migration

Hi support,
 
I am using UB Data Migration Lite . During reset product migration I am getting this error. How can I get rid from it ?
 
CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint. 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’;
 
 

1 answer

Profile photo of ubdev Staff 98150.00 $tone February 10, 2021
Public

Hi Shiv Parmar,
 
Thanks for working around with our Lite version. 
 
It seems that you’re using the Lite version distributed via Github. It’s a pity that we no longer maintain this script. We also have another Lite version at Ubertheme, however, it is also based on an outdated codebase as well. 
 
We highly recommend you consider using our newer UB Data Migration Pro module, it will save you pretty much time. 
 
Regards,
Ubertheme team
 

#1

Please login or Register to Submit Answer

Written By

Comments