/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

4 votes116 views2 answers
Datetime blade laravel
PHP Laravel
0 vote93 views1 answer
Laravel add model to polymorphic relationships
PHP
13 votes119 views4 answers
Laravel migration remove column
PHP
0 vote97 views1 answer
Laravel Validate unique column
PHP
3 votes94 views1 answer
Wordpress page template
PHP
2 votes99 views1 answer
Remove phpmyadmin ubuntu 20.04 completely
PHP
3 votes119 views2 answers
Composer install : Your requirements could not be resolved to an installable set of packages
PHP
6 votes93 views3 answers
Laravel $loop->iteration
PHP
14 votes101 views5 answers
Php artisan migrate reset
PHP
15 votes98 views3 answers
Laravel target class does not exist
PHP