Cannot delete or update a parent row: a foreign key constraint fails

How do we solve this problem?

SET FOREIGN_KEY_CHECKS = 0; — invalid

1 Like

Please don’t use screenshots. Copy/paste from terminal and use the formatting tools. Looking at tiny screenshots and attempting to ascertain the problem is difficult.

I don’t see this in your screenshot: pt-archiver --skip-foreign-key-checks

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_foreign_key_checks

1 Like

Thank you. I’ll try.

1 Like