Włącz to:
foreign_key_checks | ON
SET FOREIGN_KEY_CHECKS = 1;
http://www.sqlines.com/mysql/set_foreign_key_checks
Weź to wyrzuć:
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO';
SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0;
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
i sprawdź, czy bez tego pójdzie.
https://mariadb.org/mariadb-innodb-foreign-key-constraint-errors/