/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

29 votes295 views3 answers
Seed date laravel
PHP Laravel
2 votes219 views2 answers
Laravel foreach first
PHP
16 votes289 views6 answers
Php string to date
PHP
1 vote237 views1 answer
How to request user input in php
PHP
2 votes267 views2 answers
Route codeigniter
PHP CodeIgniter
0 vote254 views1 answer
Resubmit on refresh php
PHP
0 vote256 views1 answer
Laravel 8 logout 419 page expired
PHP Laravel
3 votes226 views2 answers
Php read xml from url
PHP
0 vote290 views1 answer
Text or description laravel database column type
PHP Laravel
5 votes229 views4 answers
Laravel auth register false
PHP