/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

49 votes224 views6 answers
Laravel when
PHP Laravel
0 vote137 views1 answer
Validate rule if row exist laravel
PHP
-1 vote165 views1 answer
Ziparchive laravel not found
PHP Laravel
7 votes241 views3 answers
Generate shortcode wordpress plugin
PHP Wordpress
-2 votes124 views1 answer
Php boolean
PHP
5 votes139 views6 answers
Php get last date of month
PHP
0 vote150 views1 answer
Laravel, if ->get() array is not emtpy
PHP Laravel
6 votes152 views6 answers
Get url parameters in laravel blade
PHP
4 votes163 views6 answers
Convert DateTime to String in PHP
PHP
1 vote136 views2 answers
How to create a logout button in wordpress
PHP