/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

19 votes166 views4 answers
Php json_decode not working
PHP
1 vote207 views1 answer
Wordpress echo the excerpt
PHP Wordpress
0 vote164 views1 answer
Register sidebar wordpress
PHP
0 vote180 views1 answer
Extension gd missing laravel composer update
PHP Laravel
3 votes165 views2 answers
Function exists
PHP
0 vote133 views1 answer
Ug cranes
PHP
1 vote162 views1 answer
Google client php get inbox messages
PHP
1 vote159 views2 answers
Php keep only letters and numbers
PHP
38 votes158 views6 answers
Laravel foreign key constraint
PHP
3 votes147 views1 answer
Php extensions for laravel
PHP