/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 vote139 views1 answer
Change role postgres
SQL
0 vote137 views1 answer
Django mssql backend
SQL
0 vote159 views1 answer
Sql basic commands
SQL
0 vote155 views1 answer
On delete set default
SQL
0 vote158 views1 answer
How to check database engine in mysql
SQL
0 vote146 views1 answer
Drop column from local database postgres pgadmin
SQL
2 votes159 views2 answers
Python escape string for sql
SQL
1 vote149 views2 answers
Sql select only row with the max date
SQL
0 vote143 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
2 votes146 views2 answers
Mysql show table column comments sql
SQL