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

by

Yes, it’s your schema. The constraint on likes.post_id will prevent you from deleting records from the posts table.

One solution could be using onDelete('cascade') in the likes migration file:

Schema::create('likes', function (Blueprint $table) {
    $table->integer('post_id')->unsigned();
    $table->foreign('post_id')->references('id')->on('posts')->onDelete('cascade');
});

This way, when a post is deleted, all related likes will be deleted too.

Or, if you have a relationship from the Post model to the Like model, you can $post->likes()->delete() before deleting the post itself.

More Related Contents:

  1. How do I store a custom user selected CSS template style (like wordpress visual editor)? [closed]
  2. Laravel – only a zero is saved to the database
  3. How to use multiple databases in Laravel
  4. How to do this in Laravel, subquery where in
  5. Laravel 5 PDOException Could Not Find Driver
  6. Laravel migration: unique key is too long, even if specified
  7. Laravel: PDOException: could not find driver
  8. Laravel Eloquent select all rows with max created_at
  9. Laravel: connect to databases dynamically
  10. Laravel OrderBy relationship count
  11. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  12. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  13. SQLSTATE[HY000] [2002] A connection attempt failed.. – When attempting to connect from Local to remote server
  14. Laravel Migration table already exists, but I want to add new not the older
  15. “No such file or directory” or “No such host is known” when running migrations
  16. belongsToMany relationship in Laravel across multiple databases
  17. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  18. Laravel Eloquent get results grouped by days
  19. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  20. Change name of Laravel’s created_at and updated_at
  21. Base table or view not found: 1146 Table Laravel 5
  22. How do I get database column names in Laravel?
  23. How to get MySql 8 to run with laravel? [duplicate]
  24. Eloquent many-to-many-to-many – how to load distant relation easily
  25. Mysql InnoDB engine in Laravel
  26. PHP Laravel: No connection could be made because the target machine actively refused it
  27. How to create a database-driven multi-level navigation menu using Laravel
  28. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  29. Check if laravel model got saved or query got executed
  30. find in set in laravel ? example

Leave a Comment