Answers for "SQLSTATE[HY000]: General error: 3780 Referencing column 'country_id' and referenced column 'id' in foreign key constraint 'users_country_id_foreign' are incompatible."

SQL
0

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();
Posted by: Guest on November-30-2020
0

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');
Posted by: Guest on November-28-2020

Code answers related to "SQLSTATE[HY000]: General error: 3780 Referencing column 'country_id' and referenced column 'id' in foreign key constraint 'users_country_id_foreign' are incompatible."

Code answers related to "SQL"

Browse Popular Code Answers by Language