/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

7 votes97 views6 answers
Reset identity column in sql server
SQL
0 vote57 views1 answer
Big query add table rows to another table
SQL
5 votes101 views1 answer
Oracle ora-00054 causes
SQL
0 vote94 views1 answer
Mysql show category once count how many products
SQL
0 vote102 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
45 votes176 views5 answers
Grant all privileges mysql
SQL
10 votes102 views2 answers
Oracle alter sequence nextval
SQL
1 vote106 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote99 views1 answer
Check connections to database postgres
SQL
0 vote113 views1 answer
Neo4j command to run script file
SQL