/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

2 votes315 views4 answers
Create config value file in php
PHP
0 vote317 views1 answer
Encryption key has not encrypted laravel
PHP Laravel
2 votes333 views3 answers
Laravel model particular column
PHP
1 vote316 views1 answer
$posts- links() laravel design error
PHP
0 vote284 views1 answer
Symfony 2.8 create database from entities
PHP
0 vote351 views1 answer
Nested attributes - PHP 8.1
PHP
0 vote305 views1 answer
Validation ignored rules
PHP
0 vote333 views1 answer
Laravel fetch max value
PHP Laravel
7 votes363 views5 answers
Laravel if else condition in blade file
PHP Laravel
7 votes284 views2 answers
Or in regex
PHP