errno: 150 "Foreign key constraint is incorrectly formed"

Getting this error while adding foreign key in my table.


Code:-

Code:

public function up()
    {
        Schema::create('articles', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->unsignedBigInteger('user_id');
            $table->string('title');
            $table->text('excerpt');
            $table->text('body');
            $table->timestamps();

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

the referenced and referencing fields must have exactly the same data type. this can not be stressed enough.

for bigincrements expected data type is bigInteger('column_name')->unsigned();

for increments expected is integer('column_name')->unsigned(); etc.

Code:

public function up()
    {
        Schema::create('articles', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->string('title', 100);
            $table->text('excerpt');
            $table->text('body');
            $table->timestamps();

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

Try This.

It's ok I've solved it already. Actually there wasn't any fault in code, the fault was somehow I created the user table after the article table, but it should be: user table first and then the other tables. Now its working fine. Thanks for the responses tho.<3