/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

5 votes226 views2 answers
Laravel 8 routes namespace
PHP Laravel
0 vote201 views1 answer
Eager loading in hasmany belongsto relationship
PHP
1 vote189 views1 answer
Calculate person age by birthdate php
PHP
3 votes199 views1 answer
Wordpress wp_head
PHP
2 votes215 views2 answers
Check if date between two dates laravel
PHP Laravel
0 vote233 views1 answer
Codeigniter set db prefix
PHP CodeIgniter
3 votes226 views2 answers
Laravel check if query builder is empty
PHP Laravel
11 votes189 views4 answers
Number format php
PHP
6 votes199 views2 answers
Laravel migration make column nullable
PHP
5 votes260 views6 answers
Laravel sort collection
PHP