/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 vote305 views1 answer
Mysql show database size in mb
SQL
0 vote294 views2 answers
Find lowest number in sql
SQL
16 votes322 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
7 votes308 views3 answers
Sql server reset auto increment
SQL
1 vote296 views1 answer
How to check the mysql version mac
SQL
0 vote274 views1 answer
Postgresql parse json array
SQL
3 votes284 views1 answer
Oracle function
SQL
54 votes497 views6 answers
Sql rename column
SQL
1 vote291 views1 answer
Oracle create program if no exists
SQL
16 votes321 views1 answer
Mysql reset auto increment value
SQL