Magento catalog_product_relation MySQL Error

On transferring a Magento website Database running on MySQL 5.7.34 to MariaDB 10.2.39, I get the following error

[root@server52 etc]# mysql buildingplans_m1 < db.sql
ERROR 1005 (HY000) at line 4080: Can't create table `buildingplans_m1`.`catalog_product_relation` (errno: 140 "Wrong create options")
[root@server52 etc]# 

SQL Strict mode was already off on this MySQL server.

MariaDB [(none)]> select @@sql_mode;
+------------+
| @@sql_mode |
+------------+
|            |
+------------+
1 row in set (0.00 sec)

MariaDB [(none)]>

To fix the problem, edited the db.sql file, added

set innodb_strict_mode = off;

at the top of the file. After this change, the restore worked without any error.

See Magento

Need help with Linux Server or WordPress? We can help!

Leave a Reply

Your email address will not be published. Required fields are marked *