500 Server Error with version >5.7x incl 5.8x, memory limit 512mb?

SaKe · February 11, 2024, 2:15pm

Hi Ninjas!

until v5.5 my self-hosted version worked fine on a shared hoster with php memory limit of 512mb.
After updating (manually), i get 500 server errors whenever i try to change/create any item, e.g. customers.
Looking at the system check, 1024mb are now minimal requirement - could this be the reason for the error?

I do have a very small database (less than 10 clients and invoices, handful of expenses), taking up just 5mb of space on my account. So it can´t be an issue due to large amount of data.

Not a long time ago (less than two years?), even 256mb seemed to be more than sufficient.

Since the 512mb memory limit is hardcoded from my hosting provider, there is nothing i can´t do here.

Any ideas on how to solve it?

Here is a screenshot of 5.8. Hope it helps and thanks!!

v5.8.23-C154
Screenshot 2024-02-11 150418
(500 Server Error when trying to create anything, e.g. Customer)

SaKe · February 11, 2024, 2:16pm

And here is a screenshot of 5.5:

v5.5.98-C110
(working fine)
Screenshot 2024-02-11 150557

hillel · February 11, 2024, 3:32pm

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

SaKe · February 11, 2024, 4:23pm

Hi hillel,
thanks for asking!

Theres a laravel.log file.
Lots of errors concerning sqlstate. As mentioned earlier - i didn´t change anything from the working version except updating to a newer version (uploading .zip and extracting it while overwriting existing data). Even using a fresh install in this test environment results in the same error.
Happens with Any version higher than my initial install.

Do you need the complete log?

Here is the last error part 1:

