F
Filament•11mo ago
hxnnxs

SQLSTATE[HY000]: General error: 1364 Field 'user_id' doesn't have a default value

Hello everyone I ran into a problem during the implementation of Multi-tenancy, I tried to do everything according to the documentation, but apparently I made a mistake somewhere. RegisterCompany.php : 
<?php
// use ...
class RegisterCompany extends RegisterTenant
{
    public static function getLabel(): string
    {
        return 'Create company';
    }

    /**
     * @throws ContainerExceptionInterface
     * @throws NotFoundExceptionInterface
     */
    public function form(Form $form): Form
    {
        return $form
            ->schema([
                Select::make('type')
                ->options([
                    'General' => 'General',
                    'Simplified' => 'Simplified',
                    'Patent' => 'Patent'
                    ]),
                TextInput::make('name'),
                TextInput::make('short_name'),
            ]);
    }

    protected function handleRegistration(array $data): Company
    {
        $company = Company::create($data);

        $company->members()->attach(auth()->user());

        return $company;
    }
}
<?php
// use ...
class RegisterCompany extends RegisterTenant
{
    public static function getLabel(): string
    {
        return 'Create company';
    }

    /**
     * @throws ContainerExceptionInterface
     * @throws NotFoundExceptionInterface
     */
    public function form(Form $form): Form
    {
        return $form
            ->schema([
                Select::make('type')
                ->options([
                    'General' => 'General',
                    'Simplified' => 'Simplified',
                    'Patent' => 'Patent'
                    ]),
                TextInput::make('name'),
                TextInput::make('short_name'),
            ]);
    }

    protected function handleRegistration(array $data): Company
    {
        $company = Company::create($data);

        $company->members()->attach(auth()->user());

        return $company;
    }
}
Company model : 
  public function members():BelongsToMany
    {
        return $this->belongsToMany(User::class);
    }

    public function Requisite() : HasOne
    {
        return  $this->hasOne(CompanyRequisite::class);
}
  public function members():BelongsToMany
    {
        return $this->belongsToMany(User::class);
    }

    public function Requisite() : HasOne
    {
        return  $this->hasOne(CompanyRequisite::class);
}

User model : 
public function getTenants(Panel $panel): array|\Illuminate\Support\Collection
    {
        return $this->Companies;
    }

    public function Companies(): BelongsToMany
    {
        return $this->belongsToMany(Company::class);
    }

    public function canAccessTenant(Model $tenant): bool
    {
        return $this->companies->contains($tenant);
    }
public function getTenants(Panel $panel): array|\Illuminate\Support\Collection
    {
        return $this->Companies;
    }

    public function Companies(): BelongsToMany
    {
        return $this->belongsToMany(Company::class);
    }

    public function canAccessTenant(Model $tenant): bool
    {
        return $this->companies->contains($tenant);
    }
