/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

6 votes169 views1 answer
Oracle trigger after logon on database
SQL
1 vote193 views2 answers
Logical operators in sql
SQL
4 votes187 views1 answer
SQL find text in SP
SQL
0 vote199 views1 answer
Pgadmin check database
SQL
1 vote315 views1 answer
Postgres set column based on another column
SQL
8 votes241 views2 answers
Python simple connect to mysql
SQL
0 vote177 views2 answers
Csv into data postgres
SQL
1 vote199 views1 answer
Postgresql not in
SQL
1 vote168 views1 answer
Mysqli connect
SQL
0 vote188 views2 answers
Identity column in sql server
SQL