/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

3 votes276 views1 answer
Oracle function
SQL
1 vote217 views1 answer
Sql current timestamp
SQL
1 vote267 views1 answer
Pgsql sum switch case
SQL
0 vote223 views1 answer
Creating h2 database in relative directory eclopse
SQL
0 vote215 views1 answer
Modifier une valeur sql
SQL
0 vote247 views1 answer
Change date in pivot table to month in sql server
SQL
0 vote205 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote201 views1 answer
Sql count null values in all columns
SQL
1 vote302 views1 answer
Sql server read uncommitted
SQL
6 votes236 views2 answers
Mysqldump password in file
SQL