Error when importing

related question: ❓┊helpHow to get ownerRecord inside RecordImporter?

i upload the csv and all the rows fail. not sure what im missing
csv:
name,surname,email,company
eric,mp,em@test.com,Test company

local.ERROR: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'attempts' at row 1 (Connection: mysql, SQL: update `jobs` set `reserved_at` = 1717144796, `attempts` = 256 where `id` = 256) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 22003)

Tables\Actions\ImportAction::make('importContacts')
    ->importer(ContactsImporter::class)
    ->options([
        'ownerRecordId' => $this->getOwnerRecord()->id
    ]),

<?php

namespace App\Filament\Imports;

use App\Models\Contact;
use App\Models\EventContact;
use Filament\Actions\Imports\ImportColumn;
use Filament\Actions\Imports\Importer;
use Filament\Actions\Imports\Models\Import;

class ContactsImporter extends Importer
{
    protected static ?string $model = Contact::class;

    public static function getColumns(): array
    {
        return [
            ImportColumn::make('name')
                ->requiredMapping()
                ->rules(['required', 'max:255']),
            ImportColumn::make('surname')
                ->requiredMapping()
                ->rules(['required', 'max:255']),
            ImportColumn::make('email')
                ->requiredMapping()
                ->rules(['required', 'max:255', 'email']),
            ImportColumn::make('company')
                ->requiredMapping()
                ->rules(['required', 'max:255']),
        ];
    }

    public function resolveRecord(): ?Contact
    {
        $contact = Contact::firstOrNew([
            'email' => $this->data['email'],
        ]);

        EventContact::updateOrCreate([
            'contact_id' => $contact->id,
            'event_id' => $this->options['ownerRecordId'],
        ]);

        return $contact;
    }
}
Was this page helpful?