Upgraded to version 5.10.19 using the .tar file. After upgrade I can only access the Dashboard and Settings on the web version. I am not able to access invoices, payments, etc.
Invoices and payments show up on the dashboard but when I go to /invoices I just get a white screen. I also get the following errors in Console.
Prior to updating I was using 5.10.4 and the web version was working for the most part.
I am able to use the desktop app and everything seems to work fine.
Any suggestions on what might be causing this?
I had similar issues when upgrading to 5.10.18. Please see below.
That’s what I suspected as a response.
Will do. Thanks.
Upgrading to 5.10.19 after that proved back to normal, without problems. I used it on and off today without problem.
Have you checked any of your logs?
1 Like
It seems to work from my laptop at home so it must be caching even though I thought I was clearing the cache and doing a full refresh.
Noticed these two errors in lavaral.log
[2024-08-07 01:48:03] production.ERROR: SQLSTATE[HY000] [1698] Access denied for user ‘ninja’@‘localhost’ (Connection: db-ninja-02, SQL: select * from company_gateways where gateway_key = and company_gateways.deleted_at is null) {“exception”:"[object] (Illuminate\Database\QueryException(code: 1698): SQLSTATE[HY000] [1698] Access denied for user ‘ninja’@‘localhost’ (Connection: db-ninja-02, SQL: select * from company_gateways where gateway_key = and company_gateways.deleted_at is null) at /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php:813)#0 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php(767): Illuminate\Database\Connection->runQueryCallback()#1 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php(461): Illuminate\Database\Connection->run()#2 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3308): Illuminate\Database\Connection->cursor()#3 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Collections/LazyCollection.php(778): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()#4 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Collections/LazyCollection.php(427): Illuminate\Support\LazyCollection->Illuminate\Support\{closure}()#5 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Collections/LazyCollection.php(778): Illuminate\Support\LazyCollection->Illuminate\Support\{closure}()#6 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Collections/LazyCollection.php(427): Illuminate\Support\LazyCollection->Illuminate\Support\{closure}()#7 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Collections/Traits/EnumeratesValues.php(256): Illuminate\Support\LazyCollection->Illuminate\Support\{closure}()#8 /usr/share/nginx/invoiceninja/app/PaymentDrivers/Rotessa/Jobs/TransactionReport.php(55): Illuminate\Support\LazyCollection->each()#9 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\PaymentDrivers\Rotessa\Jobs\TransactionReport->handle()#10 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()#11 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()#12 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()#13 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\Container\BoundMethod::call()#14 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()#15 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()#16 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#17 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()#18 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()#19 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()#20 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#21 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(123): Illuminate\Pipeline\Pipeline->then()#22 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(71): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()#23 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(102): Illuminate\Queue\CallQueuedHandler->call()#24 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(439): Illuminate\Queue\Jobs\Job->fire()#25 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(389): Illuminate\Queue\Worker->process()#26 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(176): Illuminate\Queue\Worker->runJob()#27 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(139): Illuminate\Queue\Worker->daemon()#28 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(122): Illuminate\Queue\Console\WorkCommand->runWorker()#29 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()#30 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()#31 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()#32 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()#33 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\Container\BoundMethod::call()#34 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\Container\Container->call()#35 /usr/share/nginx/invoiceninja/vendor/symfony/console/Command/Command.php(279): Illuminate\Console\Command->execute()#36 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\Component\Console\Command\Command->run()#37 /usr/share/nginx/invoiceninja/vendor/symfony/console/Application.php(1047): Illuminate\Console\Command->run()#38 /usr/share/nginx/invoiceninja/vendor/symfony/console/Application.php(316): Symfony\Component\Console\Application->doRunCommand()#39 /usr/share/nginx/invoiceninja/vendor/symfony/console/Application.php(167): Symfony\Component\Console\Application->doRun()#40 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\Component\Console\Application->run()#41 /usr/share/nginx/invoiceninja/artisan(35): Illuminate\Foundation\Console\Kernel->handle()#42 {main}
[previous exception] [object] (PDOException(code: 1698): SQLSTATE[HY000] [1698] Access denied for user ‘ninja’@‘localhost’ at /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:65)#0 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(65): PDO->__construct()#1 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(44): Illuminate\Database\Connectors\Connector->createPdoConnection()#2 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection()#3 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(185): Illuminate\Database\Connectors\MySqlConnector->connect()#4 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}()#5 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1219): call_user_func()#6 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1255): Illuminate\Database\Connection->getPdo()#7 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php(512): Illuminate\Database\Connection->getReadPdo()#8 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php(469): Illuminate\Database\Connection->getPdoForSelect()#9 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php(800): Illuminate\Database\Connection->Illuminate\Database\{closure}()#10 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php(767): Illuminate\Database\Connection->runQueryCallback()#11 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php(461): Illuminate\Database\Connection->run()#12 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3308): Illuminate\Database\Connection->cursor()#13 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Collections/LazyCollection.php(778): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()#14 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Collections/LazyCollection.php(427): Illuminate\Support\LazyCollection->Illuminate\Support\{closure}()#15 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Collections/LazyCollection.php(778): Illuminate\Support\LazyCollection->Illuminate\Support\{closure}()#16 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Collections/LazyCollection.php(427): Illuminate\Support\LazyCollection->Illuminate\Support\{closure}()#17 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Collections/Traits/EnumeratesValues.php(256): Illuminate\Support\LazyCollection->Illuminate\Support\{closure}()#18 /usr/share/nginx/invoiceninja/app/PaymentDrivers/Rotessa/Jobs/TransactionReport.php(55): Illuminate\Support\LazyCollection->each()#19 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\PaymentDrivers\Rotessa\Jobs\TransactionReport->handle()#20 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()#21 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()#22 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()#23 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\Container\BoundMethod::call()#24 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()#25 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()#26 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#27 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()#28 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()#29 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()#30 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()#31 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(123): Illuminate\Pipeline\Pipeline->then()#32 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(71): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()#33 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(102): Illuminate\Queue\CallQueuedHandler->call()#34 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(439): Illuminate\Queue\Jobs\Job->fire()#35 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(389): Illuminate\Queue\Worker->process()#36 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(176): Illuminate\Queue\Worker->runJob()#37 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(139): Illuminate\Queue\Worker->daemon()#38 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(122): Illuminate\Queue\Console\WorkCommand->runWorker()#39 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()#40 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()#41 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()#42 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()#43 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\Container\BoundMethod::call()#44 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\Container\Container->call()#45 /usr/share/nginx/invoiceninja/vendor/symfony/console/Command/Command.php(279): Illuminate\Console\Command->execute()#46 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\Component\Console\Command\Command->run()#47 /usr/share/nginx/invoiceninja/vendor/symfony/console/Application.php(1047): Illuminate\Console\Command->run()#48 /usr/share/nginx/invoiceninja/vendor/symfony/console/Application.php(316): Symfony\Component\Console\Application->doRunCommand()#49 /usr/share/nginx/invoiceninja/vendor/symfony/console/Application.php(167): Symfony\Component\Console\Application->doRun()#50 /usr/share/nginx/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\Component\Console\Application->run()#51 /usr/share/nginx/invoiceninja/artisan(35): Illuminate\Foundation\Console\Kernel->handle()#52 {main}
You may wish to delete your gateway key from your post.
1 Like
This would suggest that your ninja user cannot access your database, which is why you’re getting those errors. Did you grant that user all rights in your database to db-ninja-02?
I’m neither a PHP expert nor a database expert. A very quick web search suggests that the following:
indicates there may possibly be multiple entries with the same field name. Is this in postgresql or something else? Like I said, not an expert and that was a 15 second web search. Happy if someone else proves me wrong.
