/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 vote198 views1 answer
Mariadb mysql root access denied
SQL
0 vote300 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
1 vote312 views1 answer
Adding a check statement in sql
SQL
0 vote215 views1 answer
Query to insert image
SQL
0 vote210 views2 answers
How to list all values of a column that start with a letter in sql
SQL
2 votes218 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote206 views1 answer
Install sql server in ubuntu 20.04
SQL
18 votes179 views3 answers
Mysql query add column with default string value
SQL
4 votes182 views4 answers
What is primary key
SQL
0 vote207 views1 answer
How to find lowest in sql
SQL