Fixed to SQLSTATE[23000]: Integrity constraint violation

Error SQLSTATE[23000]: 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.

Leave a Comment

%d bloggers like this: