Error updating v5.7.62 C145

kcocarmona · January 30, 2024, 8:19pm

When trying to update my self hosted invoice ninja from V5.7.62 to V5.8.11 I get a 500 error message.

Any ideas why this might be and how to fix this to have the latest version?

Thanks

hillel · January 30, 2024, 8:25pm

Hi,

Are there any details about the 500 error in storage/logs?

kcocarmona · January 30, 2024, 8:52pm

In one log im getting:
[30/Jan/2024:04:00:03 +0000] “POST /api/v1/refresh?current_company=true&updated_at=1706585092&first_load=true HTTP/2.0” 200 24007 “https://administracion.mingoagency.com/” “Mozilla/5.0 (X11; CrOS x86_64 14541.0.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36” | TLSv1.3 | 0.348 0.363 0.365 - 0 NC:000000 UP:-DT

Inside the STORAGE/LOGS I have 2 files:

.gitignore
lavarel.log

in the second one the latest logs are:
#65 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(Object(Illuminate\Http\Request), Object(Closure))
#66 /home/customer/www/administracion.mingoagency.com/public_html/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Middleware.php(87): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#67 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Sentry\Laravel\Tracing\Middleware->handle(Object(Illuminate\Http\Request), Object(Closure))
#68 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#69 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#70 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#71 /home/customer/www/administracion.mingoagency.com/public_html/public/index.php(56): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#72 {main}

But I dont think this is what you are looking for. Is it?

hillel · January 30, 2024, 8:54pm

Please post the beginning of the error, what you posted starts at line 65.

kcocarmona · January 30, 2024, 9:07pm

This is everything that is right now inside that file:
(adding 2 replies to have all there)

