/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

4 votes122 views1 answer
Oracle show errors
SQL
1 vote115 views1 answer
How to get the date diff on once field in sql server
SQL
0 vote128 views1 answer
How to make full text search dynamic in mysql
SQL
-1 vote122 views3 answers
Psql get last rows
SQL
0 vote129 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote103 views1 answer
Oracle 11g forget password
SQL
0 vote109 views1 answer
Psql check if value in array
SQL
1 vote147 views1 answer
Postgres set sequence value to max id
SQL
0 vote155 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
0 vote128 views1 answer
How to change mysql root password in windows 10
SQL