/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

1 vote240 views2 answers
Changes not showing on website server odoo
SQL
2 votes238 views1 answer
Sql column values comma separated
SQL
9 votes250 views2 answers
Nosql databases
SQL
1 vote237 views1 answer
Sql where last 12 months
SQL
0 vote235 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote221 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
18 votes219 views2 answers
Sql comments
SQL
1 vote238 views1 answer
Mysql data from file
SQL
1 vote234 views1 answer
Mariadb case switch
SQL
0 vote226 views1 answer
Minus equivalent in my sql
SQL