/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

0 vote314 views3 answers
Characters found after end of sql statement
SQL
1 vote270 views3 answers
Sql server get week dates from week number
SQL
1 vote278 views1 answer
Oracle extract minute from date
SQL
13 votes288 views2 answers
Sqlite rename table
SQL
0 vote279 views1 answer
Flask sqlalchemy session delete
SQL
0 vote283 views1 answer
Change database name psql 8
SQL
0 vote284 views1 answer
Psql store procedure-return multiple table values
SQL
9 votes287 views6 answers
Check constraint in sql
SQL
37 votes265 views3 answers
Postgresql insert column
SQL
0 vote271 views1 answer
Call procedure in wordpress
SQL