Solution:
yes `` INSERT INTO companies` (...
Jump to solution
7 Replies
hxnnxs
hxnnxsOP•11mo ago
up
Lara Zeus
Lara Zeus•11mo ago
can you see the error logs and which model casing this error or what table is it? I am guessing you missing a fillable? check members model too
hxnnxs
hxnnxsOP•11mo ago
Logs : 
 [previous exception] [object] (PDOException(code: HY000): SQLSTATE[HY000]: General error: 1364 Field 'user_id' doesn't have a default value at C:\\Users\\crash\\OneDrive\\Рабочий стол\\FinTrack\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:580)
[stacktrace]
 [previous exception] [object] (PDOException(code: HY000): SQLSTATE[HY000]: General error: 1364 Field 'user_id' doesn't have a default value at C:\\Users\\crash\\OneDrive\\Рабочий стол\\FinTrack\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:580)
[stacktrace]
When I create a company, the user_id is not filled in, although everything is written correctly in RegisterCompany: 
<?php
namespace App\Filament\Pages\Tenancy;

use App\Models\Company;
use Filament\Forms\Components\Select;
use Filament\Forms\Components\TextInput;
use Filament\Forms\Form;
use Filament\Pages\Tenancy\RegisterTenant;
use Illuminate\Database\Eloquent\Model;

class RegisterCompany extends RegisterTenant
{
    public static function getLabel(): string
    {
        return 'Create company';
    }
    public function form(Form $form): Form
    {
        return $form
            ->schema([
                TextInput::make('name'),
                TextInput::make('short_name'),
                Select::make('type')
                    ->options([
                        'General' => 'General',
                        'Simplified' => 'Simplified',
                        'Patent' => 'Patent'
                    ])
            ]);
    }

    protected function handleRegistration(array $data): Company
    {

        $company = Company::create($data);

        $company->members()->attach(auth()->user());

        return $company;
    }
}
<?php
namespace App\Filament\Pages\Tenancy;

use App\Models\Company;
use Filament\Forms\Components\Select;
use Filament\Forms\Components\TextInput;
use Filament\Forms\Form;
use Filament\Pages\Tenancy\RegisterTenant;
use Illuminate\Database\Eloquent\Model;

class RegisterCompany extends RegisterTenant
{
    public static function getLabel(): string
    {
        return 'Create company';
    }
    public function form(Form $form): Form
    {
        return $form
            ->schema([
                TextInput::make('name'),
                TextInput::make('short_name'),
                Select::make('type')
                    ->options([
                        'General' => 'General',
                        'Simplified' => 'Simplified',
                        'Patent' => 'Patent'
                    ])
            ]);
    }

    protected function handleRegistration(array $data): Company
    {

        $company = Company::create($data);

        $company->members()->attach(auth()->user());

        return $company;
    }
}
I also attach the Company model with the members function : 
 <?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsToMany;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Database\Eloquent\Relations\HasOne;
use Illuminate\Database\Eloquent\SoftDeletes;

class Company extends Model
{
    protected  $fillable = [
        'user_id',
        'name',
        'short_name',
        'type',
    ];
    public function members(): BelongsToMany
    {
        return $this->belongsToMany(User::class);
    }
    use HasFactory, SoftDeletes;
}
 <?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsToMany;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Database\Eloquent\Relations\HasOne;
use Illuminate\Database\Eloquent\SoftDeletes;

class Company extends Model
{
    protected  $fillable = [
        'user_id',
        'name',
        'short_name',
        'type',
    ];
    public function members(): BelongsToMany
    {
        return $this->belongsToMany(User::class);
    }
    use HasFactory, SoftDeletes;
}
Lara Zeus
Lara Zeus•11mo ago
it's not clear from the error what table is it can you expand the error page and see the other trace also make sure you have this where you need them maybe in Company model 
protected  $fillable = [
    'user_id',
];
protected  $fillable = [
    'user_id',
];
hxnnxs
hxnnxsOP•11mo ago
Maybe this will help somehow:
SQLSTATE[HY000]: General error: 1364 Field 'user_id' doesn't have a default value
INSERT INTO
  `companies` (
    `name`,
    `short_name`,
    `type`,
    `updated_at`,
    `created_at`
  )
VALUES
  (
    asdasd,
    asdasd,
    Simplified,
    2024 -01 -17 19: 41: 09,
    2024 -01 -17 19: 41: 09
  )
SQLSTATE[HY000]: General error: 1364 Field 'user_id' doesn't have a default value
INSERT INTO
  `companies` (
    `name`,
    `short_name`,
    `type`,
    `updated_at`,
    `created_at`
  )
VALUES
  (
    asdasd,
    asdasd,
    Simplified,
    2024 -01 -17 19: 41: 09,
    2024 -01 -17 19: 41: 09
  )
Also, because of what I did according to the guide, it is worth specifying the migration of the companies table : 
<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::create('companies', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->string('short_name');
            $table->string('type');
            $table->foreignId('user_id')->constrained()->cascadeOnDelete();
            $table->timestamps();
            $table->softDeletes();
        });
        Schema::create('company_user', function (Blueprint $table) {
            $table->id();
            $table->foreignId('company_id')->constrained();
            $table->foreignId('user_id')->constrained();
            $table->timestamps();

        });
    }

    /**
     * Reverse the migrations.
     */
    public function down(): void
    {
        Schema::dropIfExists('company_user');
        Schema::dropIfExists('companies');
    }
};
<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::create('companies', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->string('short_name');
            $table->string('type');
            $table->foreignId('user_id')->constrained()->cascadeOnDelete();
            $table->timestamps();
            $table->softDeletes();
        });
        Schema::create('company_user', function (Blueprint $table) {
            $table->id();
            $table->foreignId('company_id')->constrained();
            $table->foreignId('user_id')->constrained();
            $table->timestamps();

        });
    }

    /**
     * Reverse the migrations.
     */
    public function down(): void
    {
        Schema::dropIfExists('company_user');
        Schema::dropIfExists('companies');
    }
};
Solution
Lara Zeus
Lara Zeus•11mo ago
yes 
INSERT INTO
  `companies` (
    `name`,
    `short_name`,
    `type`,
    `updated_at`,
    `created_at`
  )
INSERT INTO
  `companies` (
    `name`,
    `short_name`,
    `type`,
    `updated_at`,
    `created_at`
  )
so you have to add user_id to the $data and make sure its fillable in the model company 
$data['user_id'] = auth()->user()->id
$company = Company::create($data);
$data['user_id'] = auth()->user()->id
$company = Company::create($data);
hxnnxs
hxnnxsOP•11mo ago
I'm shocked! I just don't have the words to be honest. The fact is that everything worked fine before migrate:refresh, but after that this error appeared and I tried to fix it for more than 3 hours. Thank you so much for helping such complete beginners in filament like me, you are a pro!❤️
Want results from more Discord servers?
Add your server