Agenda doesn't work !?

ℹ️ Support
1

Hello
The issue you are facing:
When I go on the Agenda, the server say he lost the connection and there is the wheel turning and I couldn’t do anything. I know it is a setup but I could found where. Thanks for your help, regards
Sylvain
:slightly_frowning_face:

2

nextcloud.log entries?

NC version?

3

NC Version 26.0.1

and the log you mean this
no app in context OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: oc_user_status.user_id

  1. /home/lfus2006/next.cyberfenua.eu/lib/private/DB/QueryBuilder/QueryBuilder.php - line 328:OC\DB\Exceptions\DbalException::wrap([ "Doctrine\ … "])
  2. /home/lfus2006/next.cyberfenua.eu/lib/public/AppFramework/Db/QBMapper.php - line 138:OC\DB\QueryBuilder\QueryBuilder->executeStatement()
  3. /home/lfus2006/next.cyberfenua.eu/apps/user_status/lib/Listener/UserLiveStatusListener.php - line 104:OCP\AppFramework\Db\QBMapper->insert([ "OCA\User … l])
  4. /home/lfus2006/next.cyberfenua.eu/lib/private/EventDispatcher/ServiceEventListener.php - line 86:OCA\UserStatus\Listener\UserLiveStatusListener->handle([ "OCP\User … "])
  5. /home/lfus2006/next.cyberfenua.eu/3rdparty/symfony/event-dispatcher/EventDispatcher.php - line 251:OC\EventDispatcher\ServiceEventListener->__invoke([ "OCP\User … "], “OCP\User\ … t”, [ "Symfony\ … "])
  6. /home/lfus2006/next.cyberfenua.eu/3rdparty/symfony/event-dispatcher/EventDispatcher.php - line 73:Symfony\Component\EventDispatcher\EventDispatcher->callListeners([ [ “Closure”]], “OCP\User\ … t”, [ "OCP\User … "])
  7. /home/lfus2006/next.cyberfenua.eu/lib/private/EventDispatcher/EventDispatcher.php - line 87:Symfony\Component\EventDispatcher\EventDispatcher->dispatch([ "OCP\User … "], “OCP\User\ … t”)
  8. /home/lfus2006/next.cyberfenua.eu/lib/private/EventDispatcher/EventDispatcher.php - line 99:OC\EventDispatcher\EventDispatcher->dispatch(“OCP\User\ … t”, [ "OCP\User … "])
  9. /home/lfus2006/next.cyberfenua.eu/apps/user_status/lib/Controller/HeartbeatController.php - line 91:OC\EventDispatcher\EventDispatcher->dispatchTyped([ "OCP\User … "])
  10. /home/lfus2006/next.cyberfenua.eu/lib/private/AppFramework/Http/Dispatcher.php - line 230:OCA\UserStatus\Controller\HeartbeatController->heartbeat(“online”)
  11. /home/lfus2006/next.cyberfenua.eu/lib/private/AppFramework/Http/Dispatcher.php - line 137:OC\AppFramework\Http\Dispatcher->executeController([ "OCA\User … "], “heartbeat”)
  12. /home/lfus2006/next.cyberfenua.eu/lib/private/AppFramework/App.php - line 183:OC\AppFramework\Http\Dispatcher->dispatch([ "OCA\User … "], “heartbeat”)
  13. /home/lfus2006/next.cyberfenua.eu/lib/private/Route/Router.php - line 315:OC\AppFramework\App::main(“OCA\UserSt … r”, “heartbeat”, [ "OC\AppFr … "], [ "ocs.user_ … "])
  14. /home/lfus2006/next.cyberfenua.eu/ocs/v1.php - line 64:OC\Route\Router->match(“/ocsapp/app … t”)
  15. /home/lfus2006/next.cyberfenua.eu/ocs/v2.php - line 23:require_once(“/home/lfus2 … p”)

Causé par Doctrine\DBAL\Exception\UniqueConstraintViolationException: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: oc_user_status.user_id

  1. /home/lfus2006/next.cyberfenua.eu/3rdparty/doctrine/dbal/src/Connection.php - line 1814:Doctrine\DBAL\Driver\API\SQLite\ExceptionConverter->convert([ "Doctrine\ … "], [ “Doctrine\DBAL\Query”])
  2. /home/lfus2006/next.cyberfenua.eu/3rdparty/doctrine/dbal/src/Connection.php - line 1749:Doctrine\DBAL\Connection->handleDriverException([ "Doctrine\ … "], [ “Doctrine\DBAL\Query”])
  3. /home/lfus2006/next.cyberfenua.eu/3rdparty/doctrine/dbal/src/Connection.php - line 1163:Doctrine\DBAL\Connection->convertExceptionDuringQuery([ "Doctrine\ … "], “INSERT INTO … )”, [ "NextAdmin … e], [ 2,2,1,5])
  4. /home/lfus2006/next.cyberfenua.eu/lib/private/DB/Connection.php - line 297:Doctrine\DBAL\Connection->executeStatement(“INSERT INTO … )”, [ "NextAdmin … e], [ 2,2,1,5])
  5. /home/lfus2006/next.cyberfenua.eu/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 354:OC\DB\Connection->executeStatement(“INSERT INTO … )”, [ "NextAdmin … e], [ 2,2,1,5])
  6. /home/lfus2006/next.cyberfenua.eu/lib/private/DB/QueryBuilder/QueryBuilder.php - line 280:Doctrine\DBAL\Query\QueryBuilder->execute()
  7. /home/lfus2006/next.cyberfenua.eu/lib/private/DB/QueryBuilder/QueryBuilder.php - line 326:OC\DB\QueryBuilder\QueryBuilder->execute()
  8. /home/lfus2006/next.cyberfenua.eu/lib/public/AppFramework/Db/QBMapper.php - line 138:OC\DB\QueryBuilder\QueryBuilder->executeStatement()
  9. /home/lfus2006/next.cyberfenua.eu/apps/user_status/lib/Listener/UserLiveStatusListener.php - line 104:OCP\AppFramework\Db\QBMapper->insert([ "OCA\User … l])
  10. /home/lfus2006/next.cyberfenua.eu/lib/private/EventDispatcher/ServiceEventListener.php - line 86:OCA\UserStatus\Listener\UserLiveStatusListener->handle([ "OCP\User … "])
  11. /home/lfus2006/next.cyberfenua.eu/3rdparty/symfony/event-dispatcher/EventDispatcher.php - line 251:OC\EventDispatcher\ServiceEventListener->__invoke([ "OCP\User … "], “OCP\User\ … t”, [ "Symfony\ … "])
  12. /home/lfus2006/next.cyberfenua.eu/3rdparty/symfony/event-dispatcher/EventDispatcher.php - line 73:Symfony\Component\EventDispatcher\EventDispatcher->callListeners([ [ “Closure”]], “OCP\User\ … t”, [ "OCP\User … "])
  13. /home/lfus2006/next.cyberfenua.eu/lib/private/EventDispatcher/EventDispatcher.php - line 87:Symfony\Component\EventDispatcher\EventDispatcher->dispatch([ "OCP\User … "], “OCP\User\ … t”)
  14. /home/lfus2006/next.cyberfenua.eu/lib/private/EventDispatcher/EventDispatcher.php - line 99:OC\EventDispatcher\EventDispatcher->dispatch(“OCP\User\ … t”, [ "OCP\User … "])
  15. /home/lfus2006/next.cyberfenua.eu/apps/user_status/lib/Controller/HeartbeatController.php - line 91:OC\EventDispatcher\EventDispatcher->dispatchTyped([ "OCP\User … "])
  16. /home/lfus2006/next.cyberfenua.eu/lib/private/AppFramework/Http/Dispatcher.php - line 230:OCA\UserStatus\Controller\HeartbeatController->heartbeat(“online”)
  17. /home/lfus2006/next.cyberfenua.eu/lib/private/AppFramework/Http/Dispatcher.php - line 137:OC\AppFramework\Http\Dispatcher->executeController([ "OCA\User … "], “heartbeat”)
  18. /home/lfus2006/next.cyberfenua.eu/lib/private/AppFramework/App.php - line 183:OC\AppFramework\Http\Dispatcher->dispatch([ "OCA\User … "], “heartbeat”)
  19. /home/lfus2006/next.cyberfenua.eu/lib/private/Route/Router.php - line 315:OC\AppFramework\App::main(“OCA\UserSt … r”, “heartbeat”, [ "OC\AppFr … "], [ "ocs.user_ … "])
  20. /home/lfus2006/next.cyberfenua.eu/ocs/v1.php - line 64:OC\Route\Router->match(“/ocsapp/app … t”)
  21. /home/lfus2006/next.cyberfenua.eu/ocs/v2.php - line 23:require_once(“/home/lfus2 … p”)

Causé par Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: oc_user_status.user_id

  1. /home/lfus2006/next.cyberfenua.eu/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php - line 103:Doctrine\DBAL\Driver\PDO\Exception::new([ "PDOExcept … ]])
  2. /home/lfus2006/next.cyberfenua.eu/3rdparty/doctrine/dbal/src/Connection.php - line 1153:Doctrine\DBAL\Driver\PDO\Statement->execute()
  3. /home/lfus2006/next.cyberfenua.eu/lib/private/DB/Connection.php - line 297:Doctrine\DBAL\Connection->executeStatement(“INSERT INTO … )”, [ "NextAdmin … e], [ 2,2,1,5])
  4. /home/lfus2006/next.cyberfenua.eu/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 354:OC\DB\Connection->executeStatement(“INSERT INTO … )”, [ "NextAdmin … e], [ 2,2,1,5])
  5. /home/lfus2006/next.cyberfenua.eu/lib/private/DB/QueryBuilder/QueryBuilder.php - line 280:Doctrine\DBAL\Query\QueryBuilder->execute()
  6. /home/lfus2006/next.cyberfenua.eu/lib/private/DB/QueryBuilder/QueryBuilder.php - line 326:OC\DB\QueryBuilder\QueryBuilder->execute()
  7. /home/lfus2006/next.cyberfenua.eu/lib/public/AppFramework/Db/QBMapper.php - line 138:OC\DB\QueryBuilder\QueryBuilder->executeStatement()
  8. /home/lfus2006/next.cyberfenua.eu/apps/user_status/lib/Listener/UserLiveStatusListener.php - line 104:OCP\AppFramework\Db\QBMapper->insert([ "OCA\User … l])
  9. /home/lfus2006/next.cyberfenua.eu/lib/private/EventDispatcher/ServiceEventListener.php - line 86:OCA\UserStatus\Listener\UserLiveStatusListener->handle([ "OCP\User … "])
  10. /home/lfus2006/next.cyberfenua.eu/3rdparty/symfony/event-dispatcher/EventDispatcher.php - line 251:OC\EventDispatcher\ServiceEventListener->__invoke([ "OCP\User … "], “OCP\User\ … t”, [ "Symfony\ … "])
  11. /home/lfus2006/next.cyberfenua.eu/3rdparty/symfony/event-dispatcher/EventDispatcher.php - line 73:Symfony\Component\EventDispatcher\EventDispatcher->callListeners([ [ “Closure”]], “OCP\User\ … t”, [ "OCP\User … "])
  12. /home/lfus2006/next.cyberfenua.eu/lib/private/EventDispatcher/EventDispatcher.php - line 87:Symfony\Component\EventDispatcher\EventDispatcher->dispatch([ "OCP\User … "], “OCP\User\ … t”)
  13. /home/lfus2006/next.cyberfenua.eu/lib/private/EventDispatcher/EventDispatcher.php - line 99:OC\EventDispatcher\EventDispatcher->dispatch(“OCP\User\ … t”, [ "OCP\User … "])
  14. /home/lfus2006/next.cyberfenua.eu/apps/user_status/lib/Controller/HeartbeatController.php - line 91:OC\EventDispatcher\EventDispatcher->dispatchTyped([ "OCP\User … "])
  15. /home/lfus2006/next.cyberfenua.eu/lib/private/AppFramework/Http/Dispatcher.php - line 230:OCA\UserStatus\Controller\HeartbeatController->heartbeat(“online”)
  16. /home/lfus2006/next.cyberfenua.eu/lib/private/AppFramework/Http/Dispatcher.php - line 137:OC\AppFramework\Http\Dispatcher->executeController([ "OCA\User … "], “heartbeat”)
  17. /home/lfus2006/next.cyberfenua.eu/lib/private/AppFramework/App.php - line 183:OC\AppFramework\Http\Dispatcher->dispatch([ "OCA\User … "], “heartbeat”)
  18. /home/lfus2006/next.cyberfenua.eu/lib/private/Route/Router.php - line 315:OC\AppFramework\App::main(“OCA\UserSt … r”, “heartbeat”, [ "OC\AppFr … "], [ "ocs.user_ … "])
  19. /home/lfus2006/next.cyberfenua.eu/ocs/v1.php - line 64:OC\Route\Router->match(“/ocsapp/app … t”)
  20. /home/lfus2006/next.cyberfenua.eu/ocs/v2.php - line 23:require_once(“/home/lfus2 … p”)

Causé par PDOException: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: oc_user_status.user_id

  1. /home/lfus2006/next.cyberfenua.eu/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php - line 101:PDOStatement->execute(null)
  2. /home/lfus2006/next.cyberfenua.eu/3rdparty/doctrine/dbal/src/Connection.php - line 1153:Doctrine\DBAL\Driver\PDO\Statement->execute()
  3. /home/lfus2006/next.cyberfenua.eu/lib/private/DB/Connection.php - line 297:Doctrine\DBAL\Connection->executeStatement(“INSERT INTO … )”, [ "NextAdmin … e], [ 2,2,1,5])
  4. /home/lfus2006/next.cyberfenua.eu/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 354:OC\DB\Connection->executeStatement(“INSERT INTO … )”, [ "NextAdmin … e], [ 2,2,1,5])
  5. /home/lfus2006/next.cyberfenua.eu/lib/private/DB/QueryBuilder/QueryBuilder.php - line 280:Doctrine\DBAL\Query\QueryBuilder->execute()
  6. /home/lfus2006/next.cyberfenua.eu/lib/private/DB/QueryBuilder/QueryBuilder.php - line 326:OC\DB\QueryBuilder\QueryBuilder->execute()
  7. /home/lfus2006/next.cyberfenua.eu/lib/public/AppFramework/Db/QBMapper.php - line 138:OC\DB\QueryBuilder\QueryBuilder->executeStatement()
  8. /home/lfus2006/next.cyberfenua.eu/apps/user_status/lib/Listener/UserLiveStatusListener.php - line 104:OCP\AppFramework\Db\QBMapper->insert([ "OCA\User … l])
  9. /home/lfus2006/next.cyberfenua.eu/lib/private/EventDispatcher/ServiceEventListener.php - line 86:OCA\UserStatus\Listener\UserLiveStatusListener->handle([ "OCP\User … "])
  10. /home/lfus2006/next.cyberfenua.eu/3rdparty/symfony/event-dispatcher/EventDispatcher.php - line 251:OC\EventDispatcher\ServiceEventListener->__invoke([ "OCP\User … "], “OCP\User\ … t”, [ "Symfony\ … "])
  11. /home/lfus2006/next.cyberfenua.eu/3rdparty/symfony/event-dispatcher/EventDispatcher.php - line 73:Symfony\Component\EventDispatcher\EventDispatcher->callListeners([ [ “Closure”]], “OCP\User\ … t”, [ "OCP\User … "])
  12. /home/lfus2006/next.cyberfenua.eu/lib/private/EventDispatcher/EventDispatcher.php - line 87:Symfony\Component\EventDispatcher\EventDispatcher->dispatch([ "OCP\User … "], “OCP\User\ … t”)
  13. /home/lfus2006/next.cyberfenua.eu/lib/private/EventDispatcher/EventDispatcher.php - line 99:OC\EventDispatcher\EventDispatcher->dispatch(“OCP\User\ … t”, [ "OCP\User … "])
  14. /home/lfus2006/next.cyberfenua.eu/apps/user_status/lib/Controller/HeartbeatController.php - line 91:OC\EventDispatcher\EventDispatcher->dispatchTyped([ "OCP\User … "])
  15. /home/lfus2006/next.cyberfenua.eu/lib/private/AppFramework/Http/Dispatcher.php - line 230:OCA\UserStatus\Controller\HeartbeatController->heartbeat(“online”)
  16. /home/lfus2006/next.cyberfenua.eu/lib/private/AppFramework/Http/Dispatcher.php - line 137:OC\AppFramework\Http\Dispatcher->executeController([ "OCA\User … "], “heartbeat”)
  17. /home/lfus2006/next.cyberfenua.eu/lib/private/AppFramework/App.php - line 183:OC\AppFramework\Http\Dispatcher->dispatch([ "OCA\User … "], “heartbeat”)
  18. /home/lfus2006/next.cyberfenua.eu/lib/private/Route/Router.php - line 315:OC\AppFramework\App::main(“OCA\UserSt … r”, “heartbeat”, [ "OC\AppFr … "], [ "ocs.user_ … "])
  19. /home/lfus2006/next.cyberfenua.eu/ocs/v1.php - line 64:OC\Route\Router->match(“/ocsapp/app … t”)
  20. /home/lfus2006/next.cyberfenua.eu/ocs/v2.php - line 23:require_once(“/home/lfus2 … p”)