/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 vote324 views1 answer
Postgresql linux password
SQL
1 vote311 views1 answer
Mysql workbench in ubuntu 14.04
SQL
0 vote290 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
0 vote336 views1 answer
Order child below the parent in mysqli
SQL
0 vote282 views1 answer
Mysql select distinct date from timestamp
SQL
1 vote384 views1 answer
Postgresql can you have null foreign key
SQL
0 vote315 views1 answer
Sql menampilkan data tabel
SQL
20 votes365 views4 answers
Sql count if
SQL
0 vote318 views1 answer
Mysql match in serialized data
SQL
1 vote312 views3 answers
Mysql Server Start
SQL