/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

4 votes266 views1 answer
Aravel 8 how to order by using eloquent orm
PHP
-4 votes283 views3 answers
Update wordpress query
PHP Wordpress
3 votes279 views1 answer
Php create temporary file
PHP
1 vote304 views4 answers
Laravel queue timeout
PHP
0 vote253 views1 answer
Php mysql if exists
PHP
0 vote281 views3 answers
Script @php artisan package:discover --ansi handling the post-autoload-dump event returned with error code 1
PHP
0 vote304 views1 answer
Php add element to beginning of associative array
PHP
11 votes298 views4 answers
Get first row of array php
PHP
7 votes297 views3 answers
Php info file
PHP
0 vote255 views1 answer
Drupal 9 entity.repository load entity by UUID
PHP