Breaking News: Grepper is joining You.com. Read the official announcement!

foreign key constraint is incorrectly formed laravel

Add Answer

Adreeeyan F. answered on April 11, 2021 Popularity 9/10 Helpfulness 6/10

answer foreign key constraint is incorrectly formed laravel

related foreign key constraint is incorrectly formed laravel

related laravel Foreign key constraint is incorrectly formed

foreign key constraint is incorrectly formed laravel

Comment

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');
        });
    }

Popularity 9/10 Helpfulness 6/10 Language php

Source: stackoverflow.com

Tags: key laravel php

Link to this answer
Share Copy Link

Contributed on Jul 26 2022

Adreeeyan F.

0 Answers Avg Quality 2/10

Closely Related Answers

foreign key constraint is incorrectly formed laravel

Comment

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');

Popularity 10/10 Helpfulness 5/10 Language php

Source: Grepper

Tags: key

Link to this answer
Share Copy Link

Contributed on Apr 11 2021

Mohamad

0 Answers Avg Quality 2/10

laravel Foreign key constraint is incorrectly formed

Comment

if you added nullOnDelete() then you need to add nullable() also

// Right Way
$table->foreignId('user_id')->nullable()->constrained()->nullOnDelete();

// wrong way
$table->foreignId('user_id')->constrained()->nullOnDelete();

Popularity 5/10 Helpfulness 3/10 Language php

Source: Grepper

Tags: key laravel php

Link to this answer
Share Copy Link

Contributed on Oct 22 2023

Witness

0 Answers Avg Quality 2/10

foreign key constraint is incorrectly formed laravel

Contents

More Related Answers

foreign key constraint is incorrectly formed laravel

Closely Related Answers

foreign key constraint is incorrectly formed laravel

laravel Foreign key constraint is incorrectly formed

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.