How to fix error on Foreign key constraint incorrectly formed in migrating a table in Laravel

by

When creating a new table in Laravel. A migration will be generated like:

$table->bigIncrements('id');

Instead of (in older Laravel versions):

$table->increments('id');

When using bigIncrements the foreign key expects a bigInteger instead of an integer. So your code will look like this:

public function up()
    {
        Schema::create('meals', function (Blueprint $table) {
            $table->increments('id');
            $table->unsignedBigInteger('user_id'); //changed this line
            $table->unsignedBigInteger('category_id'); //changed this line
            $table->string('title');
            $table->string('body');
            $table->string('meal_av');
            $table->timestamps();

            $table->foreign('user_id')
                ->references('id')
                ->on('users')
                ->onDelete('cascade');

            $table->foreign('category_id')
                ->references('id')
                ->on('categories')
                ->onDelete('cascade');
        });
    }

You could also use increments instead of bigIncrements like Kiko Sejio said.

The difference between Integer and BigInteger is the size:

  • int => 32-bit
  • bigint => 64-bit

More Related Contents:

  1. Laravel migration: “Foreign key constraint is incorrectly formed” (errno 150)
  2. Laravel Eloquent groupBy() AND also return count of each group
  3. Laravel – Route::resource vs Route::controller
  4. Laravel 4 All Routes Except Home Result in 404 Error
  5. global variable for all controller and views
  6. multiple mail configurations
  7. Laravel. Use scope() in models with relation
  8. Laravel 4: how to run a raw SQL?
  9. How to disable CSRF Token in Laravel and why we have to disable it?
  10. Laravel Session always changes every refresh / request in Laravel 5.4
  11. Class ‘Illuminate\Html\HtmlServiceProvider’ not found Laravel 5
  12. HasManyThrough with one-to-many relationship
  13. Getting just the latest value on a joined table with Eloquent
  14. Rollback one specific migration in Laravel
  15. laravel Unable to prepare route … for serialization. Uses Closure
  16. Validation of array form fields in laravel 4 error
  17. Laravel VueJs : `router-view` does not render the component
  18. “Please provide a valid cache path” error in laravel
  19. How to access model hasMany Relation with where condition?
  20. How to clear Laravel route caching on server
  21. How to add jQuery in Laravel project
  22. Laravel 4: Failed to open stream: Permission denied
  23. Vue.js – validation fails for file upload in axios when multipart/form-data used in header
  24. How to change value of a request parameter in laravel
  25. Laravel save / update many to many relationship
  26. I’m getting error “Class ‘Predis\Client’ not found” in Laravel 5.2
  27. Error Field doesn’t have a default value in laravel 5.3
  28. Laravel 4 : Route to localhost/controller/action
  29. laravel migration best way to add foreign key
  30. Install vue 3.0 in laravel

Leave a Comment