SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.

Lokesh003Coding answered on November 28, 2020 Popularity 9/10 Helpfulness 8/10

answer SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.

SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.

Comment

As the name says the referenced foreign key and the id in the table are not of 
same type. 

Example : 

// user_id foreign key referenced table
$table->bigInteger('user_id')->unsigned()->index();
$table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');


// Then inside users table
$table->bigIncrements('id')->unsigned()->index();

Popularity 9/10 Helpfulness 8/10 Language sql

Source: Grepper

Tags: key sql

Link to this answer
Share Copy Link

Contributed on Nov 30 2020

Lokesh003Coding

0 Answers Avg Quality 2/10

Closely Related Answers

General error: 3780 Referencing column 'user_id' and referenced column 'id' in foreign key constraint 'blog_posts_user_id_foreign' are incompatible.

Comment

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

Popularity 9/10 Helpfulness 5/10 Language whatever

Source: stackoverflow.com

Tags: key

Link to this answer
Share Copy Link

Contributed on Nov 28 2020

Unfunny Flamingo

0 Answers Avg Quality 2/10

SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.

Contents

More Related Answers

SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.

Closely Related Answers

General error: 3780 Referencing column 'user_id' and referenced column 'id' in foreign key constraint 'blog_posts_user_id_foreign' are incompatible.

Grepper

Documentation

Social

Legal

Contact

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