/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

2 votes194 views1 answer
Oracle index size
SQL
-1 vote190 views1 answer
Su: Authentication failure mysql
SQL
0 vote189 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
6 votes204 views2 answers
Postgresql pg_dump
SQL
0 vote180 views1 answer
Output table plsql
SQL
3 votes188 views2 answers
Laravel tosql with bindings
SQL
0 vote239 views1 answer
Check database restore status sql script
SQL
0 vote189 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
1 vote232 views2 answers
Login to mysql
SQL
0 vote190 views1 answer
Mariadb select limit offset
SQL