Blockquote
[2024-02-11 16:16:39] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘classification’ in ‘field list’ (Connection: mysql, SQL: insert into clients (company_id, user_id, name, website, private_notes, public_notes, balance, paid_to_date, country_id, is_deleted, client_hash, settings, classification, group_settings_id, address1, address2, city, state, postal_code, phone, industry_id, size_id, vat_number, id_number, shipping_address1, shipping_address2, shipping_city, shipping_state, shipping_postal_code, shipping_country_id, custom_value1, custom_value2, custom_value3, custom_value4, routing_id, is_tax_exempt, assigned_user_id, updated_at, created_at) values (1, 2, neuer kunde, test, ?, ?, 0, 0, 276, 0, Ujf7Iy9hf6WaloaEaaddWjbZ2bZYGMbA745e1P1k, {“language_id”:“3”,“currency_id”:“3”,“entity”:“App\Models\Client”,“industry_id”:“”,“size_id”:“”}, ?, ?, test, ?, gsrgh, yjhjy, 666666, ?, 12, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 0, 1, 2024-02-11 16:16:39.607160, 2024-02-11 16:16:39.607160)) {“userId”:2,“exception”:"[object] (Illuminate\Database\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘classification’ in ‘field list’ (Connection: mysql, SQL: insert into clients (company_id, user_id, name, website, private_notes, public_notes, balance, paid_to_date, country_id, is_deleted, client_hash, settings, classification, group_settings_id, address1, address2, city, state, postal_code, phone, industry_id, size_id, vat_number, id_number, shipping_address1, shipping_address2, shipping_city, shipping_state, shipping_postal_code, shipping_country_id, custom_value1, custom_value2, custom_value3, custom_value4, routing_id, is_tax_exempt, assigned_user_id, updated_at, created_at) values (1, 2, neuer kunde, test, ?, ?, 0, 0, 276, 0, Ujf7Iy9hf6WaloaEaaddWjbZ2bZYGMbA745e1P1k, {"language_id":"3","currency_id":"3","entity":"App\\Models\\Client","industry_id":"","size_id":""}, ?, ?, test, ?, gsrgh, yjhjy, 666666, ?, 12, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 0, 1, 2024-02-11 16:16:39.607160, 2024-02-11 16:16:39.607160)) at /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php:829)
[stacktrace]
#0 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php(783): Illuminate\Database\Connection->runQueryCallback(‘insert into cl...', Array, Object(Closure)) #1 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php(576): Illuminate\\Database\\Connection->run('insert into cl…’, Array, Object(Closure))
#2 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php(540): Illuminate\Database\Connection->statement(‘insert into cl...', Array) #3 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\\Database\\Connection->insert('insert into cl…’, Array)
#4 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3387): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), ‘insert into `cl…’, Array, ‘id’)
#5 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1969): Illuminate\Database\Query\Builder->insertGetId(Array, ‘id’)
#6 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1333): Illuminate\Database\Eloquent\Builder->__call(‘insertGetId’, Array)
#7 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1298): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#8 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1137): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#9 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/app/Repositories/ClientRepository.php(79): Illuminate\Database\Eloquent\Model->save()
#10 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/app/Http/Controllers/ClientController.php(173): App\Repositories\ClientRepository->save(Array, Object(App\Models\Client))
#11 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\ClientController->store(Object(App\Http\Requests\Client\StoreClientRequest))
#12 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\Routing\Controller->callAction(‘store’, Array)
#13 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php(21): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\ClientController), ‘store’)
#14 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php(19): Sentry\Laravel\Tracing\Routing\TracingControllerDispatcherTracing->Sentry\Laravel\Tracing\Routing\{closure}()
#15 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php(20): Sentry\Laravel\Tracing\Routing\TracingRoutingDispatcher->wrapRouteDispatch(Object(Closure), Object(Illuminate\Routing\Route))
#16 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Route.php(259): Sentry\Laravel\Tracing\Routing\TracingControllerDispatcherTracing->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\ClientController), ‘store’)
#17 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\Routing\Route->runController()
#18 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\Routing\Route->run()
#19 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#20 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(122): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#21 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(87): Illuminate\Routing\Middleware\ThrottleRequests->handleRequestUsingNamedLimiter(Object(Illuminate\Http\Request), Object(Closure), ‘api’, Object(Closure))
#22 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Routing\Middleware\ThrottleRequests->handle(Object(Illuminate\Http\Request), Object(Closure), ‘api’)
#23 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/app/Http/Middleware/QueryLogging.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#24 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\Http\Middleware\QueryLogging->handle(Object(Illuminate\Http\Request), Object(Closure))
#25 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#26 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#27 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/app/Http/Middleware/Locale.php(87): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#28 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\Http\Middleware\Locale->handle(Object(Illuminate\Http\Request), Object(Closure))
#29 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/app/Http/Middleware/TokenAuth.php(101): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#30 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\Http\Middleware\TokenAuth->handle(Object(Illuminate\Http\Request), Object(Closure))
#31 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/app/Http/Middleware/SetDb.php(40): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#32 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\Http\Middleware\SetDb->handle(Object(Illuminate\Http\Request), Object(Closure))
#33 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#34 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(805): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#35 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(784): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#36 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(748): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route))
#37 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(737): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#38 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#39 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#40 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Http/SetRequestIpMiddleware.php(45): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#41 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Sentry\Laravel\Http\SetRequestIpMiddleware->handle(Object(Illuminate\Http\Request), Object(Closure))
#42 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Http/SetRequestMiddleware.php(31): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#43 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Sentry\Laravel\Http\SetRequestMiddleware->handle(Object(Illuminate\Http\Request), Object(Closure))
#44 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/livewire/livewire/src/Features/SupportDisablingBackButtonCache/DisableBackButtonCacheMiddleware.php(19): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#45 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Livewire\Features\SupportDisablingBackButtonCache\DisableBackButtonCacheMiddleware->handle(Object(Illuminate\Http\Request), Object(Closure))
#46 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/app/Http/Middleware/Cors.php(24): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#47 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\Http\Middleware\Cors->handle(Object(Illuminate\Http\Request), Object(Closure))
#48 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#49 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Http\Middleware\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
#50 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#51 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#52 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(Object(Illuminate\Http\Request), Object(Closure))
#53 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#54 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#55 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\TrimStrings->handle(Object(Illuminate\Http\Request), Object(Closure))
#56 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#57 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure))
#58 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(99): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#59 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(Object(Illuminate\Http\Request), Object(Closure))
#60 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Middleware.php(87): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#61 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Sentry\Laravel\Tracing\Middleware->handle(Object(Illuminate\Http\Request), Object(Closure))
#62 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#63 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#64 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#65 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/public/index.php(56): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#66 {main}

Blockquote

SaKe · February 11, 2024, 4:23pm

part 2:

Blockquote

[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘classification’ in ‘field list’ at /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php:581)
[stacktrace]
#0 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php(581): PDO->prepare(‘insert into cl...') #1 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php(816): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('insert into cl…’, Array)
#2 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php(783): Illuminate\Database\Connection->runQueryCallback(‘insert into cl...', Array, Object(Closure)) #3 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php(576): Illuminate\\Database\\Connection->run('insert into cl…’, Array, Object(Closure))
#4 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php(540): Illuminate\Database\Connection->statement(‘insert into cl...', Array) #5 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\\Database\\Connection->insert('insert into cl…’, Array)
#6 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3387): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), ‘insert into `cl…’, Array, ‘id’)
#7 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1969): Illuminate\Database\Query\Builder->insertGetId(Array, ‘id’)
#8 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1333): Illuminate\Database\Eloquent\Builder->__call(‘insertGetId’, Array)
#9 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1298): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#10 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1137): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#11 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/app/Repositories/ClientRepository.php(79): Illuminate\Database\Eloquent\Model->save()
#12 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/app/Http/Controllers/ClientController.php(173): App\Repositories\ClientRepository->save(Array, Object(App\Models\Client))
#13 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\ClientController->store(Object(App\Http\Requests\Client\StoreClientRequest))
#14 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\Routing\Controller->callAction(‘store’, Array)
#15 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php(21): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\ClientController), ‘store’)
#16 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php(19): Sentry\Laravel\Tracing\Routing\TracingControllerDispatcherTracing->Sentry\Laravel\Tracing\Routing\{closure}()
#17 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php(20): Sentry\Laravel\Tracing\Routing\TracingRoutingDispatcher->wrapRouteDispatch(Object(Closure), Object(Illuminate\Routing\Route))
#18 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Route.php(259): Sentry\Laravel\Tracing\Routing\TracingControllerDispatcherTracing->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\ClientController), ‘store’)
#19 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\Routing\Route->runController()
#20 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\Routing\Route->run()
#21 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#22 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(122): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#23 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(87): Illuminate\Routing\Middleware\ThrottleRequests->handleRequestUsingNamedLimiter(Object(Illuminate\Http\Request), Object(Closure), ‘api’, Object(Closure))
#24 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Routing\Middleware\ThrottleRequests->handle(Object(Illuminate\Http\Request), Object(Closure), ‘api’)
#25 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/app/Http/Middleware/QueryLogging.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#26 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\Http\Middleware\QueryLogging->handle(Object(Illuminate\Http\Request), Object(Closure))
#27 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#28 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#29 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/app/Http/Middleware/Locale.php(87): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#30 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\Http\Middleware\Locale->handle(Object(Illuminate\Http\Request), Object(Closure))
#31 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/app/Http/Middleware/TokenAuth.php(101): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#32 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\Http\Middleware\TokenAuth->handle(Object(Illuminate\Http\Request), Object(Closure))
#33 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/app/Http/Middleware/SetDb.php(40): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#34 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\Http\Middleware\SetDb->handle(Object(Illuminate\Http\Request), Object(Closure))
#35 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#36 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(805): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#37 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(784): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#38 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(748): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route))
#39 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(737): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#40 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#41 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#42 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Http/SetRequestIpMiddleware.php(45): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#43 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Sentry\Laravel\Http\SetRequestIpMiddleware->handle(Object(Illuminate\Http\Request), Object(Closure))
#44 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Http/SetRequestMiddleware.php(31): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#45 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Sentry\Laravel\Http\SetRequestMiddleware->handle(Object(Illuminate\Http\Request), Object(Closure))
#46 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/livewire/livewire/src/Features/SupportDisablingBackButtonCache/DisableBackButtonCacheMiddleware.php(19): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#47 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Livewire\Features\SupportDisablingBackButtonCache\DisableBackButtonCacheMiddleware->handle(Object(Illuminate\Http\Request), Object(Closure))
#48 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/app/Http/Middleware/Cors.php(24): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#49 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\Http\Middleware\Cors->handle(Object(Illuminate\Http\Request), Object(Closure))
#50 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#51 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Http\Middleware\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
#52 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#53 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#54 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(Object(Illuminate\Http\Request), Object(Closure))
#55 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#56 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#57 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\TrimStrings->handle(Object(Illuminate\Http\Request), Object(Closure))
#58 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#59 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure))
#60 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(99): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#61 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(Object(Illuminate\Http\Request), Object(Closure))
#62 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Middleware.php(87): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#63 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Sentry\Laravel\Tracing\Middleware->handle(Object(Illuminate\Http\Request), Object(Closure))
#64 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#65 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#66 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#67 /var/www/vhosts/hosting162195.ae825.netcup.net/xp-invoice-test/httpdocs/public/index.php(56): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#68 {main}
"}

Blockquote

hillel · February 11, 2024, 4:24pm

Thanks, it may help to run php artisan migrate

SaKe · February 12, 2024, 2:17pm

hm, where am i supposed to run that command? :: As mentioned earlier, it is a webhosting (shared) server, provider is netcup.
I do have access to phpmyadmin.

Edit: managed to get ssh access with powershell, if that may help.

hillel · February 12, 2024, 4:44pm

With shell access you can run the command in the root folder of the project.

SaKe · February 12, 2024, 5:23pm

Tried that meanwhile - to no avail.

Blockquote
Fatal error: Composer detected issues in your platform: Your Composer dependencies require a PHP version “>= 8.1.2”. You are running 8.0.30. in /URL/httpdocs/vendor/composer/platform_check.php on line 28
Blockquote

php is 8.2 as seen in the screenshot…already tried updating to 8.3, but obviously, there seem to be different php versions for web and composer…what the heck…
Any more ideas?

hillel · February 12, 2024, 5:25pm

The server has two PHP versions: web and CLI. Using a newer version CLI PHP should help.

SaKe · February 13, 2024, 10:37am

my gosh, what a pain to get the cli updated…but i did it.
And using php artisan migrate seemed to do the trick, incredible!

Still strange thing is: PHP CLI in invoice ninja still seems to be different than the actual CLI?

Console Version:
bash-5.0$ php -v
PHP 8.2.15 (cli) (built: Jan 19 2024 09:22:47) (NTS)

Webversion (still v7.3.31??):
Screenshot 2024-02-13 113425

Is there anything i still need to fix - and will 512MB Memory be enough to keep on going with invoiceninja?
Because theres no way to increase memory (fixed/set by hoster).

Thanks again for your help!!

hillel · February 13, 2024, 10:40am

Glad to hear it worked!

The memory limit should only be an issue when updating the app, as a fallback you can manually copy over the latest release zip.

SaKe · February 13, 2024, 10:48am

Do you actually sleep or are you a bot for replying that fast and 24/7?

Manually updating is no problem at all, works fast and (up to now) flawless

Will the “dubious” 7.3 CLI version in the web interface become an issue? Still don´t know why it is not v8.2 as seen in my ssh console…keeps me being cautious…

Incredible help in any way from you, @hillel , never expected that!

hillel · February 13, 2024, 11:00am

Of course, happy to help!

The main thing to check for is that crons work correctly, for example recurring invoices or reminder emails.

SaKe · February 13, 2024, 11:35am

Will do - although i (currently) don´t need recurring invoices or reminders.
Business Analytics (BWA in germany) and xml export for electronic tax submission (ELSTER) would be much more beneficial to me😅

But thats a completely different topic and of course just a regional feature “wish”