Exception occur PDOException: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: 'THE DATE' for column 'created_at'

[MDaskalovAtBE]

Firstly - Great Tool! It helps a lot.

Secondly - There is some issues with the generated timestamps in the seeders. When
$ CompaniesBreadTypeAdded.php

\DB::table('data_types')->insert([
  ...
  'created_at' => '2020-04-18T18:58:51.000000Z'
]);

is executed generates Exception occur PDOException: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '2020-04-18T18:44:23.000000Z' for column 'created_at'

temp fix is to just set it to null but be really happy if that gets fixed.

A small suggestion for a good improvement could be using the Voyager's build in DataRow and DataType models rather than the \DB.

[DrudgeRajen]

@MDaskalovAtBE Thanks :)

PR would be great?

[igibek]

I have the same problem. Running php artisan db:seed --class=VoyagerDeploymentOrchestratorSeeder throws PDOException: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '2020-05-22T19:34:39.000000Z' for column 'created_at' at row 1

This is happening in Laravel >= 7 because of json date serialization updated. More here: https://laravel.com/docs/7.x/upgrade#date-serialization