/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 vote185 views1 answer
Sql server set complex constraints
SQL
1 vote175 views1 answer
How to put value in variable mysql
SQL
2 votes166 views1 answer
How to select first row of database sql
SQL
0 vote164 views1 answer
Mysql function variable
SQL
0 vote166 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote165 views1 answer
Update if else mysql
SQL
0 vote246 views1 answer
Sql insert exemplo
SQL
0 vote170 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote176 views1 answer
Top frequency in sql server
SQL
0 vote170 views1 answer
Update using case in mysql
SQL