/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 vote210 views1 answer
Eager realationship in laravel
PHP
-1 vote215 views2 answers
Laravel updateorcreate multiple records
PHP
7 votes222 views6 answers
Get current route laravel
PHP
6 votes204 views4 answers
Laravel force delete
PHP Laravel
0 vote192 views1 answer
Laravel session wont update
PHP Laravel
2 votes221 views1 answer
The $cfg['TempDir'] (/usr/share/phpmyadmin/tmp/) is not accessible. phpMyAdmin is not able to cache templates and will be slow because of this.
PHP
0 vote169 views1 answer
Laravel collection transform
PHP
21 votes244 views2 answers
Long text in laravel migration
PHP Laravel
0 vote214 views1 answer
Single row data from table in laravel
PHP
7 votes225 views3 answers
Call table name in model laravel
PHP Laravel