Installation issues with 5.10.4

cybertechnic · June 29, 2024, 8:00pm

Running into 500 after running and filling out setup. The DB credentials work, after a lot of troubleshooting I cleared all the logs, then ran php artisan migrate:fresh --seed. Then reviewed laravel.log and it contained the following.

[2024-06-29 19:48:15] production.INFO: account table not found  
[2024-06-29 19:48:15] production.INFO: account table not found  
[2024-06-29 19:48:15] production.INFO: account table not found  
[2024-06-29 19:48:15] production.INFO: account table not found  
[2024-06-29 19:48:15] production.INFO: account table not found  
[2024-06-29 19:48:15] production.INFO: account table not found  
[2024-06-29 19:48:15] production.INFO: account table not found  
[2024-06-29 19:48:16] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mspsinvninjadb.jobs' doesn't exist (Connection: mysql, SQL: select * from `jobs` where `queue` = default and ((`reserved_at` is null and `available_at` <= 1719690495) or (`reserved_at` <= 1629690495)) order by `id` asc limit 1 FOR UPDATE SKIP LOCKED) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mspsinvninjadb.jobs' doesn't exist (Connection: mysql, SQL: select * from `jobs` where `queue` = default and ((`reserved_at` is null and `available_at` <= 1719690495) or (`reserved_at` <= 1629690495)) order by `id` asc limit 1 FOR UPDATE SKIP LOCKED) at /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php:829)
[stacktrace]

hillel · June 29, 2024, 8:01pm

Hi,

@david do you have any suggestions?

cybertechnic · July 1, 2024, 7:09pm

There is a lot more to the log, but I can’t upload as a new user, and it exceeds post length.

northhill · July 2, 2024, 1:04am

I could be wrong, but that looks like a database error. Have you verified the tables in your database? When you ran php artisan migrate:fresh --seed was it with your www-data user and not the general account user?

cybertechnic · July 2, 2024, 1:39am

Yes, the tables appear in PHPMA. I’m using runcloud to manage the server, so where appropriate users and customizations around that service are changed as needed. I’ve also have successfully deployed IN on a runcloud server last year, so it was with an earlier version. I started with a zip deployment, but this time with git. I’ve tried just about all of the troubleshooting, but I seem to get the same result. I get the setup screen, the DB connection test passes, I create a user and hit next. Then I get a white screen and it dies. I’ve checked the DB and I do see the user created in the user table. I just tried it again in response to this post, and now it’s showing a 500 — Server Error instead of a blank white page after setup. Worker log looks good. Have a new error in laravel.log with todays timestampt.

