Activity for board fails to load, errors in log.

[DrekiDegga]

How to use GitHub

• Please use the 👍 reaction to show that you are affected by the same issue.
• Please don't comment if you have no relevant information to add. It's just extra noise for everyone subscribed to this issue.
• Subscribe to receive notifications on status change and new comments.

Describe the bug A clear and concise description of what the bug is.

To Reproduce Steps to reproduce the behavior:

1. Have a Deck with active cards
2. make changes to cards
3. try to view activity either from the activity app>all activities or view activity from the deck details>activity tab in Deck app

Expected behavior The Nextcloud Activity app should show all activities, including Deck activities

Or

The Deck details>activity tab should show deck related activities

Screenshots If applicable, add screenshots to help explain your problem.

Client details:

• OS: Debian 11
• Browser Firefox
• Version 115.7.0esr (64-bit)
• Device: Laptop

Server details

Operating system: Debian 12

Web server: Apache2

Database: MariaDB

PHP version: PHP 8.2.7

Nextcloud version: 27.1.6

Where did you install Nextcloud from: originally installed several years ago by downloading from the nextcloud website. kept up to date over the years including migrating to new Webserver and Database server when the old Debian webserver went EOL last year.

Signing status:

No errors have been found.

**List of activated apps:**

Enabled:
  - activity: 2.19.0
  - admin_audit: 1.17.0
  - breezedark: 27.0.0
  - bruteforcesettings: 2.7.0
  - calendar: 4.6.4
  - checksum: 1.2.3
  - cloud_federation_api: 1.10.0
  - comments: 1.17.0
  - contacts: 5.5.1
  - contactsinteraction: 1.8.0
  - cospend: 1.6.0
  - dashboard: 7.7.0
  - dav: 1.27.0
  - deck: 1.11.3
  - federatedfilesharing: 1.17.0
  - federation: 1.17.0
  - files: 1.22.0
  - files_external: 1.19.0
  - files_pdfviewer: 2.8.0
  - files_reminders: 1.0.0
  - files_rightclick: 1.6.0
  - files_sharing: 1.19.0
  - files_trashbin: 1.17.0
  - files_versions: 1.20.0
  - firstrunwizard: 2.16.0
  - impersonate: 1.14.0
  - integration_onedrive: 3.1.0
  - logreader: 2.12.0
  - lookup_server_connector: 1.15.0
  - mail: 3.5.5
  - metadata: 0.19.0
  - news: 24.0.0
  - nextcloud_announcements: 1.16.0
  - notes: 4.9.2
  - notifications: 2.15.0
  - oauth2: 1.15.2
  - password_policy: 1.17.0
  - passwords: 2023.12.32
  - photos: 2.3.0
  - previewgenerator: 5.4.0
  - privacy: 1.11.0
  - provisioning_api: 1.17.0
  - recommendations: 1.6.0
  - related_resources: 1.2.0
  - serverinfo: 1.17.0
  - settings: 1.9.0
  - sharebymail: 1.17.0
  - side_menu: 3.11.5
  - spreed: 17.1.5
  - support: 1.10.0
  - survey_client: 1.15.0
  - suspicious_login: 5.0.0
  - systemtags: 1.17.0
  - tasks: 0.15.0
  - text: 3.8.0
  - theming: 2.2.0
  - twofactor_admin: 4.4.0
  - twofactor_backupcodes: 1.16.0
  - twofactor_nextcloud_notification: 3.8.0
  - twofactor_totp: 9.0.0
  - updatenotification: 1.17.0
  - user_status: 1.7.0
  - viewer: 2.1.0
  - weather_status: 1.7.0
  - workflowengine: 2.9.0
Disabled:
  - circles: 27.0.1 (installed 0.17.10)
  - encryption: 2.15.0
  - libresign: 7.1.1 (installed 7.1.1)
  - registration: 2.2.0 (installed 2.2.0)
  - user_ldap: 1.17.0

