Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

> haddad_zineddine's avatar

Export excel file laravel

hello ,

when i try to import excel file using this way Excel::import(new ModelImport, $path); it works fine , but sometimes this operation take a lot of time , so i used queue job for that , but i got error ( sql integrity ... 'admin_id' cannot be null even if it's nullable in the database ), i can't understand the problem here , any idea ?

0 likes
9 replies
bugsysha's avatar

Post the error message you are getting. This doesn't provide enough info. It's like saying guess my shoe size.

> haddad_zineddine's avatar

@bugsysha here is the exception : PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'admin_id' cannot be null in /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Connection.php:464 Stack trace: #0 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Connection.php(464): PDOStatement->execute() #1 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}() #2 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback() #3 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Connection.php(465): Illuminate\Database\Connection->run() #4 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Connection.php(417): Illuminate\Database\Connection->statement() #5 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert() #6 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2839): Illuminate\Database\Query\Processors\Processor->processInsertGetId() #7 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1422): Illuminate\Database\Query\Builder->insertGetId() #8 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(902): Illuminate\Database\Eloquent\Builder->__call() #9 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(867): Illuminate\Database\Eloquent\Model->insertAndSetId() #10 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(730): Illuminate\Database\Eloquent\Model->performInsert() #11 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(776): Illuminate\Database\Eloquent\Model->save() #12 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Support/helpers.php(433): Illuminate\Database\Eloquent\Builder->Illuminate\Database\Eloquent{closure}() #13 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(777): tap() #14 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\Database\Eloquent\Builder->create() #15 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1736): Illuminate\Database\Eloquent\Model->forwardCallTo() #16 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1748): Illuminate\Database\Eloquent\Model->__call() #17 /var/www/html/ecs-console/app/Models/ModelPrice.php(62): Illuminate\Database\Eloquent\Model::__callStatic() #18 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(381): App\Models\ModelPrice::App\Models{closure}() #19 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(226): Illuminate\Events\Dispatcher->Illuminate\Events{closure}() #20 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasEvents.php(189): Illuminate\Events\Dispatcher->dispatch() #21 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(812): Illuminate\Database\Eloquent\Model->fireModelEvent() #22 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(723): Illuminate\Database\Eloquent\Model->performUpdate() #23 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(463): Illuminate\Database\Eloquent\Model->save() #24 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Support/helpers.php(433): Illuminate\Database\Eloquent\Builder->Illuminate\Database\Eloquent{closure}() #25 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(464): tap() #26 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\Database\Eloquent\Builder->updateOrCreate() #27 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1736): Illuminate\Database\Eloquent\Model->forwardCallTo() #28 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1748): Illuminate\Database\Eloquent\Model->__call() #29 /var/www/html/ecs-console/app/Imports/ModelImport.php(54): Illuminate\Database\Eloquent\Model::__callStatic() #30 /var/www/html/ecs-console/vendor/maatwebsite/excel/src/Imports/ModelManager.php(92): App\Imports\ModelImport->model() #31 /var/www/html/ecs-console/vendor/maatwebsite/excel/src/Imports/ModelManager.php(144): Maatwebsite\Excel\Imports\ModelManager->toModels() #32 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Support/Traits/EnumeratesValues.php(202): Maatwebsite\Excel\Imports\ModelManager->Maatwebsite\Excel\Imports{closure}() #33 /var/www/html/ecs-console/vendor/maatwebsite/excel/src/Imports/ModelManager.php(163): Illuminate\Support\Collection->each() #34 /var/www/html/ecs-console/vendor/maatwebsite/excel/src/Imports/ModelManager.php(73): Maatwebsite\Excel\Imports\ModelManager->singleFlush() #35 /var/www/html/ecs-console/vendor/maatwebsite/excel/src/Imports/ModelImporter.php(81): Maatwebsite\Excel\Imports\ModelManager->flush() #36 /var/www/html/ecs-console/vendor/maatwebsite/excel/src/Sheet.php(264): Maatwebsite\Excel\Imports\ModelImporter->import() #37 /var/www/html/ecs-console/vendor/maatwebsite/excel/src/Jobs/ReadChunk.php(169): Maatwebsite\Excel\Sheet->import() #38 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(28): Maatwebsite\Excel\Jobs\ReadChunk->Maatwebsite\Excel\Jobs{closure}() #39 /var/www/html/ecs-console/vendor/maatwebsite/excel/src/Transactions/DbTransactionHandler.php(30): Illuminate\Database\Connection->transaction() #40 /var/www/html/ecs-console/vendor/maatwebsite/excel/src/Jobs/ReadChunk.php(175): Maatwebsite\Excel\Transactions\DbTransactionHandler->__invoke() #41 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Maatwebsite\Excel\Jobs\ReadChunk->handle() #42 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Container/Util.php(37): Illuminate\Container\BoundMethod::Illuminate\Container{closure}() #43 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure() #44 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod() #45 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Container/Container.php(596): Illuminate\Container\BoundMethod::call() #46 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(94): Illuminate\Container\Container->call() #47 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\Bus\Dispatcher->Illuminate\Bus{closure}() #48 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() #49 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(98): Illuminate\Pipeline\Pipeline->then() #50 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(83): Illuminate\Bus\Dispatcher->dispatchNow() #51 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue{closure}() #52 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() #53 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(85): Illuminate\Pipeline\Pipeline->then() #54 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(59): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware() #55 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call() #56 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(356): Illuminate\Queue\Jobs\Job->fire() #57 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(306): Illuminate\Queue\Worker->process() #58 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(132): Illuminate\Queue\Worker->runJob() #59 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(112): Illuminate\Queue\Worker->daemon() #60 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(96): Illuminate\Queue\Console\WorkCommand->runWorker() #61 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle() #62 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Container/Util.php(37): Illuminate\Container\BoundMethod::Illuminate\Container{closure}() #63 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure() #64 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod() #65 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Container/Container.php(596): Illuminate\Container\BoundMethod::call() #66 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Console/Command.php(134): Illuminate\Container\Container->call() #67 /var/www/html/ecs-console/vendor/symfony/console/Command/Command.php(299): Illuminate\Console\Command->execute() #68 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\Component\Console\Command\Command->run() #69 /var/www/html/ecs-console/vendor/symfony/console/Application.php(978): Illuminate\Console\Command->run() #70 /var/www/html/ecs-console/vendor/symfony/console/Application.php(295): Symfony\Component\Console\Application->doRunCommand() #71 /var/www/html/ecs-console/vendor/symfony/console/Application.php(167): Symfony\Component\Console\Application->doRun() #72 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\Component\Console\Application->run() #73 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\Console\Application->run() #74 /var/www/html/ecs-console/artisan(37): Illuminate\Foundation\Console\Kernel->handle() #75 {main}

Next Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'admin_id' cannot be null (SQL: insert into vcs_log (vcs_data, vcs_action, vcs_table, admin_id, updated_at, created_at) values ([{"id":1,"admin_id":1,"model_id":1,"user_type_id":1,"price":0,"price_promotional":0,"deleted_at":null,"created_at":"2021-10-09T17:40:30.000000Z","updated_at":"2021-10-09T17:40:30.000000Z"},{"id":1,"admin_id":null,"model_id":1,"user_type_id":1,"price":10,"price_promotional":0,"deleted_at":null,"created_at":"2021-10-09T17:40:30.000000Z","updated_at":"2021-10-09T17:42:15.000000Z"}], Update, vc_model_price, ?, 2021-10-09 18:42:15, 2021-10-09 18:42:15)) in /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671 Stack trace: #0 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback() #1 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Connection.php(465): Illuminate\Database\Connection->run() #2 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Connection.php(417): Illuminate\Database\Connection->statement() #3 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert() #4 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2839): Illuminate\Database\Query\Processors\Processor->processInsertGetId() #5 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1422): Illuminate\Database\Query\Builder->insertGetId() #6 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(902): Illuminate\Database\Eloquent\Builder->__call() #7 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(867): Illuminate\Database\Eloquent\Model->insertAndSetId() #8 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(730): Illuminate\Database\Eloquent\Model->performInsert() #9 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(776): Illuminate\Database\Eloquent\Model->save() #10 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Support/helpers.php(433): Illuminate\Database\Eloquent\Builder->Illuminate\Database\Eloquent{closure}() #11 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(777): tap() #12 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\Database\Eloquent\Builder->create() #13 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1736): Illuminate\Database\Eloquent\Model->forwardCallTo() #14 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1748): Illuminate\Database\Eloquent\Model->__call() #15 /var/www/html/ecs-console/app/Models/ModelPrice.php(62): Illuminate\Database\Eloquent\Model::__callStatic() #16 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(381): App\Models\ModelPrice::App\Models{closure}() #17 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(226): Illuminate\Events\Dispatcher->Illuminate\Events{closure}() #18 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasEvents.php(189): Illuminate\Events\Dispatcher->dispatch() #19 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(812): Illuminate\Database\Eloquent\Model->fireModelEvent() #20 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(723): Illuminate\Database\Eloquent\Model->performUpdate() #21 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(463): Illuminate\Database\Eloquent\Model->save() #22 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Support/helpers.php(433): Illuminate\Database\Eloquent\Builder->Illuminate\Database\Eloquent{closure}() #23 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(464): tap() #24 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\Database\Eloquent\Builder->updateOrCreate() #25 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1736): Illuminate\Database\Eloquent\Model->forwardCallTo() #26 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1748): Illuminate\Database\Eloquent\Model->__call() #27 /var/www/html/ecs-console/app/Imports/ModelImport.php(54): Illuminate\Database\Eloquent\Model::__callStatic() #28 /var/www/html/ecs-console/vendor/maatwebsite/excel/src/Imports/ModelManager.php(92): App\Imports\ModelImport->model() #29 /var/www/html/ecs-console/vendor/maatwebsite/excel/src/Imports/ModelManager.php(144): Maatwebsite\Excel\Imports\ModelManager->toModels() #30 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Support/Traits/EnumeratesValues.php(202): Maatwebsite\Excel\Imports\ModelManager->Maatwebsite\Excel\Imports{closure}() #31 /var/www/html/ecs-console/vendor/maatwebsite/excel/src/Imports/ModelManager.php(163): Illuminate\Support\Collection->each() #32 /var/www/html/ecs-console/vendor/maatwebsite/excel/src/Imports/ModelManager.php(73): Maatwebsite\Excel\Imports\ModelManager->singleFlush() #33 /var/www/html/ecs-console/vendor/maatwebsite/excel/src/Imports/ModelImporter.php(81): Maatwebsite\Excel\Imports\ModelManager->flush() #34 /var/www/html/ecs-console/vendor/maatwebsite/excel/src/Sheet.php(264): Maatwebsite\Excel\Imports\ModelImporter->import() #35 /var/www/html/ecs-console/vendor/maatwebsite/excel/src/Jobs/ReadChunk.php(169): Maatwebsite\Excel\Sheet->import() #36 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(28): Maatwebsite\Excel\Jobs\ReadChunk->Maatwebsite\Excel\Jobs{closure}() #37 /var/www/html/ecs-console/vendor/maatwebsite/excel/src/Transactions/DbTransactionHandler.php(30): Illuminate\Database\Connection->transaction() #38 /var/www/html/ecs-console/vendor/maatwebsite/excel/src/Jobs/ReadChunk.php(175): Maatwebsite\Excel\Transactions\DbTransactionHandler->__invoke() #39 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Maatwebsite\Excel\Jobs\ReadChunk->handle() #40 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Container/Util.php(37): Illuminate\Container\BoundMethod::Illuminate\Container{closure}() #41 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure() #42 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod() #43 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Container/Container.php(596): Illuminate\Container\BoundMethod::call() #44 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(94): Illuminate\Container\Container->call() #45 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\Bus\Dispatcher->Illuminate\Bus{closure}() #46 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() #47 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(98): Illuminate\Pipeline\Pipeline->then() #48 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(83): Illuminate\Bus\Dispatcher->dispatchNow() #49 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue{closure}() #50 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() #51 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(85): Illuminate\Pipeline\Pipeline->then() #52 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(59): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware() #53 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call() #54 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(356): Illuminate\Queue\Jobs\Job->fire() #55 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(306): Illuminate\Queue\Worker->process() #56 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(132): Illuminate\Queue\Worker->runJob() #57 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(112): Illuminate\Queue\Worker->daemon() #58 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(96): Illuminate\Queue\Console\WorkCommand->runWorker() #59 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle() #60 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Container/Util.php(37): Illuminate\Container\BoundMethod::Illuminate\Container{closure}() #61 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure() #62 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod() #63 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Container/Container.php(596): Illuminate\Container\BoundMethod::call() #64 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Console/Command.php(134): Illuminate\Container\Container->call() #65 /var/www/html/ecs-console/vendor/symfony/console/Command/Command.php(299): Illuminate\Console\Command->execute() #66 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\Component\Console\Command\Command->run() #67 /var/www/html/ecs-console/vendor/symfony/console/Application.php(978): Illuminate\Console\Command->run() #68 /var/www/html/ecs-console/vendor/symfony/console/Application.php(295): Symfony\Component\Console\Application->doRunCommand() #69 /var/www/html/ecs-console/vendor/symfony/console/Application.php(167): Symfony\Component\Console\Application->doRun() #70 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\Component\Console\Application->run() #71 /var/www/html/ecs-console/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\Console\Application->run() #72 /var/www/html/ecs-console/artisan(37): Illuminate\Foundation\Console\Kernel->handle() #73 {main}

> haddad_zineddine's avatar

and i'm 1000% sure that all admin_id columns are nullable , also without queue systeme it works fine, and the thing that i don't understand is why in the local it works well but in the server no ! any idea ?

bugsysha's avatar

No idea. Post pictures or what you can provide that admin_id is nullable.

bugsysha's avatar

@> Joe correct. You can't use it because there is no request and authenticated user.

Snapey's avatar

@> Joe because your database schema are different. Make sure you always rely on migrations to ensure consistency

bugsysha's avatar

@> Joe because you are probably missing something on the production but you've done it in the local environment.

Please or to participate in this conversation.