/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 vote154 views1 answer
Select random sample sql
SQL
0 vote150 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
1 vote150 views1 answer
Set autoincrement to 0
SQL
0 vote233 views1 answer
Install ms sql server management studio
SQL
3 votes147 views2 answers
Sql server current date without time
SQL
0 vote141 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote152 views1 answer
My sql data file extention
SQL
1 vote232 views1 answer
Oracle datafile max size 32gb
SQL
1 vote173 views1 answer
Tsql create unique index composite
SQL
0 vote203 views1 answer
Postgres extract number from string
SQL