/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

2 votes177 views1 answer
Oracle sql drop table purge
SQL
0 vote180 views1 answer
Tsql default value when no value returned by query
SQL
0 vote218 views1 answer
Mssql find deadlocks
SQL
0 vote185 views1 answer
Azure sql server check foreign key
SQL
3 votes181 views1 answer
Oracle apex call duration
SQL
0 vote198 views1 answer
How to get parent and child record in single query using sql
SQL
0 vote167 views1 answer
Narural join
SQL
0 vote145 views1 answer
Postgresql add leading zeros
SQL
21 votes173 views4 answers
Add column mssql
SQL
0 vote194 views1 answer
How to know if table in rigt or left in sql
SQL