/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 vote252 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
19 votes266 views6 answers
What is mySQL
SQL
1 vote231 views1 answer
Unique vs distinct sql
SQL
0 vote236 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote268 views1 answer
Mysql match in serialized data
SQL
1 vote263 views2 answers
Restart identity cascade
SQL
1 vote303 views1 answer
Sql random sampling per group
SQL
1 vote243 views1 answer
Mysql select utc time in eastern time
SQL
0 vote272 views1 answer
Mysql make date from 2 column
SQL
0 vote247 views1 answer
How to get n result in sql
SQL