Activity log not updating

Self-Hosted | v5
1

Version ie <v5.10.30>

v5.10.31-M171

Environment <Docker/Shared Hosting/Zip/Other>

Checklist

  • Can you replicate the issue on our v5 demo site https://demo.invoiceninja.com or Invoice Ninja? No
  • Have you searched existing issues? Yes
  • Have you inspected the logs in storage/logs/laravel.log for any errors? Yes

Describe the bug

Ever since updating v5.10.30 and v5.10.31, the Activity log is not showing anything recent. I have tried making a new demo company, and the issue persists. I am not able to replicate this on the demo site, and have included my logs below.

I have followed this thread to hopefully alleviate the algolia issue.

Logs

[2024-10-05 21:28:41] production.ERROR: Please install the suggested Algolia client: algolia/algoliasearch-client-php. {"exception":"[object] (Exception(code: 0): Please install the sug>
[stacktrace]
#0 /var/www/invoiceninja/vendor/laravel/scout/src/EngineManager.php(40): Laravel\\Scout\\EngineManager->ensureAlgoliaClientIsInstalled()
#1 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Support/Manager.php(106): Laravel\\Scout\\EngineManager->createAlgoliaDriver()
#2 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Support/Manager.php(80): Illuminate\\Support\\Manager->createDriver()
#3 /var/www/invoiceninja/vendor/laravel/scout/src/EngineManager.php(30): Illuminate\\Support\\Manager->driver()
#4 /var/www/invoiceninja/vendor/laravel/scout/src/Searchable.php(339): Laravel\\Scout\\EngineManager->engine()
#5 /var/www/invoiceninja/vendor/laravel/scout/src/Jobs/MakeSearchable.php(42): App\\Models\\ClientContact->searchableUsing()
#6 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Laravel\\Scout\\Jobs\\MakeSearchable->handle()
#7 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#8 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()
#9 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#10 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()
#11 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\\Container\\Container->call()
#12 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}()
#13 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#14 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\\Pipeline\\Pipeline->then()
#15 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\\Bus\\Dispatcher->dispatchNow()
#16 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}()
#17 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#18 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(123): Illuminate\\Pipeline\\Pipeline->then()
#19 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(71): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware()
#20 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(102): Illuminate\\Queue\\CallQueuedHandler->call()
#21 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(440): Illuminate\\Queue\\Jobs\\Job->fire()
#22 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(390): Illuminate\\Queue\\Worker->process()
#23 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(177): Illuminate\\Queue\\Worker->runJob()
#24 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(139): Illuminate\\Queue\\Worker->daemon()
#25 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(122): Illuminate\\Queue\\Console\\WorkCommand->runWorker()
#26 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()
#27 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#28 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()
#29 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#30 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()
#31 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()
#32 /var/www/invoiceninja/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()
#33 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()
#34 /var/www/invoiceninja/vendor/symfony/console/Application.php(1047): Illuminate\\Console\\Command->run()
#35 /var/www/invoiceninja/vendor/symfony/console/Application.php(316): Symfony\\Component\\Console\\Application->doRunCommand()
#36 /var/www/invoiceninja/vendor/symfony/console/Application.php(167): Symfony\\Component\\Console\\Application->doRun()
#37 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\\Component\\Console\\Application->run()
#38 /var/www/invoiceninja/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()
#39 {main}

[2024-10-06 23:22:52] production.ERROR: SQLSTATE[HY000] [2002] No such file or directory {"exception":"[object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] No such file or directory at /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:66)
[stacktrace]
#0 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(66): PDO->__construct()
#1 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(85): Illuminate\\Database\\Connectors\\Connector->createPdoConnection()
#2 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(48): Illuminate\\Database\\Connectors\\Connector->tryAgainIfCausedByLostConnection()
#3 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\\Database\\Connectors\\Connector->createConnection()
#4 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(185): Illuminate\\Database\\Connectors\\MySqlConnector->connect()
#5 [internal function]: Illuminate\\Database\\Connectors\\ConnectionFactory->Illuminate\\Database\\Connectors\\{closure}()
#6 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1231): call_user_func()
#7 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(185): Illuminate\\Database\\Connection->getPdo()
#8 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(151): Illuminate\\Database\\Connection->handleBeginTransactionException()
#9 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(125): Illuminate\\Database\\Connection->createTransaction()
#10 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(24): Illuminate\\Database\\Connection->beginTransaction()
#11 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/DatabaseQueue.php(223): Illuminate\\Database\\Connection->transaction()
#12 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(350): Illuminate\\Queue\\DatabaseQueue->pop()
#13 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(364): Illuminate\\Queue\\Worker->Illuminate\\Queue\\{closure}()
#14 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(163): Illuminate\\Queue\\Worker->getNextJob()
#15 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(139): Illuminate\\Queue\\Worker->daemon()
#16 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(122): Illuminate\\Queue\\Console\\WorkCommand->runWorker()
#17 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()
#18 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#19 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()
#20 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#21 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()
#22 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()
#23 /var/www/invoiceninja/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()
#24 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()
#25 /var/www/invoiceninja/vendor/symfony/console/Application.php(1047): Illuminate\\Console\\Command->run()
#26 /var/www/invoiceninja/vendor/symfony/console/Application.php(316): Symfony\\Component\\Console\\Application->doRunCommand()
#27 /var/www/invoiceninja/vendor/symfony/console/Application.php(167): Symfony\\Component\\Console\\Application->doRun()
#28 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\\Component\\Console\\Application->run()
#29 /var/www/invoiceninja/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()
#30 {main}
"}```
2

Hi,

I suggest creating a discussion on GitHub

3

There is a second error in your log - unrelated to the algolia one:

[2024-10-06 23:22:52] production.ERROR: SQLSTATE[HY000] [2002] No such file or directory {“exception”:"[object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] No such file or directo>

4

Hi,
I think the Algolia issue is resolved. However I am still having issues loading activity. It is stuck at last week and hasn’t shown any activities since then.

My apologies for the second error. I have fixed it, but the rest of the line is missing file at :

/var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:66)

5

sounds like your queues are not running ?

6

That is what I was thinking, but there were no errors regarding this in the health check. Additionally, emails were sending out and auto-payments were firing. I am not sure what is going on, but I am in the process of migrating to the hosted version. Hopefully I won’t have to worry much about that going forward. Thanks.

7

I’ve also got this issue. My activity doesn’t show anything beyond 30/July/2024.

I don’t appear to have any errors in the logs.

8

are there any records in the failed_jobs table?

9

No records in the failed_jobs table. Activity on the individual invoice, quote and credit all update. Just not the main activity menu on the main dashboard.

10

are there any failed requests in the browser console ?

11

There does not appear to be anything while viewing on Chrome. I switched to react from flutter, and activity works fine on react. Switching back to flutter, or using the desktop app does not update.

12

perhaps @hillel can advise if this is something impacting the flutter app only.

13

I assume you’re referring to the activity tab on the dashboard?

Do you see the activity if you view a specific client and click the activity tab?

14

@david I’m seeing the same problem in my test account, it looks like the activities array is empty in the /refresh route.

15

Yes, activity is populating at the client level. The activity tab on the dashboard is not reflecting changes.

Thanks

16

Thanks, I’ve tagged a new release.

1 Like