Nosean
6 months ago

production.ERROR: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'attempts' at row 1

Posted 6 months ago by Nosean

Hi Guys,

I have a problem with executing jobs (mail job) but only in productive mode. I get the following error message recorded in the log:

production.ERROR: SQLSTATE [22003]: Numeric value out of range: 1264 Out of range value for column 'attempts' at row 1

This error comes only online on the server. Local on my PC (WIN10 / XAMPP / PHP7.2.7) it works fine. All jobs are executed successfully.

My Build File:

 public function build()
    {
        $date = $this->details['date'];
        $yesterday = $this->details['yesterday'];
        $kto = $this->details['kto'];
        $name = $this->details['name'];
        $name2 = $this->details['name2'];
        $adress = $this->details['adress'];
        $zip = $this->details['zip'];
        $city = $this->details['city'];
        $user_email = $this->details['user_email'];



        $data = Array(
            'date' => $this->details['date'],
            'yesterday' => $this->details['yesterday'],
            'kto' => $this->details['kto'],
            'name' => $this->details['name'],
            'city' => $this->details['city']
        );

        $filename = $kto . '.pdf';
        $path = storage_path('pdf\') . $filename;

        if(!file_exists(storage_path('pdf\' . $filename))) {
            $pdf = PDF::loadView('orderform', ['data' => $data])
                ->setPaper('a4', 'landscape')
                ->save($path);
        }

        return $this->subject('Bestellerinnerung')
                    ->from('[email protected]')
                    ->view('admin.sendrememberemail')
                    ->with([
                        'kto' => $kto,
                        'date' => $date,
                        'yesterday' => $yesterday,
                        'name' => $name,
                        'name2' => $name2,
                        'adress' => $adress,
                        'zip' => $zip,
                        'city' => $city,
                        'user_email' => $user_email
                    ])
                ->attach($path,
                    ['as' => $filename,
                        'mime' => 'application/pdf',
                    ]);
    }

My handle File:

    public function handle()
    {
        $email = new SendRememberEmail($this->details);
        Mail::to($this->details['user_email'])->send($email);
    }

Thanks for Help!

Please sign in or create an account to participate in this conversation.