/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

23 votes130 views4 answers
How to uninstall postgresql in ubuntu
SQL
9 votes142 views4 answers
Last mysql
SQL
0 vote145 views1 answer
Leftjoin in sql
SQL
2 votes166 views1 answer
Username sql
SQL
0 vote130 views2 answers
T sql null or empty string
SQL
2 votes118 views3 answers
Postgres remove foreign key constraint
SQL
0 vote160 views2 answers
Sql update multiple tables
SQL
0 vote131 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
0 vote146 views1 answer
Except in sql
SQL
0 vote100 views1 answer
Oracle sysdba connect as another user
SQL