/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

3 votes90 views2 answers
Laravel eloquent search query 2020
PHP
0 vote116 views1 answer
Php fetch mysql result as variable
PHP
0 vote122 views1 answer
Last login date time in wordpress
PHP Wordpress
3 votes109 views1 answer
Laravel eloquent increment
PHP Laravel
0 vote99 views1 answer
Php registration form and login in same page
PHP
0 vote97 views1 answer
Laravel command Retrieve a specific option
PHP
0 vote99 views2 answers
Determine the percentage of the file uploaded to the server using php
PHP
0 vote101 views1 answer
Php header author
PHP
0 vote110 views1 answer
Convert time to 24 hour format laravel
PHP
0 vote97 views2 answers
Date 3 months ago for a particular date php
PHP