import database backup leads to foreign key error
SQL-Befehl: ALTER TABLE `atBoolean` ADD CONSTRAINT `FK_5D5F70A9A2A82A5D` FOREIGN KEY (`avID`) REFERENCES `AttributeValues` (`avID`) ON DELETE CASCADE MySQL meldet: Dokumentation #1452 - Cannot add or update a child row: a foreign key constraint fails (`shaolinsteyr`.`#sql-af3_8b`, CONSTRAINT `FK_5D5F70A9A2A82A5D` FOREIGN KEY (`avID`) REFERENCES `AttributeValues` (`avID`) ON DELETE CASCADE)
the problem is, i moved my site and i imported the databese with disabled foreign keys. now my site is working, but adding some addons doesn't work. all my database backups are leading to the same error. how can i fix this?
ok, i have now my whole site locally for testing. in the github thread you mentioned i found this:
i don't know where and how to run this. i think
php ./concrete/bin/concrete5 orm:schema-tool:update --dump-sql
Run SET FOREIGN_KEY_CHECKS=0; Run the SQL that was outputted by the orm:schema-tool Run SET FOREIGN_KEY_CHECKS=1;