/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

30 votes389 views3 answers
Php code to display current date and time in different formats
PHP
0 vote339 views1 answer
Change arabic number to english php
PHP
2 votes366 views4 answers
Laravel storage get file path
PHP
21 votes354 views3 answers
Php array remove keys keep values
PHP
1 vote351 views1 answer
Calling itself a static function in php
PHP
0 vote346 views1 answer
Laravel in array blade
PHP
7 votes310 views3 answers
Wordpress get date of post
PHP
4 votes342 views3 answers
Class "Controller" not found
PHP
8 votes368 views3 answers
Magento 2.4.3 how to log
PHP
1 vote338 views1 answer
Create controller codeigniter 3
PHP