/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

1 vote210 views1 answer
Postgresql reset serial counter after deleting content
SQL
0 vote211 views1 answer
Create schema sql server
SQL
0 vote200 views1 answer
Call function in query sql server
SQL
1 vote185 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote225 views1 answer
DATEDIFF minute postgres
SQL
0 vote203 views1 answer
Permission denied postgres \copy csv command line
SQL
1 vote207 views1 answer
Sql insert for each distinct value
SQL
0 vote206 views1 answer
Test the postgresql db connection
SQL
0 vote219 views1 answer
Postgresql delete limit
SQL
5 votes206 views1 answer
How to use rank function in sql
SQL