[2023-12-31 17:00:59] production.INFO: db fails
[2024-01-15 18:40:58] production.ERROR: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1-2024-1549’ for key ‘invoices_company_id_number_unique’ (Connection: mysql, SQL: insert into invoices (status_id, number, discount, is_amount_discount, po_number, footer, terms, public_notes, private_notes, date, due_date, partial_due_date, is_deleted, line_items, tax_name1, tax_rate1, tax_name2, tax_rate2, tax_name3, tax_rate3, custom_value1, custom_value2, custom_value3, custom_value4, amount, balance, paid_to_date, partial, user_id, company_id, recurring_id, exchange_rate, client_id, uses_inclusive_taxes, project_id, vendor_id, subscription_id, design_id, custom_surcharge1, custom_surcharge2, custom_surcharge3, custom_surcharge4, auto_bill_enabled, assigned_user_id, custom_surcharge_tax1, custom_surcharge_tax2, custom_surcharge_tax3, custom_surcharge_tax4, updated_at, created_at) values (1, 2024-1549, 0, 0, ?, ?, El pago asociado a esta factura debe ser cancelado previo a la fecha de vencimiento indicada en el presente documento.

En caso de no ejecutarse el pago dentro del tiempo correspopndiente, el mismo podrá acarrear recargas administrativas reflejadas en el siguiente ciclo de facturación.
En caso de ser contribuyente especial se deben hacer llegar las retenciones correspondientes al correo [email protected]

Sub-Total a la tasa 1,00 US $ por Bs. 36,03
Tasa de Cambio BCV Fecha Valor 01/16/2024

Sub-Total $: 68
Pagado $ 68
I.V.A 16% $ 10,88

Total Factura $ 78,88, ?, ?, 2024-01-16, 2024-01-19, ?, 0, [{“product_key”:“Administraci\u00f3n de redes sociales”,“notes”:“Administraci\u00f3n mensual de redes sociales del cliente”,“cost”:1729.44000000000005456968210637569427490234375,“product_cost”:0,“quantity”:1,“tax_name1”:“”,“tax_rate1”:0,“tax_name2”:“”,“tax_rate2”:0,“tax_name3”:“”,“tax_rate3”:0,“custom_value1”:“”,“custom_value2”:“”,“custom_value3”:“”,“custom_value4”:“”,“discount”:0,“tax_id”:“1”,“type_id”:“1”,“createdAt”:1705343841105000,“is_amount_discount”:false,“sort_id”:“0”,“line_total”:0,“gross_line_total”:0,“tax_amount”:0,“date”:“”,“task_id”:“”,“expense_id”:“”},{“product_key”:“Administraci\u00f3n de redes sociales”,“notes”:“Servicios de Administraci\u00f3n de CRM”,“cost”:720.6000000000000227373675443232059478759765625,“product_cost”:0,“quantity”:1,“tax_name1”:“”,“tax_rate1”:0,“tax_name2”:“”,“tax_rate2”:0,“tax_name3”:“”,“tax_rate3”:0,“custom_value1”:“”,“custom_value2”:“”,“custom_value3”:“”,“custom_value4”:“”,“discount”:0,“tax_id”:“1”,“type_id”:“1”,“createdAt”:1705343878586000,“is_amount_discount”:false,“sort_id”:“0”,“line_total”:0,“gross_line_total”:0,“tax_amount”:0,“date”:“”,“task_id”:“”,“expense_id”:“”}], IVA, 16, ?, 0, ?, 0, ?, ?, ?, ?, 0, 0, 0, 0, 3, 1, ?, 1, 48, 0, ?, ?, ?, ?, 0, 0, 0, 0, 0, ?, 0, 0, 0, 0, 2024-01-15 18:40:58.817359, 2024-01-15 18:40:58.817359)) {“userId”:3,“exception”:"[object] (Illuminate\Database\UniqueConstraintViolationException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1-2024-1549’ for key ‘invoices_company_id_number_unique’ (Connection: mysql, SQL: insert into invoices (status_id, number, discount, is_amount_discount, po_number, footer, terms, public_notes, private_notes, date, due_date, partial_due_date, is_deleted, line_items, tax_name1, tax_rate1, tax_name2, tax_rate2, tax_name3, tax_rate3, custom_value1, custom_value2, custom_value3, custom_value4, amount, balance, paid_to_date, partial, user_id, company_id, recurring_id, exchange_rate, client_id, uses_inclusive_taxes, project_id, vendor_id, subscription_id, design_id, custom_surcharge1, custom_surcharge2, custom_surcharge3, custom_surcharge4, auto_bill_enabled, assigned_user_id, custom_surcharge_tax1, custom_surcharge_tax2, custom_surcharge_tax3, custom_surcharge_tax4, updated_at, created_at) values (1, 2024-1549, 0, 0, ?, ?, El pago asociado a esta factura debe ser cancelado previo a la fecha de vencimiento indicada en el presente documento.

En caso de no ejecutarse el pago dentro del tiempo correspopndiente, el mismo podrá acarrear recargas administrativas reflejadas en el siguiente ciclo de facturación.
En caso de ser contribuyente especial se deben hacer llegar las retenciones correspondientes al correo [email protected]

Sub-Total a la tasa 1,00 US $ por Bs. 36,03
Tasa de Cambio BCV Fecha Valor 01/16/2024

Sub-Total $: 68
Pagado $ 68
I.V.A 16% $ 10,88

Total Factura $ 78,88, ?, ?, 2024-01-16, 2024-01-19, ?, 0, [{"product_key":"Administraci\u00f3n de redes sociales","notes":"Administraci\u00f3n mensual de redes sociales del cliente","cost":1729.44000000000005456968210637569427490234375,"product_cost":0,"quantity":1,"tax_name1":"","tax_rate1":0,"tax_name2":"","tax_rate2":0,"tax_name3":"","tax_rate3":0,"custom_value1":"","custom_value2":"","custom_value3":"","custom_value4":"","discount":0,"tax_id":"1","type_id":"1","createdAt":1705343841105000,"is_amount_discount":false,"sort_id":"0","line_total":0,"gross_line_total":0,"tax_amount":0,"date":"","task_id":"","expense_id":""},{"product_key":"Administraci\u00f3n de redes sociales","notes":"Servicios de Administraci\u00f3n de CRM","cost":720.6000000000000227373675443232059478759765625,"product_cost":0,"quantity":1,"tax_name1":"","tax_rate1":0,"tax_name2":"","tax_rate2":0,"tax_name3":"","tax_rate3":0,"custom_value1":"","custom_value2":"","custom_value3":"","custom_value4":"","discount":0,"tax_id":"1","type_id":"1","createdAt":1705343878586000,"is_amount_discount":false,"sort_id":"0","line_total":0,"gross_line_total":0,"tax_amount":0,"date":"","task_id":"","expense_id":""}], IVA, 16, ?, 0, ?, 0, ?, ?, ?, ?, 0, 0, 0, 0, 3, 1, ?, 1, 48, 0, ?, ?, ?, ?, 0, 0, 0, 0, 0, ?, 0, 0, 0, 0, 2024-01-15 18:40:58.817359, 2024-01-15 18:40:58.817359)) at /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:817)
[stacktrace]
#0 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(776): Illuminate\Database\Connection->runQueryCallback(‘insert into in...', Array, Object(Closure)) #1 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(569): Illuminate\\Database\\Connection->run('insert into in…’, Array, Object(Closure))
#2 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(533): Illuminate\Database\Connection->statement(‘insert into in...', Array) #3 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\\Database\\Connection->insert('insert into in…’, Array)
#4 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3387): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), ‘insert into `in…’, Array, ‘id’)
#5 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1968): Illuminate\Database\Query\Builder->insertGetId(Array, ‘id’)
#6 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1333): Illuminate\Database\Eloquent\Builder->__call(‘insertGetId’, Array)
#7 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1298): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#8 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1137): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#9 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1103): Illuminate\Database\Eloquent\Model->save(Array)
#10 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasEvents.php(408): Illuminate\Database\Eloquent\Model->Illuminate\Database\Eloquent\{closure}()
#11 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1103): Illuminate\Database\Eloquent\Model::withoutEvents(Object(Closure))
#12 /home/customer/www/administracion.mingoagency.com/public_html/app/Repositories/BaseRepository.php(203): Illuminate\Database\Eloquent\Model->saveQuietly()
#13 /home/customer/www/administracion.mingoagency.com/public_html/app/Repositories/InvoiceRepository.php(35): App\Repositories\BaseRepository->alternativeSave(Array, Object(App\Models\Invoice))
#14 /home/customer/www/administracion.mingoagency.com/public_html/app/Http/Controllers/InvoiceController.php(221): App\Repositories\InvoiceRepository->save(Array, Object(App\Models\Invoice))
#15 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\InvoiceController->store(Object(App\Http\Requests\Invoice\StoreInvoiceRequest))
#16 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\Routing\Controller->callAction(‘store’, Array)
#17 /home/customer/www/administracion.mingoagency.com/public_html/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php(21): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\InvoiceController), ‘store’)
#18 /home/customer/www/administracion.mingoagency.com/public_html/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php(19): Sentry\Laravel\Tracing\Routing\TracingControllerDispatcherTracing->Sentry\Laravel\Tracing\Routing\{closure}()
#19 /home/customer/www/administracion.mingoagency.com/public_html/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php(20): Sentry\Laravel\Tracing\Routing\TracingRoutingDispatcher->wrapRouteDispatch(Object(Closure), Object(Illuminate\Routing\Route))
#20 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(259): Sentry\Laravel\Tracing\Routing\TracingControllerDispatcherTracing->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\InvoiceController), ‘store’)
#21 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\Routing\Route->runController()
#22 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\Routing\Route->run()
#23 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#24 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(122): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#25 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(87): Illuminate\Routing\Middleware\ThrottleRequests->handleRequestUsingNamedLimiter(Object(Illuminate\Http\Request), Object(Closure), ‘api’, Object(Closure))
#26 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Routing\Middleware\ThrottleRequests->handle(Object(Illuminate\Http\Request), Object(Closure), ‘api’)
#27 /home/customer/www/administracion.mingoagency.com/public_html/app/Http/Middleware/QueryLogging.php(40): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#28 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\QueryLogging->handle(Object(Illuminate\Http\Request), Object(Closure))
#29 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#30 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#31 /home/customer/www/administracion.mingoagency.com/public_html/app/Http/Middleware/Locale.php(86): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#32 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\Locale->handle(Object(Illuminate\Http\Request), Object(Closure))
#33 /home/customer/www/administracion.mingoagency.com/public_html/app/Http/Middleware/TokenAuth.php(101): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#34 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\TokenAuth->handle(Object(Illuminate\Http\Request), Object(Closure))
#35 /home/customer/www/administracion.mingoagency.com/public_html/app/Http/Middleware/SetDb.php(40): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#36 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\SetDb->handle(Object(Illuminate\Http\Request), Object(Closure))
#37 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#38 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(805): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#39 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(784): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#40 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(748): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route))
#41 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(737): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#42 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#43 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#44 /home/customer/www/administracion.mingoagency.com/public_html/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Http/SetRequestIpMiddleware.php(45): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#45 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Sentry\Laravel\Http\SetRequestIpMiddleware->handle(Object(Illuminate\Http\Request), Object(Closure))
#46 /home/customer/www/administracion.mingoagency.com/public_html/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Http/SetRequestMiddleware.php(31): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#47 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Sentry\Laravel\Http\SetRequestMiddleware->handle(Object(Illuminate\Http\Request), Object(Closure))
#48 /home/customer/www/administracion.mingoagency.com/public_html/vendor/livewire/livewire/src/DisableBrowserCache.php(19): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#49 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Livewire\DisableBrowserCache->handle(Object(Illuminate\Http\Request), Object(Closure))
#50 /home/customer/www/administracion.mingoagency.com/public_html/app/Http/Middleware/Cors.php(24): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#51 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\Cors->handle(Object(Illuminate\Http\Request), Object(Closure))
#52 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#53 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Http\Middleware\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
#54 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#55 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#56 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(Object(Illuminate\Http\Request), Object(Closure))
#57 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#58 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#59 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\TrimStrings->handle(Object(Illuminate\Http\Request), Object(Closure))
#60 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#61 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure))
#62 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(99): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#63 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(Object(Illuminate\Http\Request), Object(Closure))
#64 /home/customer/www/administracion.mingoagency.com/public_html/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Middleware.php(87): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#65 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Sentry\Laravel\Tracing\Middleware->handle(Object(Illuminate\Http\Request), Object(Closure))
#66 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#67 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#68 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#69 /home/customer/www/administracion.mingoagency.com/public_html/public/index.php(56): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#70 {main}