**Nextcloud configuration:**

{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "1.degga.net",
            "www.degga.net",
            "degga.net"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "overwrite.cli.url": "https:\/\/1.degga.net",
        "dbtype": "mysql",
        "version": "27.1.6.2",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "logtimezone": "UTC",
        "installed": true,
        "default_phone_region": "US",
        "mail_smtpmode": "sendmail",
        "mail_smtpauthtype": "LOGIN",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "loglevel": 0,
        "memcache.local": "\\OC\\Memcache\\APCu",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 0,
            "dbindex": 0,
            "timeout": 1.5
        },
        "filelocking.enabled": "true",
        "htaccess.RewriteBase": "\/",
        "appstore.experimental.enabled": true,
        "maintenance": false,
        "theme": "",
        "has_rebuilt_cache": true,
        "mail_sendmailmode": "smtp",
        "simpleSignUpLink.shown": false,
        "twofactor_enforced": "true",
        "twofactor_enforced_groups": [
            "admin",
            "registered",
            "Users"
        ],
        "twofactor_enforced_excluded_groups": [],
        "mysql.utf8mb4": true,
        "updater.release.channel": "stable",
        "enforce_theme": "",
        "updater.secret": "***REMOVED SENSITIVE VALUE***"
    }
}

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/... No.

Logs

Nextcloud log (data/nextcloud.log)

[no app in context] Error: OCP\AppFramework\Db\DoesNotExistException: Did expect one result but found none when executing: query "SELECT * FROM `*PREFIX*deck_cards` WHERE `id` = :dcValue1 ORDER BY `order` ASC, `id` ASC";  at <<closure>>

 0. /var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php line 361
    OCP\AppFramework\Db\QBMapper->findOneQuery()
 1. /var/www/nextcloud/apps/deck/lib/Db/CardMapper.php line 141
    OCP\AppFramework\Db\QBMapper->findEntity()
 2. /var/www/nextcloud/apps/deck/lib/Service/PermissionService.php line 164
    OCA\Deck\Db\CardMapper->find()
 3. /var/www/nextcloud/apps/deck/lib/Activity/ActivityManager.php line 561
    OCA\Deck\Service\PermissionService->checkPermission()
 4. /var/www/nextcloud/apps/deck/lib/Activity/DeckProvider.php line 131
    OCA\Deck\Activity\ActivityManager->canSeeCardActivity()
 5. /var/www/nextcloud/apps/activity/lib/GroupHelper.php line 86
    OCA\Deck\Activity\DeckProvider->parse()
 6. /var/www/nextcloud/apps/activity/lib/Data.php line 260
    OCA\Activity\GroupHelper->addActivity()
 7. /var/www/nextcloud/apps/activity/lib/Controller/APIv2Controller.php line 239
    OCA\Activity\Data->get()
 8. /var/www/nextcloud/apps/activity/lib/Controller/APIv2Controller.php line 186
    OCA\Activity\Controller\APIv2Controller->get()
 9. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 230
    OCA\Activity\Controller\APIv2Controller->getFilter()
10. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 137
    OC\AppFramework\Http\Dispatcher->executeController()
11. /var/www/nextcloud/lib/private/AppFramework/App.php line 183
    OC\AppFramework\Http\Dispatcher->dispatch()
12. /var/www/nextcloud/lib/private/Route/Router.php line 315
    OC\AppFramework\App::main()
13. /var/www/nextcloud/ocs/v1.php line 65
    OC\Route\Router->match()
14. /var/www/nextcloud/ocs/v2.php line 23
    require_once("/var/www/nextcloud/ocs/v1.php")

GET /ocs/v2.php/apps/activity/api/v2/activity/deck?format=json&type=deck&since=0&object_type=deck&object_id=6&limit=50
from 192.249.1.169 by Dreki at 2024-02-12T01:49:48+00:00

Browser log

Insert your browser log here, this could for example include:

a) The javascript console log
b) The network log
c) ...