/PHP/Syntax error or access violation: 1072 Key column 'user_id' doesn't exist in table (SQL: alter table `groups` add constraint `groups_user_id_foreign` foreign key (`user_id`) references `users` (`id`))

Syntax error or access violation: 1072 Key column 'user_id' doesn't exist in table (SQL: alter table `groups` add constraint `groups_user_id_foreign` foreign key (`user_id`) references `users` (`id`))

// You forgot to create the column before creating the relationship
// Do something like (add unsigned before the relationship):

$table->integer('user_id')->unsigned();
$table->foreign('user_id')->references('id')->on('users');

Similar codes

1 vote136 views1 answer
How to delete all products woocommerce in phpmyadmin
PHP
0 vote170 views1 answer
Laravel access storage attachment
PHP Laravel
2 votes127 views1 answer
Laravel check if session variable exists
PHP
1 vote171 views1 answer
Php connect to postgresql
PHP
14 votes247 views6 answers
Wp enqueue style
PHP Wordpress
1 vote137 views1 answer
Laravel query select from table where id != to another table id
PHP
5 votes192 views1 answer
Wordpress get taxonomy of a post
PHP Wordpress
3 votes132 views1 answer
Php loop through json
PHP
0 vote143 views1 answer
Download laravel 8 zip
PHP
8 votes134 views4 answers
Session unset
PHP