Issue and adding to the doc: Field team_id doesn't have a default value

[juleindev]

Could you add this to your documentation for the tenant section?

Forms\Components\Select::make('roles')
            ->relationship(name: 'roles', titleAttribute: 'name')
            ->saveRelationshipsUsing(function (Model $record, $state) {
                 $record->roles()->syncWithPivotValues($state, [config('permission.column_names.team_foreign_key') => getPermissionsTeamId()]);
            })
           ->multiple()
           ->preload()
           ->searchable(),

[CodeTechNL]

@juleindev which file is this? Running in this problem now

[juleindev]

@CodeTechNL

In the Form of your UserResource file for example

[CodeTechNL]

@juleindev I also get it on the roles resource page. Did you found a fix for that?

[juleindev]

@CodeTechNL

I didn't had any issue with the package in the Role resource, if you were follow the Tenant Section of the documentation.
I think there is a missing relationship in one of yours models at first sight.

Can you put a screenshot of the error message?

[CodeTechNL]

Its exactly the same as yours but I’m using restaurant_id instead of company_id 

[Edsardio]

@CodeTechNL did you ever solve the issue?

[irvingviveros]

@Edsardio I am also facing this issue, but I think is related to this other issue (which the user resolved adding Filament::getTenant()->id as a parameter value)

#139

[Edsardio]

@irvingviveros Hmm, I've got the issue when attaching a user to the role, which happens automatically on creating a role.. Basically making the package unusable

[tharindarodrigo]

The Filament::getTenant()->id issue has been fixed

[irvingviveros]

@irvingviveros Hmm, I've got the issue when attaching a user to the role, which happens automatically on creating a role.. Basically making the package unusable

Ok now I am facing the same issue.

I can attach a role when I am creating a user, but when I try to attach a Role to the User Resource with RolesRelationManager, I got the same error (1364 Field 'team_id' doesn't have a default value)

class RolesRelationManager extends RelationManager
{
    protected static string $relationship = 'roles';

    public function form(Form $form): Form
    {
        return $form
            ->schema([
                Forms\Components\TextInput::make('name')
                    ->required()
                    ->maxLength(255)
            ]);
    }

    public function table(Table $table): Table
    {
        return $table
            ->recordTitleAttribute('name')
            ->columns([
                Tables\Columns\TextColumn::make('name'),
            ])
            ->filters([
                //
            ])
            ->headerActions([
                Tables\Actions\AttachAction::make()
                    ->preloadRecordSelect()
            ])
            ->actions([
                Tables\Actions\DetachAction::make(),
                Tables\Actions\DeleteAction::make(),
            ])
            ->bulkActions([
                Tables\Actions\BulkActionGroup::make([
                    Tables\Actions\DetachBulkAction::make(),
                    Tables\Actions\DeleteBulkAction::make(),
                ]),
            ]);
    }
}

I've been researching this error for several days but I can't find the answer. It also happens with the RoleResource and the UserRelationManager generated by the package, I cannot attach users to the role on the edit page because the same problem occurs.

I have already tried installing the plugin twice in a clean installation but I can't get it to run correctly. Perhaps more information is needed on this or it is a bit ambiguous. I appreciate the efforts the team behind the plugin put into maintaining it.

[Cedric331]

@irvingviveros

You must create an extend the Spatie Role model and override by adding "withPivotValue":

`namespace App\Models;

use Filament\Facades\Filament;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Relations\BelongsToMany;
use Spatie\Permission\Models\Role as RoleSpatie;
use Spatie\Permission\PermissionRegistrar;

class Role extends RoleSpatie
{
use HasFactory;

public function users(): BelongsToMany
{
    return $this->morphedByMany(
        getModelForGuard($this->attributes['guard_name'] ?? config('auth.defaults.guard')),
        'model',
        config('permission.table_names.model_has_roles'),
        app(PermissionRegistrar::class)->pivotRole,
        config('permission.column_names.model_morph_key')
    )->withPivotValue('shop_id', Filament::getTenant()->id);
}`