[previous exception] [object] (PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1-2024-1549’ for key ‘invoices_company_id_number_unique’ at /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:580)

kcocarmona · January 30, 2024, 9:07pm

[stacktrace]
#0 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): PDOStatement->execute()
#1 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(809): Illuminate\Database\Connection->Illuminate\Database\{closure}(‘insert into in...', Array) #2 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(776): Illuminate\\Database\\Connection->runQueryCallback('insert into in…’, Array, Object(Closure))
#3 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(569): Illuminate\Database\Connection->run(‘insert into in...', Array, Object(Closure)) #4 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(533): Illuminate\\Database\\Connection->statement('insert into in…’, Array)
#5 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert(‘insert into in...', Array) #6 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3387): Illuminate\\Database\\Query\\Processors\\Processor->processInsertGetId(Object(Illuminate\\Database\\Query\\Builder), 'insert into in…’, Array, ‘id’)
#7 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1968): Illuminate\Database\Query\Builder->insertGetId(Array, ‘id’)
#8 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1333): Illuminate\Database\Eloquent\Builder->__call(‘insertGetId’, Array)
#9 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1298): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#10 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1137): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#11 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1103): Illuminate\Database\Eloquent\Model->save(Array)
#12 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasEvents.php(408): Illuminate\Database\Eloquent\Model->Illuminate\Database\Eloquent\{closure}()
#13 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1103): Illuminate\Database\Eloquent\Model::withoutEvents(Object(Closure))
#14 /home/customer/www/administracion.mingoagency.com/public_html/app/Repositories/BaseRepository.php(203): Illuminate\Database\Eloquent\Model->saveQuietly()
#15 /home/customer/www/administracion.mingoagency.com/public_html/app/Repositories/InvoiceRepository.php(35): App\Repositories\BaseRepository->alternativeSave(Array, Object(App\Models\Invoice))
#16 /home/customer/www/administracion.mingoagency.com/public_html/app/Http/Controllers/InvoiceController.php(221): App\Repositories\InvoiceRepository->save(Array, Object(App\Models\Invoice))
#17 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\InvoiceController->store(Object(App\Http\Requests\Invoice\StoreInvoiceRequest))
#18 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\Routing\Controller->callAction(‘store’, Array)
#19 /home/customer/www/administracion.mingoagency.com/public_html/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php(21): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\InvoiceController), ‘store’)
#20 /home/customer/www/administracion.mingoagency.com/public_html/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php(19): Sentry\Laravel\Tracing\Routing\TracingControllerDispatcherTracing->Sentry\Laravel\Tracing\Routing\{closure}()
#21 /home/customer/www/administracion.mingoagency.com/public_html/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php(20): Sentry\Laravel\Tracing\Routing\TracingRoutingDispatcher->wrapRouteDispatch(Object(Closure), Object(Illuminate\Routing\Route))
#22 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(259): Sentry\Laravel\Tracing\Routing\TracingControllerDispatcherTracing->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\InvoiceController), ‘store’)
#23 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\Routing\Route->runController()
#24 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\Routing\Route->run()
#25 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#26 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(122): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#27 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(87): Illuminate\Routing\Middleware\ThrottleRequests->handleRequestUsingNamedLimiter(Object(Illuminate\Http\Request), Object(Closure), ‘api’, Object(Closure))
#28 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Routing\Middleware\ThrottleRequests->handle(Object(Illuminate\Http\Request), Object(Closure), ‘api’)
#29 /home/customer/www/administracion.mingoagency.com/public_html/app/Http/Middleware/QueryLogging.php(40): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#30 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\QueryLogging->handle(Object(Illuminate\Http\Request), Object(Closure))
#31 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#32 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#33 /home/customer/www/administracion.mingoagency.com/public_html/app/Http/Middleware/Locale.php(86): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#34 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\Locale->handle(Object(Illuminate\Http\Request), Object(Closure))
#35 /home/customer/www/administracion.mingoagency.com/public_html/app/Http/Middleware/TokenAuth.php(101): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#36 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\TokenAuth->handle(Object(Illuminate\Http\Request), Object(Closure))
#37 /home/customer/www/administracion.mingoagency.com/public_html/app/Http/Middleware/SetDb.php(40): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#38 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\SetDb->handle(Object(Illuminate\Http\Request), Object(Closure))
#39 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#40 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(805): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#41 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(784): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#42 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(748): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route))
#43 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(737): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#44 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#45 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#46 /home/customer/www/administracion.mingoagency.com/public_html/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Http/SetRequestIpMiddleware.php(45): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#47 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Sentry\Laravel\Http\SetRequestIpMiddleware->handle(Object(Illuminate\Http\Request), Object(Closure))
#48 /home/customer/www/administracion.mingoagency.com/public_html/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Http/SetRequestMiddleware.php(31): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#49 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Sentry\Laravel\Http\SetRequestMiddleware->handle(Object(Illuminate\Http\Request), Object(Closure))
#50 /home/customer/www/administracion.mingoagency.com/public_html/vendor/livewire/livewire/src/DisableBrowserCache.php(19): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#51 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Livewire\DisableBrowserCache->handle(Object(Illuminate\Http\Request), Object(Closure))
#52 /home/customer/www/administracion.mingoagency.com/public_html/app/Http/Middleware/Cors.php(24): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#53 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\Cors->handle(Object(Illuminate\Http\Request), Object(Closure))
#54 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#55 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Http\Middleware\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
#56 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#57 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#58 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(Object(Illuminate\Http\Request), Object(Closure))
#59 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#60 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#61 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\TrimStrings->handle(Object(Illuminate\Http\Request), Object(Closure))
#62 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#63 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure))
#64 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(99): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#65 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(Object(Illuminate\Http\Request), Object(Closure))
#66 /home/customer/www/administracion.mingoagency.com/public_html/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Middleware.php(87): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#67 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Sentry\Laravel\Tracing\Middleware->handle(Object(Illuminate\Http\Request), Object(Closure))
#68 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#69 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#70 /home/customer/www/administracion.mingoagency.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#71 /home/customer/www/administracion.mingoagency.com/public_html/public/index.php(56): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#72 {main}
"}

hillel · January 30, 2024, 9:31pm

@david do you have any suggestions?

Another option is to manually update by copying over the latest release invoiceninja.zip.

kcocarmona · January 30, 2024, 9:32pm

In this case, if I do it manually

The only file I should NOT DELETE is the ENV file?
Or is there any other file/folder that I shouldnt touch doing the manual update?

hillel · January 30, 2024, 9:34pm

The zip file doesn’t contain a .env file so it won’t be overwritten.

If you’d like to make a backup you can copy the .env file and use mysqldump to backup the database.

kcocarmona · January 30, 2024, 9:37pm

Ok, I will do that then.

Thanks in advance for your help!