Can’t create table `catalog_product_relation` (errno: 140 “Wrong create options”)
When I try to restore the MySQL database of a Magento 1.x site on MariaDB 10.3.32 (source MySQL 5.7.36), I get the following error
|
1 2 3 |
boby@sok-01:/www/magento/amazingplans/backup$ mysql amazingplans < amazingp_demo.sql ERROR 1005 (HY000) at line 4080: Can't create table `amazingplans`.`catalog_product_relation` (errno: 140 "Wrong create options") boby@sok-01:/www/magento/amazingplans/backup$ |
On checking the line in the error message, I found the error is due to the following SQL statement.
|
1 2 3 4 5 6 7 8 |
CREATE TABLE `catalog_product_relation` ( `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Parent ID', `child_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Child ID', PRIMARY KEY (`parent_id`,`child_id`), KEY `IDX_CATALOG_PRODUCT_RELATION_CHILD_ID` (`child_id`), CONSTRAINT `FK_CAT_PRD_RELATION_CHILD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`child_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_CAT_PRD_RELATION_PARENT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`parent_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Catalog Product Relation Table'; |
Fixed it by removing
|
1 |
ROW_FORMAT=FIXED |
From the SQL.