/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

7 votes281 views4 answers
Database dump mysql command
SQL
0 vote295 views1 answer
SQL Server Enterprise
SQL
0 vote258 views1 answer
Mysql sleep connections
SQL
1 vote274 views2 answers
Mysql order by date asc null last
SQL
2 votes289 views1 answer
Columns Present in a table
SQL
0 vote301 views1 answer
Name '_mysql' is not defined
SQL
0 vote326 views1 answer
Dynamic where clause in sql server stored procedure
SQL
0 vote289 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote284 views1 answer
This week mysql
SQL
0 vote330 views1 answer
Sparql list all graphs
SQL