[2024-07-01 23:30:02] production.INFO: updating currencies  
[2024-07-02 01:34:45] production.ERROR: Call to a member function prepare() on null {"userId":1,"exception":"[object] (Error(code: 0): Call to a member function prepare() on null at /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php:581)
[stacktrace]
#0 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php(816): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
#1 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php(783): Illuminate\\Database\\Connection->runQueryCallback()
#2 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php(576): Illuminate\\Database\\Connection->run()
#3 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php(540): Illuminate\\Database\\Connection->statement()
#4 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\\Database\\Connection->insert()
#5 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3507): Illuminate\\Database\\Query\\Processors\\Processor->processInsertGetId()
#6 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Queue/DatabaseQueue.php(185): Illuminate\\Database\\Query\\Builder->insertGetId()
#7 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Queue/DatabaseQueue.php(96): Illuminate\\Queue\\DatabaseQueue->pushToDatabase()
#8 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Queue/Queue.php(342): Illuminate\\Queue\\DatabaseQueue->Illuminate\\Queue\\{closure}()
#9 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Queue/DatabaseQueue.php(90): Illuminate\\Queue\\Queue->enqueueUsing()
#10 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(254): Illuminate\\Queue\\DatabaseQueue->push()
#11 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(230): Illuminate\\Bus\\Dispatcher->pushCommandToQueue()
#12 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(77): Illuminate\\Bus\\Dispatcher->dispatchToQueue()
#13 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Foundation/Bus/PendingDispatch.php(193): Illuminate\\Bus\\Dispatcher->dispatch()
#14 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Foundation/Bus/Dispatchable.php(19): Illuminate\\Foundation\\Bus\\PendingDispatch->__destruct()
#15 /home/mspsinvninja/webapps/msps-invninja/app/Jobs/Account/CreateAccount.php(135): App\\Jobs\\Util\\VersionCheck::dispatch()
#16 /home/mspsinvninja/webapps/msps-invninja/app/Jobs/Account/CreateAccount.php(54): App\\Jobs\\Account\\CreateAccount->create()
#17 /home/mspsinvninja/webapps/msps-invninja/app/Http/Controllers/SetupController.php(157): App\\Jobs\\Account\\CreateAccount->handle()
#18 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\SetupController->doSetup()
#19 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction()
#20 /home/mspsinvninja/webapps/msps-invninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php(21): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#21 /home/mspsinvninja/webapps/msps-invninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php(19): Sentry\\Laravel\\Tracing\\Routing\\TracingControllerDispatcherTracing->Sentry\\Laravel\\Tracing\\Routing\\{closure}()
#22 /home/mspsinvninja/webapps/msps-invninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php(20): Sentry\\Laravel\\Tracing\\Routing\\TracingRoutingDispatcher->wrapRouteDispatch()
#23 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Routing/Route.php(259): Sentry\\Laravel\\Tracing\\Routing\\TracingControllerDispatcherTracing->dispatch()
#24 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController()
#25 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\\Routing\\Route->run()
#26 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#27 /home/mspsinvninja/webapps/msps-invninja/app/Http/Middleware/RedirectIfAuthenticated.php(56): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#28 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\RedirectIfAuthenticated->handle()
#29 /home/mspsinvninja/webapps/msps-invninja/app/Http/Middleware/QueryLogging.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#30 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\QueryLogging->handle()
#31 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#32 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#33 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#34 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle()
#35 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#36 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle()
#37 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#38 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle()
#39 /home/mspsinvninja/webapps/msps-invninja/app/Http/Middleware/SessionDomains.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#40 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\SessionDomains->handle()
#41 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#42 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest()
#43 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Session\\Middleware\\StartSession->handle()
#44 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#45 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle()
#46 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#47 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Routing/Router.php(805): Illuminate\\Pipeline\\Pipeline->then()
#48 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Routing/Router.php(784): Illuminate\\Routing\\Router->runRouteWithinStack()
#49 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Routing/Router.php(748): Illuminate\\Routing\\Router->runRoute()
#50 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Routing/Router.php(737): Illuminate\\Routing\\Router->dispatchToRoute()
#51 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch()
#52 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#53 /home/mspsinvninja/webapps/msps-invninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Http/SetRequestIpMiddleware.php(45): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#54 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Sentry\\Laravel\\Http\\SetRequestIpMiddleware->handle()
#55 /home/mspsinvninja/webapps/msps-invninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Http/SetRequestMiddleware.php(31): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#56 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Sentry\\Laravel\\Http\\SetRequestMiddleware->handle()
#57 /home/mspsinvninja/webapps/msps-invninja/vendor/livewire/livewire/src/Features/SupportDisablingBackButtonCache/DisableBackButtonCacheMiddleware.php(19): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#58 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Livewire\\Features\\SupportDisablingBackButtonCache\\DisableBackButtonCacheMiddleware->handle()
#59 /home/mspsinvninja/webapps/msps-invninja/app/Http/Middleware/Cors.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#60 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\Cors->handle()
#61 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#62 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Http\\Middleware\\TrustProxies->handle()
#63 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#64 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#65 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle()
#66 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#67 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#68 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle()
#69 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#70 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#71 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(99): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#72 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle()
#73 /home/mspsinvninja/webapps/msps-invninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Middleware.php(87): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#74 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Sentry\\Laravel\\Tracing\\Middleware->handle()
#75 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#76 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then()
#77 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#78 /home/mspsinvninja/webapps/msps-invninja/public/index.php(56): Illuminate\\Foundation\\Http\\Kernel->handle()
#79 {main}
"}

cybertechnic · July 2, 2024, 1:40am

[2024-07-01 23:18:41] production.ERROR: Attempt to read property "set_react_as_default_ap" on null {"exception":"[object] (ErrorException(code: 0): Attempt to read property \"set_react_as_default_ap\" on null at /home/mspsinvninja/webapps/msps-invninja/routes/client.php:186)
[stacktrace]
#0 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(255): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError()
#1 /home/mspsinvninja/webapps/msps-invninja/routes/client.php(186): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}()
#2 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Routing/CallableDispatcher.php(40): Illuminate\\Routing\\RouteFileRegistrar->{closure}()
#3 /home/mspsinvninja/webapps/msps-invninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingCallableDispatcherTracing.php(21): Illuminate\\Routing\\CallableDispatcher->dispatch()
#4 /home/mspsinvninja/webapps/msps-invninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php(19): Sentry\\Laravel\\Tracing\\Routing\\TracingCallableDispatcherTracing->Sentry\\Laravel\\Tracing\\Routing\\{closure}()
#5 /home/mspsinvninja/webapps/msps-invninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingCallableDispatcherTracing.php(20): Sentry\\Laravel\\Tracing\\Routing\\TracingRoutingDispatcher->wrapRouteDispatch()
#6 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Routing/Route.php(237): Sentry\\Laravel\\Tracing\\Routing\\TracingCallableDispatcherTracing->dispatch()
#7 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Routing/Route.php(208): Illuminate\\Routing\\Route->runCallable()
#8 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\\Routing\\Route->run()
#9 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#10 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(122): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#11 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(87): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter()
#12 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle()
#13 /home/mspsinvninja/webapps/msps-invninja/app/Http/Middleware/QueryLogging.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#14 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\QueryLogging->handle()
#15 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#16 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#17 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#18 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle()
#19 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#20 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle()
#21 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#22 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle()
#23 /home/mspsinvninja/webapps/msps-invninja/app/Http/Middleware/SessionDomains.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#24 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\SessionDomains->handle()
#25 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#26 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest()
#27 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Session\\Middleware\\StartSession->handle()
#28 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#29 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle()
#30 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#31 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Routing/Router.php(805): Illuminate\\Pipeline\\Pipeline->then()
#32 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Routing/Router.php(784): Illuminate\\Routing\\Router->runRouteWithinStack()
#33 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Routing/Router.php(748): Illuminate\\Routing\\Router->runRoute()
#34 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Routing/Router.php(737): Illuminate\\Routing\\Router->dispatchToRoute()
#35 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch()
#36 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#37 /home/mspsinvninja/webapps/msps-invninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Http/SetRequestIpMiddleware.php(45): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#38 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Sentry\\Laravel\\Http\\SetRequestIpMiddleware->handle()
#39 /home/mspsinvninja/webapps/msps-invninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Http/SetRequestMiddleware.php(31): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#40 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Sentry\\Laravel\\Http\\SetRequestMiddleware->handle()
#41 /home/mspsinvninja/webapps/msps-invninja/vendor/livewire/livewire/src/Features/SupportDisablingBackButtonCache/DisableBackButtonCacheMiddleware.php(19): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#42 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Livewire\\Features\\SupportDisablingBackButtonCache\\DisableBackButtonCacheMiddleware->handle()
#43 /home/mspsinvninja/webapps/msps-invninja/app/Http/Middleware/Cors.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#44 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\Cors->handle()
#45 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#46 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Http\\Middleware\\TrustProxies->handle()
#47 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#48 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#49 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle()
#50 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#51 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#52 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle()
#53 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#54 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#55 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(99): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#56 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle()
#57 /home/mspsinvninja/webapps/msps-invninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Middleware.php(87): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#58 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Sentry\\Laravel\\Tracing\\Middleware->handle()
#59 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#60 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then()
#61 /home/mspsinvninja/webapps/msps-invninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#62 /home/mspsinvninja/webapps/msps-invninja/public/index.php(56): Illuminate\\Foundation\\Http\\Kernel->handle()
#63 {main}
"}

northhill · July 2, 2024, 2:42am

That still looks like a database error. Doing a quick Internet search, a few things came up that could be potential causes.

Are the database settings in your .env file correct?
Did you remember to run composer during setup?

It would appear that your installer can find a valid database, but no tables have been created in the one it’s connecting to, or they’re named something else so the installer cannot recognize them. Did you, by chance, create more than one database? Or is this a shared database?

Interestingly enough, searching for your errors are also indicating that the PHP pdo extension may not have been installed.

Just some more things to look at.

cybertechnic · July 2, 2024, 2:44am

Based on the new errors that showed up after giving up over the weekend, I went into the database, account table and changed the column set_react_as_default_ap to zero. Reload the url, and it works. Was able to login with the account I setup.

Now my question is, why on a fresh install am I having this problem?

northhill · July 2, 2024, 2:52am

Do you get a web error if you change react_as_default back to 1, now that you’re actually in?

What about logging in with the desktop or mobile app? The desktop app should be flutter regardless of what you have web UI set to.

cybertechnic · July 2, 2024, 3:11am

I’ve only been working in my browser… switched react_as_default back to 1 and it loads a white screen again.

cybertechnic · July 2, 2024, 3:26am

It does seem like a DB issue, but the issue has to be coming from the initial seed. It doesn’t seem like the self-host deployment is “clean” from git hub. Lot’s of random env files. I had different issues deploying from zip compared to cloning the repo w/ git. They were easy enough to fix/ or research and fix… but not exactly the experience I had last year or anyone would expect following the instructions.

Maybe if you seed w/ demo data it would work… but that means there are some major gaps between DB tables with demo data and the script that supposed to seed a clean DB. Seems like I’d have to spend more time than I have to dig into this at the moment.

cybertechnic · July 2, 2024, 12:30pm

Does React require a separate installation that’s not covered in any of the self-hosted installation procedures?

hillel · July 2, 2024, 12:31pm

If you install the app using the invoiceninja.tar the React app is included.

cybertechnic · July 2, 2024, 12:58pm

Is this supposed to be the poison pill to get people to use the paid service? lol

hillel · July 2, 2024, 1:00pm

I’m trying to help, I don’t appreciate your accusation. We do everything we can to make it as easy as possible to setup/update the selfhost app.

We use separate repos on GitHub for each part of the app (ie. backend, Flutter frontend, React frontend). If you download the backend code it doesn’t include the React frontend, the release tar has the React app bundled in.

cybertechnic · July 2, 2024, 1:07pm

I appreciate the help, it was a generalized comment, not directed at you. I’m new here, maybe I don’t know who you are and your role.

I’m just a little confused though and this is just constructive criticism to help. In every single installation procedure on the .org website it uses either .zip or git to install the application. Not once is a separate installation procedure is referenced or linked to install react.

Then the default configuration is looking for react. The application can update itself, but it can’t install the react application required for its default configuration?

I spent way too much time over something that could have been avoided with simple notice on a kb article.

I’m just confused why it is like this? Maybe I’m ignorant of something. IDK

hillel · July 2, 2024, 1:14pm

From the error I’m guessing you may have setup the app by checking out the code from GitHub. I’m suggesting that instead you use the invoiceninja.tar file from the releases page. That’s the simplest way to have both the backend and the React app installed.

cybertechnic · July 2, 2024, 1:22pm

I really like this app and a couple of struggling new business owners I set this up for absolutely love it.
Is there something that can be done to update the instructions on the org page? Can I help with that?

With my previous install I purchased plugins and white label and am willing to support this project. I’m not claiming to be an expert, but I’m also not a newb and if the instructions lead me down a path to failure. Imagine how many people have tried this app and just gave up on it. That’s potential financial support out the door.

Unless it’s by design. hence my poor attempt and cynical humor. Not that I blame anyone for trying to get paid.

In any event, I appreciate you spending your time to help out on this. Thank you.

hillel · July 2, 2024, 1:30pm

The docs are are on GitHub, if you’re able to create pull requests to improve them we’d very much appreciate it.