samedi 20 avril 2019

Laravel migration (errno: 150 “Foreign key constraint is incorrectly formed”)

I am trying to get specific data from the database by using columns chatter_discussion when a user clicks a link but I am getting this error:

SQLSTATE[HY000]: General error: 1005 Can't create table forums.chatter_discussion (errno: 150 "Foreign key constraint is incorrectly formed") (SQL: alter table chatter_discussion add constraint chatter_discussion_user_id_foreign foreign key (user_id) references users (id) on delete cascade on update cascade)

    Schema::table('chatter_discussion', function (Blueprint $table) {

        $table->foreign('chatter_category_id')->references('id')->on('chatter_categories')
                    ->onDelete('cascade')
                    ->onUpdate('cascade');
        $table->foreign('user_id')->references('id')->on('users')
                    ->onDelete('cascade')
                    ->onUpdate('cascade');
    });
    Schema::table('chatter_post', function (Blueprint $table) {
        $table->foreign('chatter_discussion_id')->references('id')->on('chatter_discussion')
                    ->onDelete('cascade')
                    ->onUpdate('cascade');
        $table->foreign('user_id')->references('id')->on('users')
                    ->onDelete('cascade')
                    ->onUpdate('cascade');
    });
}



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire