/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

5 votes275 views1 answer
Ascending order and where in sql
SQL
35 votes333 views5 answers
Sql alter column
SQL
0 vote285 views1 answer
Sqlite commands
SQL
0 vote276 views1 answer
How to find database collation in postgres
SQL
5 votes286 views1 answer
Oracle ORA-00054 origin
SQL
-1 vote295 views2 answers
Postgresql get last 10 records
SQL
0 vote292 views3 answers
Query string not ending with with vowels
SQL
0 vote284 views1 answer
How to create a table in sql stack overflow
SQL
2 votes328 views2 answers
Mysql compare datetime to another datetime
SQL
0 vote286 views1 answer
Sql contains vs like
SQL