FilamentF
Filament•3y ago
Theodoros

Select many to many problem

Hello!
I have the following error in a Select field with many to many relationship.
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sshKeys' in 'field list'
The form contains:
Select::make('sshKeys')
                    ->multiple()
                    ->relationship('sshKeys', 'name')
                    ->required()
                    ->label('SSH Key'),


This is the relationship in the model 
public function sshKeys()
    {
        return $this->belongsToMany(SshKey::class, 'server_ssh_key');
    }

The select field is filled successfully but when I try to save it I get the following error.

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sshKeys' in 'field list'
If I do my Select as multiple then everything is working properly.

Any suggestion for the error?
Was this page helpful?