[2026-09-09 17:00:55] production.ERROR: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'cpl' at row 1 (Connection: mysql, Host: vergnethlog.mysql.db, Port: 3306, Database: vergnethlog, SQL: insert into `pays` (`nom`, `code_region`, `cpl`, `cp`, `updated_at`, `created_at`) values (Mali, NBE, N'Fakaba DIAWARA, Aymen, 2026-09-09 17:00:55, 2026-09-09 17:00:55)) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 22001): SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'cpl' at row 1 (Connection: mysql, Host: vergnethlog.mysql.db, Port: 3306, Database: vergnethlog, SQL: insert into `pays` (`nom`, `code_region`, `cpl`, `cp`, `updated_at`, `created_at`) values (Mali, NBE, N'Fakaba DIAWARA, Aymen, 2026-09-09 17:00:55, 2026-09-09 17:00:55)) at /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Connection.php:838) [stacktrace] #0 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Connection.php(794): Illuminate\\Database\\Connection->runQueryCallback('insert into `pa...', Array, Object(Closure)) #1 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php(42): Illuminate\\Database\\Connection->run('insert into `pa...', Array, Object(Closure)) #2 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/MySqlProcessor.php(35): Illuminate\\Database\\MySqlConnection->insert('insert into `pa...', Array, 'id') #3 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(4170): Illuminate\\Database\\Query\\Processors\\MySqlProcessor->processInsertGetId(Object(Illuminate\\Database\\Query\\Builder), 'insert into `pa...', Array, 'id') #4 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(2237): Illuminate\\Database\\Query\\Builder->insertGetId(Array, 'id') #5 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1436): Illuminate\\Database\\Eloquent\\Builder->__call('insertGetId', Array) #6 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1401): Illuminate\\Database\\Eloquent\\Model->insertAndSetId(Object(Illuminate\\Database\\Eloquent\\Builder), Array) #7 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1240): Illuminate\\Database\\Eloquent\\Model->performInsert(Object(Illuminate\\Database\\Eloquent\\Builder)) #8 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1219): Illuminate\\Database\\Eloquent\\Model->save() #9 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Support/helpers.php(393): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}(Object(App\\Models\\Pays)) #10 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1218): tap(Object(App\\Models\\Pays), Object(Closure)) #11 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(725): Illuminate\\Database\\Eloquent\\Builder->create(Array) #12 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(35): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}(Object(Illuminate\\Database\\MySqlConnection)) #13 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1960): Illuminate\\Database\\Connection->transaction(Object(Closure)) #14 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(725): Illuminate\\Database\\Eloquent\\Builder->withSavepointIfNeeded(Object(Closure)) #15 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(712): Illuminate\\Database\\Eloquent\\Builder->createOrFirst(Array, Array) #16 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\\Database\\Eloquent\\Builder->firstOrCreate(Array, Array) #17 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2544): Illuminate\\Database\\Eloquent\\Model->forwardCallTo(Object(Illuminate\\Database\\Eloquent\\Builder), 'firstOrCreate', Array) #18 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2560): Illuminate\\Database\\Eloquent\\Model->__call('firstOrCreate', Array) #19 /home/vergneth-log/logistique/app-transport/app/Console/Commands/ImportAccessData.php(97): Illuminate\\Database\\Eloquent\\Model::__callStatic('firstOrCreate', Array) #20 /home/vergneth-log/logistique/app-transport/app/Console/Commands/ImportAccessData.php(51): App\\Console\\Commands\\ImportAccessData->importPays('/home/vergneth-...') #21 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(35): App\\Console\\Commands\\ImportAccessData->App\\Console\\Commands\\{closure}(Object(Illuminate\\Database\\MySqlConnection)) #22 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(491): Illuminate\\Database\\Connection->transaction(Object(Closure)) #23 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(363): Illuminate\\Database\\DatabaseManager->__call('transaction', Array) #24 /home/vergneth-log/logistique/app-transport/app/Console/Commands/ImportAccessData.php(46): Illuminate\\Support\\Facades\\Facade::__callStatic('transaction', Array) #25 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Console\\Commands\\ImportAccessData->handle() #26 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #27 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #28 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure)) #29 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Container/Container.php(799): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL) #30 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\\Container\\Container->call(Array) #31 /home/vergneth-log/logistique/app-transport/vendor/symfony/console/Command/Command.php(341): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle)) #32 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle)) #33 /home/vergneth-log/logistique/app-transport/vendor/symfony/console/Application.php(1117): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #34 /home/vergneth-log/logistique/app-transport/vendor/symfony/console/Application.php(356): Symfony\\Component\\Console\\Application->doRunCommand(Object(App\\Console\\Commands\\ImportAccessData), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #35 /home/vergneth-log/logistique/app-transport/vendor/symfony/console/Application.php(195): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #36 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #37 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1235): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #38 /home/vergneth-log/logistique/app-transport/artisan(16): Illuminate\\Foundation\\Application->handleCommand(Object(Symfony\\Component\\Console\\Input\\ArgvInput)) #39 {main} [previous exception] [object] (PDOException(code: 22001): SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'cpl' at row 1 at /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php:53) [stacktrace] #0 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php(53): PDOStatement->execute() #1 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Connection.php(827): Illuminate\\Database\\MySqlConnection->Illuminate\\Database\\{closure}('insert into `pa...', Array) #2 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Connection.php(794): Illuminate\\Database\\Connection->runQueryCallback('insert into `pa...', Array, Object(Closure)) #3 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php(42): Illuminate\\Database\\Connection->run('insert into `pa...', Array, Object(Closure)) #4 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/MySqlProcessor.php(35): Illuminate\\Database\\MySqlConnection->insert('insert into `pa...', Array, 'id') #5 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(4170): Illuminate\\Database\\Query\\Processors\\MySqlProcessor->processInsertGetId(Object(Illuminate\\Database\\Query\\Builder), 'insert into `pa...', Array, 'id') #6 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(2237): Illuminate\\Database\\Query\\Builder->insertGetId(Array, 'id') #7 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1436): Illuminate\\Database\\Eloquent\\Builder->__call('insertGetId', Array) #8 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1401): Illuminate\\Database\\Eloquent\\Model->insertAndSetId(Object(Illuminate\\Database\\Eloquent\\Builder), Array) #9 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1240): Illuminate\\Database\\Eloquent\\Model->performInsert(Object(Illuminate\\Database\\Eloquent\\Builder)) #10 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1219): Illuminate\\Database\\Eloquent\\Model->save() #11 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Support/helpers.php(393): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}(Object(App\\Models\\Pays)) #12 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1218): tap(Object(App\\Models\\Pays), Object(Closure)) #13 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(725): Illuminate\\Database\\Eloquent\\Builder->create(Array) #14 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(35): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}(Object(Illuminate\\Database\\MySqlConnection)) #15 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1960): Illuminate\\Database\\Connection->transaction(Object(Closure)) #16 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(725): Illuminate\\Database\\Eloquent\\Builder->withSavepointIfNeeded(Object(Closure)) #17 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(712): Illuminate\\Database\\Eloquent\\Builder->createOrFirst(Array, Array) #18 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\\Database\\Eloquent\\Builder->firstOrCreate(Array, Array) #19 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2544): Illuminate\\Database\\Eloquent\\Model->forwardCallTo(Object(Illuminate\\Database\\Eloquent\\Builder), 'firstOrCreate', Array) #20 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2560): Illuminate\\Database\\Eloquent\\Model->__call('firstOrCreate', Array) #21 /home/vergneth-log/logistique/app-transport/app/Console/Commands/ImportAccessData.php(97): Illuminate\\Database\\Eloquent\\Model::__callStatic('firstOrCreate', Array) #22 /home/vergneth-log/logistique/app-transport/app/Console/Commands/ImportAccessData.php(51): App\\Console\\Commands\\ImportAccessData->importPays('/home/vergneth-...') #23 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(35): App\\Console\\Commands\\ImportAccessData->App\\Console\\Commands\\{closure}(Object(Illuminate\\Database\\MySqlConnection)) #24 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(491): Illuminate\\Database\\Connection->transaction(Object(Closure)) #25 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(363): Illuminate\\Database\\DatabaseManager->__call('transaction', Array) #26 /home/vergneth-log/logistique/app-transport/app/Console/Commands/ImportAccessData.php(46): Illuminate\\Support\\Facades\\Facade::__callStatic('transaction', Array) #27 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Console\\Commands\\ImportAccessData->handle() #28 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #29 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #30 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure)) #31 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Container/Container.php(799): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL) #32 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\\Container\\Container->call(Array) #33 /home/vergneth-log/logistique/app-transport/vendor/symfony/console/Command/Command.php(341): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle)) #34 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle)) #35 /home/vergneth-log/logistique/app-transport/vendor/symfony/console/Application.php(1117): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #36 /home/vergneth-log/logistique/app-transport/vendor/symfony/console/Application.php(356): Symfony\\Component\\Console\\Application->doRunCommand(Object(App\\Console\\Commands\\ImportAccessData), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #37 /home/vergneth-log/logistique/app-transport/vendor/symfony/console/Application.php(195): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #38 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #39 /home/vergneth-log/logistique/app-transport/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1235): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #40 /home/vergneth-log/logistique/app-transport/artisan(16): Illuminate\\Foundation\\Application->handleCommand(Object(Symfony\\Component\\Console\\Input\\ArgvInput)) #41 {main} "}