cm84
November 17, 2023, 12:49pm
1
Hello.
First of all, thank you for your work.
I have deployed Invoice Ninja v5.5.28-C95 hosted on my hosting where I have hosted my website.
I want to upgrade to the latest version, but from the GUI it doesn’t seem to detect the latest version, if I hit force upgrade it tells me I’m already on the latest.
I have searched the forum for information and have been correcting some things:
I have changed my web server to PHP 8.2.
I have corrected the CRON problem that was not enabled (I thought that by solving this it would detect updates). It has been an achievement for me to solve this, I don’t have advanced knowledge.
From what I see in response to other users, you recommend manual configuration, i.e. overwriting folders and files with the contents of the zip file.
Is this the way to do it?
If this is the only way, do I unzip the zip file and copy/paste over the current directory? or should I skip overwriting any folders or files so I don’t lose my current configuration?
Thanks in advance.
Regards.
hillel
November 17, 2023, 1:18pm
2
Hi,
After enabling the cron it may take up to 24 hours to detect the new version being available.
If you’re using the zip you’d overwrite your current files, you may want to backup the .env file just in case.
cm84
November 17, 2023, 1:31pm
3
Ok, perfect.
I will wait 24 hours to see what happens.
One more doubt, the design of the template for invoices and budget that I have is custom, after the update will not be affected?
Thank you very much.
hillel
November 17, 2023, 1:33pm
4
Correct, they won’t be affected.
cm84
November 18, 2023, 11:41am
5
Thanks.
One question more.
I have configure the cron how: * * * * * (every minute)
What do you recommend? 1 minute, 5 minutes, 1 hour…
hillel
November 18, 2023, 3:58pm
6
The cron need to run every minute
cm84
November 20, 2023, 12:53pm
7
I have just finished copying the files from the latest version and the files have been replaced.
Now when I try to log in I get an error message: 500 server error
What do I do?
hillel
November 20, 2023, 1:36pm
8
Are there any details about the 500 error in storage/logs?
cm84
November 20, 2023, 2:50pm
9
This is what comes out in the storage/logs
Summary
[2023-11-20 14:44:24] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘xxxx_ninja.bank_integrations’ doesn’t exist (Connection: mysql, SQL: select * from bank_integrations where bank_integrations.company_id in (1) and created_at >= 1970-01-01 00:00:00 and bank_integrations.deleted_at is null) {“userId”:1,“exception”:"[object] (Illuminate\Database\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘xxxx_ninja.bank_integrations’ doesn’t exist (Connection: mysql, SQL: select * from bank_integrations where bank_integrations.company_id in (1) and created_at >= 1970-01-01 00:00:00 and bank_integrations.deleted_at is null) at /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Connection.php:822)#0 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Connection.php(776): Illuminate\Database\Connection->runQueryCallback()#1 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Connection.php(407): Illuminate\Database\Connection->run()#2 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2751): Illuminate\Database\Connection->select()#3 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2740): Illuminate\Database\Query\Builder->runSelect()#4 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3294): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()#5 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2739): Illuminate\Database\Query\Builder->onceWithColumns()#6 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(737): Illuminate\Database\Query\Builder->get()#7 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(721): Illuminate\Database\Eloquent\Builder->getModels()#8 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(203): Illuminate\Database\Eloquent\Builder->get()#9 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(166): Illuminate\Database\Eloquent\Relations\Relation->get()#10 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(785): Illuminate\Database\Eloquent\Relations\Relation->getEager()#11 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(754): Illuminate\Database\Eloquent\Builder->eagerLoadRelation()#12 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(722): Illuminate\Database\Eloquent\Builder->eagerLoadRelations()#13 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(203): Illuminate\Database\Eloquent\Builder->get()#14 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(166): Illuminate\Database\Eloquent\Relations\Relation->get()#15 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(785): Illuminate\Database\Eloquent\Relations\Relation->getEager()#16 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(754): Illuminate\Database\Eloquent\Builder->eagerLoadRelation()#17 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(722): Illuminate\Database\Eloquent\Builder->eagerLoadRelations()#18 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(929): Illuminate\Database\Eloquent\Builder->get()#19 /home/xxxx/yyyyy/app/Http/Controllers/BaseController.php(885): Illuminate\Database\Eloquent\Builder->paginate()#20 /home/xxxx/yyyyy/app/Http/Controllers/Auth/LoginController.php(156): App\Http\Controllers\BaseController->timeConstrainedResponse()#21 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\Auth\LoginController->apiLogin()#22 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\Routing\Controller->callAction()#23 /home/xxxx/yyyyy/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php(21): Illuminate\Routing\ControllerDispatcher->dispatch()#24 /home/xxxx/yyyyy/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php(19): Sentry\Laravel\Tracing\Routing\TracingControllerDispatcherTracing->Sentry\Laravel\Tracing\Routing\{closure}()#25 /home/xxxx/yyyyy/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php(20): Sentry\Laravel\Tracing\Routing\TracingRoutingDispatcher->wrapRouteDispatch()#26 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/Route.php(259): Sentry\Laravel\Tracing\Routing\TracingControllerDispatcherTracing->dispatch()#27 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\Routing\Route->runController()#28 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\Routing\Route->run()#29 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Routing\Router->Illuminate\Routing\{closure}()#30 /home/xxxx/yyyyy/app/Http/Middleware/ApiSecretCheck.php(31): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#31 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\ApiSecretCheck->handle()#32 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(122): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#33 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(87): Illuminate\Routing\Middleware\ThrottleRequests->handleRequestUsingNamedLimiter()#34 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Routing\Middleware\ThrottleRequests->handle()#35 /home/xxxx/yyyyy/app/Http/Middleware/QueryLogging.php(40): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#36 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\QueryLogging->handle()#37 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#38 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Routing\Middleware\SubstituteBindings->handle()#39 /home/xxxx/yyyyy/app/Http/Middleware/SetEmailDb.php(41): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#40 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\SetEmailDb->handle()#41 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#42 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\Pipeline\Pipeline->then()#43 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/Router.php(777): Illuminate\Routing\Router->runRouteWithinStack()#44 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/Router.php(741): Illuminate\Routing\Router->runRoute()#45 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/Router.php(730): Illuminate\Routing\Router->dispatchToRoute()#46 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\Routing\Router->dispatch()#47 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}()#48 /home/xxxx/yyyyy/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Http/SetRequestIpMiddleware.php(45): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#49 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Sentry\Laravel\Http\SetRequestIpMiddleware->handle()#50 /home/xxxx/yyyyy/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Http/SetRequestMiddleware.php(31): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#51 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Sentry\Laravel\Http\SetRequestMiddleware->handle()#52 /home/xxxx/yyyyy/vendor/livewire/livewire/src/DisableBrowserCache.php(19): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#53 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Livewire\DisableBrowserCache->handle()#54 /home/xxxx/yyyyy/app/Http/Middleware/Cors.php(24): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#55 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\Cors->handle()#56 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#57 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Http\Middleware\TrustProxies->handle()#58 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#59 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()#60 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle()#61 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#62 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()#63 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\TrimStrings->handle()#64 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#65 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle()#66 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(99): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#67 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle()#68 /home/xxxx/yyyyy/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Middleware.php(87): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#69 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Sentry\Laravel\Tracing\Middleware->handle()#70 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#71 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\Pipeline\Pipeline->then()#72 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter()#73 /home/xxxx/yyyyy/public/index.php(56): Illuminate\Foundation\Http\Kernel->handle()#74 {main}
[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘xxxx_ninja.bank_integrations’ doesn’t exist at /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Connection.php:416)#0 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Connection.php(416): PDO->prepare()#1 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Connection.php(809): Illuminate\Database\Connection->Illuminate\Database\{closure}()#2 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Connection.php(776): Illuminate\Database\Connection->runQueryCallback()#3 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Connection.php(407): Illuminate\Database\Connection->run()#4 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2751): Illuminate\Database\Connection->select()#5 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2740): Illuminate\Database\Query\Builder->runSelect()#6 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3294): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()#7 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2739): Illuminate\Database\Query\Builder->onceWithColumns()#8 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(737): Illuminate\Database\Query\Builder->get()#9 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(721): Illuminate\Database\Eloquent\Builder->getModels()#10 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(203): Illuminate\Database\Eloquent\Builder->get()#11 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(166): Illuminate\Database\Eloquent\Relations\Relation->get()#12 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(785): Illuminate\Database\Eloquent\Relations\Relation->getEager()#13 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(754): Illuminate\Database\Eloquent\Builder->eagerLoadRelation()#14 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(722): Illuminate\Database\Eloquent\Builder->eagerLoadRelations()#15 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(203): Illuminate\Database\Eloquent\Builder->get()#16 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(166): Illuminate\Database\Eloquent\Relations\Relation->get()#17 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(785): Illuminate\Database\Eloquent\Relations\Relation->getEager()#18 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(754): Illuminate\Database\Eloquent\Builder->eagerLoadRelation()#19 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(722): Illuminate\Database\Eloquent\Builder->eagerLoadRelations()#20 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(929): Illuminate\Database\Eloquent\Builder->get()#21 /home/xxxx/yyyyy/app/Http/Controllers/BaseController.php(885): Illuminate\Database\Eloquent\Builder->paginate()#22 /home/xxxx/yyyyy/app/Http/Controllers/Auth/LoginController.php(156): App\Http\Controllers\BaseController->timeConstrainedResponse()#23 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\Auth\LoginController->apiLogin()#24 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\Routing\Controller->callAction()#25 /home/xxxx/yyyyy/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php(21): Illuminate\Routing\ControllerDispatcher->dispatch()#26 /home/xxxx/yyyyy/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php(19): Sentry\Laravel\Tracing\Routing\TracingControllerDispatcherTracing->Sentry\Laravel\Tracing\Routing\{closure}()#27 /home/xxxx/yyyyy/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php(20): Sentry\Laravel\Tracing\Routing\TracingRoutingDispatcher->wrapRouteDispatch()#28 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/Route.php(259): Sentry\Laravel\Tracing\Routing\TracingControllerDispatcherTracing->dispatch()#29 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\Routing\Route->runController()#30 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\Routing\Route->run()#31 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Routing\Router->Illuminate\Routing\{closure}()#32 /home/xxxx/yyyyy/app/Http/Middleware/ApiSecretCheck.php(31): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#33 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\ApiSecretCheck->handle()#34 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(122): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#35 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(87): Illuminate\Routing\Middleware\ThrottleRequests->handleRequestUsingNamedLimiter()#36 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Routing\Middleware\ThrottleRequests->handle()#37 /home/xxxx/yyyyy/app/Http/Middleware/QueryLogging.php(40): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#38 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\QueryLogging->handle()#39 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#40 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Routing\Middleware\SubstituteBindings->handle()#41 /home/xxxx/yyyyy/app/Http/Middleware/SetEmailDb.php(41): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#42 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\SetEmailDb->handle()#43 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#44 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\Pipeline\Pipeline->then()#45 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/Router.php(777): Illuminate\Routing\Router->runRouteWithinStack()#46 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/Router.php(741): Illuminate\Routing\Router->runRoute()#47 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Routing/Router.php(730): Illuminate\Routing\Router->dispatchToRoute()#48 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\Routing\Router->dispatch()#49 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}()#50 /home/xxxx/yyyyy/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Http/SetRequestIpMiddleware.php(45): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#51 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Sentry\Laravel\Http\SetRequestIpMiddleware->handle()#52 /home/xxxx/yyyyy/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Http/SetRequestMiddleware.php(31): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#53 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Sentry\Laravel\Http\SetRequestMiddleware->handle()#54 /home/xxxx/yyyyy/vendor/livewire/livewire/src/DisableBrowserCache.php(19): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#55 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Livewire\DisableBrowserCache->handle()#56 /home/xxxx/yyyyy/app/Http/Middleware/Cors.php(24): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#57 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\Cors->handle()#58 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#59 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Http\Middleware\TrustProxies->handle()#60 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#61 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()#62 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle()#63 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#64 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()#65 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\TrimStrings->handle()#66 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#67 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle()#68 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(99): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#69 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle()#70 /home/xxxx/yyyyy/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Middleware.php(87): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#71 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Sentry\Laravel\Tracing\Middleware->handle()#72 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#73 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\Pipeline\Pipeline->then()#74 /home/xxxx/yyyyy/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter()#75 /home/xxxx/yyyyy/public/index.php(56): Illuminate\Foundation\Http\Kernel->handle()#76 {main}
I have replaced the names and routes with privacy.
hillel
November 20, 2023, 2:56pm
10
It should help to run php artisan migrate
cm84
November 20, 2023, 3:02pm
11
But from where do I execute this command?
I have Invoice Ninja deployed on my website server, on a dedicated subdomain.
I don’t know where I can launch the command.
hillel
November 20, 2023, 3:15pm
12
You need to SSH into the server and run the command from the root folder of the project.
It may work to load /update?secret=secret instead.
cm84
November 20, 2023, 3:22pm
13
hillel:
/update?secret=
/update?secret= did not work
I don’t know how to access by ssh to the server of my web page, it is a hosting like Siteground for example.
hillel
November 20, 2023, 3:24pm
14
You may want to reach out to your webhost to ask for advice.
@david do you have any suggestions?
cm84
November 20, 2023, 3:51pm
15
Another test I have done is to create a new subdomain, I have unzipped the .zip of the latest version and copied the .env file in this folder.
The behavior is the same, it loads the login screen but then once I try to log in: 500 error server (in the log the same message I posted above).
Is there any problem with the connection to the DB?
The SSH option I don’t know if my provider will give me access.
hillel
November 20, 2023, 8:12pm
16
The DB connection is fine, from the error it looks like the database is missing some tables/fields added in recent releases.
cm84
November 20, 2023, 8:54pm
17
Then, what is the solution?
hillel
November 21, 2023, 6:30am
18
Are there any new errors in the logs when loading /update?secret=secret
cm84
November 21, 2023, 3:13pm
19
When I run /update?secret= the log file shows nothing.
When I try to log in is when the log file shows the errors I posted above.
It points to something related to the DB.
I don’t know what has been changed from version 5.5.28-C95 to the latest version I am trying to update.
It occurs to me to start the new version with an empty DB and then import my current DB, but it is a cumbersome process if every upgrade I have to do something like that.
hillel
November 21, 2023, 3:20pm
20
Another option would be to setup the app locally, run php artisan migrate and then export/import the database to the server.