When using the React interface I get some errors when ordering invoices:
- on Invoices if I order by number
- and on Recurring Invoices if I order by next date.
Works well on the Flutter interface.
I get this error on developer console:
{
"message": "Request failed with status code 500",
"name": "AxiosError",
"config": {
"transitional": {
"silentJSONParsing": true,
"forcedJSONParsing": true,
"clarifyTimeoutError": false
},
"transformRequest": [
null
],
"transformResponse": [
null
],
"timeout": 0,
"xsrfCookieName": "XSRF-TOKEN",
"xsrfHeaderName": "X-XSRF-TOKEN",
"maxContentLength": -1,
"maxBodyLength": -1,
"env": {
"FormData": null
},
"headers": {
"Accept": "application/json, text/plain, */*",
"X-Api-Token": "AQzHmbkkPdXQtQbfQmHUrRQyyjXXXXXXXXXXXXXXXXXXXXXX",
"X-Requested-With": "XMLHttpRequest",
"X-React": "true",
"X-XSRF-TOKEN": "eyJpdiI6ImlPb1R6OHhNSk9pcUpEazhvLzhqQWc9PSIsInZhbHVlIjoiUGNsamXXXXXXXXXXXXXXXXXXXXXX="
},
"method": "get",
"url": "https://XXXXX.XXXXX.XXX/api/v1/invoices?include=client.group_settings&without_deleted_clients=true&sort=number%7Casc&per_page=10&page=1&filter=&client_status=all&status=active"
},
"code": "ERR_BAD_RESPONSE",
"status": 500
}
Also, in laravel.log:
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'next_send_datetime' in 'order clause' at /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Database/Connection.php:423)
[stacktrace]
#0 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Database/Connection.php(423): PDO->prepare()
#1 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Database/Connection.php(816): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
#2 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Database/Connection.php(783): Illuminate\\Database\\Connection->runQueryCallback()
#3 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Database/Connection.php(431): Illuminate\\Database\\Connection->run()
#4 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2872): Illuminate\\Database\\Connection->select()
#5 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2860): Illuminate\\Database\\Query\\Builder->runSelect()
#6 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3414): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#7 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2861): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#8 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(738): Illuminate\\Database\\Query\\Builder->get()
#9 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(722): Illuminate\\Database\\Eloquent\\Builder->getModels()
#10 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(930): Illuminate\\Database\\Eloquent\\Builder->get()
#11 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/app/Http/Controllers/BaseController.php(958): Illuminate\\Database\\Eloquent\\Builder->paginate()
#12 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/app/Http/Controllers/RecurringInvoiceController.php(112): App\\Http\\Controllers\\BaseController->listResponse()
#13 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\RecurringInvoiceController->index()
#14 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction()
#15 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php(21): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#16 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php(19): Sentry\\Laravel\\Tracing\\Routing\\TracingControllerDispatcherTracing->Sentry\\Laravel\\Tracing\\Routing\\{closure}()
#17 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php(20): Sentry\\Laravel\\Tracing\\Routing\\TracingRoutingDispatcher->wrapRouteDispatch()
#18 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Sentry\\Laravel\\Tracing\\Routing\\TracingControllerDispatcherTracing->dispatch()
#19 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController()
#20 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\\Routing\\Route->run()
#21 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#22 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(122): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#23 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(87): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter()
#24 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle()
#25 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/app/Http/Middleware/QueryLogging.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#26 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\QueryLogging->handle()
#27 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#28 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#29 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/app/Http/Middleware/Locale.php(87): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#30 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\Locale->handle()
#31 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/app/Http/Middleware/TokenAuth.php(102): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#32 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\TokenAuth->handle()
#33 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/app/Http/Middleware/SetDb.php(40): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#34 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\SetDb->handle()
#35 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#36 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Routing/Router.php(807): Illuminate\\Pipeline\\Pipeline->then()
#37 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Routing/Router.php(784): Illuminate\\Routing\\Router->runRouteWithinStack()
#38 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Routing/Router.php(748): Illuminate\\Routing\\Router->runRoute()
#39 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Routing/Router.php(737): Illuminate\\Routing\\Router->dispatchToRoute()
#40 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch()
#41 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#42 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Http/SetRequestIpMiddleware.php(45): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#43 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Sentry\\Laravel\\Http\\SetRequestIpMiddleware->handle()
#44 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Http/SetRequestMiddleware.php(31): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#45 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Sentry\\Laravel\\Http\\SetRequestMiddleware->handle()
#46 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/livewire/livewire/src/Features/SupportDisablingBackButtonCache/DisableBackButtonCacheMiddleware.php(19): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#47 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Livewire\\Features\\SupportDisablingBackButtonCache\\DisableBackButtonCacheMiddleware->handle()
#48 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/app/Http/Middleware/Cors.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#49 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\Cors->handle()
#50 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#51 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Http\\Middleware\\TrustProxies->handle()
#52 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#53 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#54 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle()
#55 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#56 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#57 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle()
#58 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#59 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#60 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(99): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#61 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle()
#62 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Middleware.php(87): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#63 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Sentry\\Laravel\\Tracing\\Middleware->handle()
#64 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#65 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then()
#66 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#67 /home/xxxxx/htdocs/invoice.xxxxxx.xxxx/public/index.php(57): Illuminate\\Foundation\\Http\\Kernel->handle()
#68 {main}
"}
Version info:
On the React About information I have:
- version: v14.04.2024.1
- web: 8.1.7
- cli: PHP 8.1.7 (currently can’t upgrade)
- Memory: 1G
- API: 5.8.51
I’m using a self-hosted Ubuntu VPS.