/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

6 votes258 views6 answers
Search query in laravel
PHP Laravel
2 votes239 views3 answers
Php insert array into mysql
PHP
11 votes272 views4 answers
Laravel 8 password confirmation validation
PHP Laravel
3 votes265 views3 answers
Laravel sort by function'
PHP Laravel
13 votes294 views5 answers
Laravel add item to array
PHP Laravel
12 votes227 views3 answers
Get array first element key php
PHP
3 votes272 views3 answers
Laravel sort by function'
PHP
0 vote291 views1 answer
Wordpress 404 page after migration
PHP Wordpress
1 vote277 views1 answer
Limiting requests to controllers in laravel
PHP Laravel
1 vote247 views1 answer
Laravel log path
PHP