/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 vote112 views1 answer
How to connect to xampp sql server on windows cmd
SQL
1 vote102 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
2 votes149 views1 answer
Remove foreign key constraints in postgres
SQL
0 vote100 views1 answer
Postgresql interview questions
SQL
-1 vote118 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
0 vote106 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote103 views1 answer
Oracle sql copy table without data
SQL
1 vote108 views1 answer
Mysql pretty date format
SQL
0 vote106 views4 answers
Sql rownum
SQL
0 vote95 views1 answer
Mysql find missing values
SQL