/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 vote317 views1 answer
Minecraft duping allowed servers
SQL
4 votes342 views2 answers
Mysql how to change default charset
SQL
49 votes413 views6 answers
Mysql add column to table
SQL
0 vote311 views1 answer
Sql roll up rows into columns
SQL
0 vote414 views1 answer
Plpgsql create function
SQL
2 votes336 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote296 views1 answer
Select mysql limit to 2 decimal places
SQL
0 vote360 views3 answers
Condition in count sql
SQL
1 vote308 views1 answer
Update from select join
SQL
16 votes351 views1 answer
Mssql int max value
SQL