/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

18 votes182 views3 answers
Get the list of all tables in sql server
SQL
32 votes173 views6 answers
Rename column mysql
SQL
0 vote142 views1 answer
Mysql bash execute sql file
SQL
0 vote95 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
0 vote198 views1 answer
SQL Server Altering Column to be Unique
SQL
0 vote154 views1 answer
Select nth row in mysql
SQL
1 vote154 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
3 votes160 views2 answers
MySQL query to get column names
SQL
-1 vote147 views1 answer
How to dump .csv file into mysql
SQL
0 vote158 views1 answer
Postgresql function ROUND
SQL