Error SQLSTATE: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails. Trying to create or update a record in your database and you get the above error? here is a solution for it.
Why you’re seeing this error of integrity Constraint violation
At the point of creating your database migrations, you have defined a set of policies on a foreign key that is now preventing you from creating or updating your records.
If you’ve hit this error as a result of trying to insert a new record into your table, then you’ve failed to provided the needed foreign key information that references a valid record on the other table.
Solution to 1452 integrity Constraint violation
Make sure you’re providing all the needed information most especially the foreign key that references a record on the other table.
Likewise if you’re trying to update a record and then you hit this error.. you have forgotten to include a foreign key.