F
Filament•10mo ago
RMH

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

I have a StudentResource and in form I am doing this: 
Forms\Components\Select::make('guardian_id')
    ->relationship('guardian', 'family_name')
    ->label('Family')
    ->searchable()
    ->preload()
    ->required(),
Forms\Components\Select::make('guardian_id')
    ->relationship('guardian', 'family_name')
    ->label('Family')
    ->searchable()
    ->preload()
    ->required(),
But while creating a new student I am getting this error SQLSTATE[HY000]: General error: 1364 Field 'guardian_id' doesn't have a default value
3 Replies
waleedGRT
waleedGRT•10mo ago
Can you show a migration file?
cheesegrits
cheesegrits•10mo ago
Make sure it's $fillable in the model.
RMH
RMH•10mo ago
Sure the student migration file is: 
        Schema::create('students', function (Blueprint $table) {
            $table->id();
            $table->foreignId('guardian_id')
                ->constrained()
                ->restrictOnDelete();
            $table->string('reg_no')->unique();
            $table->string('first_name');
            $table->string('last_name')->nullable();
            // Other columns
        });
        Schema::create('students', function (Blueprint $table) {
            $table->id();
            $table->foreignId('guardian_id')
                ->constrained()
                ->restrictOnDelete();
            $table->string('reg_no')->unique();
            $table->string('first_name');
            $table->string('last_name')->nullable();
            // Other columns
        });
yeah... missed that... thanks
Want results from more Discord servers?
Add your server
More Posts
Getting error on custom list view..$resource must not be accessed before initializationI am getting this on a custom list page nothing on it yet just the table. ```Typed static property FHow to use defaultSort as orderByRaw?Hi, just want to ask how to achieve a defaultSort with a certain `status` like `invited, active, revCheckbox List DefaultCheckboxlist default() does not work in EditRecord. How to resolve it?resourceHelloo I’m newbie I have this problem that when I created a resource, example the UserResource I’m gRows not showing in list view after modifying queryI have a weird problem. I added a scope to my Galaxy model that is applied for the list view. That Default Active Tab Not Working for Tab FilterIn my List page I have a Tabs filter for each day of the week. But when I try to set the default actcall livewire component from view::make()Is it possible to call a livewire componet from wizard view component. Something like: Forms\ComponeCan we use collection or array in table query?I am creating a custom table in Filament, and I want to use a collection of data in the table. HowevFacing difficulties integrating maps in my panelHello everyone, I'm new to laravel in general, I'm using the filament-maps package to integrate leaRadio componentsHello, Is there any way to pass html values to the radio descriptions?