/SQL/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.

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

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

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

Source: stackoverflow.com

Similar codes

1 vote129 views2 answers
String to date postgres
SQL
3 votes131 views1 answer
Select count from table mysql
SQL
58 votes309 views6 answers
Create new user in postgres
SQL
8 votes134 views6 answers
Sql insert
SQL
8 votes126 views5 answers
Grant permission in postgres
SQL
0 vote137 views1 answer
Import sql in postgresql
SQL
0 vote132 views1 answer
Psql attribute cannot login
SQL
0 vote135 views1 answer
Querry mysql by 2 columns
SQL
0 vote127 views1 answer
Oracle activate program
SQL
0 vote145 views2 answers
How to get max from each department in sql
SQL