/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

0 vote181 views4 answers
Sweetalert laravel
PHP
15 votes185 views3 answers
Composer
PHP
1 vote248 views1 answer
Autoload file in laravel
PHP Laravel
0 vote175 views1 answer
Eloquent insert into select
PHP
3 votes191 views2 answers
Get the string after a character in php
PHP
7 votes204 views2 answers
Wordpress loop
PHP Wordpress
12 votes244 views5 answers
Shortcode php wordpress
PHP Wordpress
0 vote210 views1 answer
Woocommerce order get_data()
PHP
0 vote176 views1 answer
Java script clear rectangle
PHP
18 votes194 views10 answers
Stackoverflow
PHP