Files not show in Deck 1.12.1

[damienvidalcabm]

Hello,

I just passed the DECK update 1.12.1.
Since then, users can no longer view files as attachments.

Version : Nextcloud 28.0.1
PHP : 8.1.27
DB : MariaDB 10.6.8 LTS

Thx,

[juliusknorr]

Can you please fill out the issue template to provide logs and more detailed description on what does not work, where in the UI, what do you see? I cannot see any issue here with attachments

[damienvidalcabm]

With my "root" profile, I can see the attachments well.

But my colleague can't see anything, it's empty.
She is also rooting Nextcloud.

[damienvidalcabm]

My colleague

Me

[damienvidalcabm]

[damienvidalcabm]

Exception during scan: Did expect one result but found none when executing: query "SELECT * FROM *PREFIX*deck_boards WHERE (id = :dcValue2) AND (deleted_at = :dcValue1) ORDER BY id ASC";
#0 /var/www/html/nextcloud/lib/public/AppFramework/Db/QBMapper.php(361): OCP\AppFramework\Db\QBMapper->findOneQuery()
#1 /var/www/html/nextcloud/apps/deck/lib/Db/BoardMapper.php(92): OCP\AppFramework\Db\QBMapper->findEntity()
#2 /var/www/html/nextcloud/apps/deck/lib/Service/PermissionService.php(199): OCA\Deck\Db\BoardMapper->find()
#3 /var/www/html/nextcloud/apps/deck/lib/Service/PermissionService.php(111): OCA\Deck\Service\PermissionService->getBoard()
#4 /var/www/html/nextcloud/apps/deck/lib/Service/PermissionService.php(160): OCA\Deck\Service\PermissionService->getPermissions()
#5 /var/www/html/nextcloud/apps/deck/lib/Sharing/DeckShareProvider.php(289): OCA\Deck\Service\PermissionService->checkPermission()
#6 /var/www/html/nextcloud/apps/deck/lib/Sharing/DeckShareProvider.php(668): OCA\Deck\Sharing\DeckShareProvider->applyBoardPermission()
#7 /var/www/html/nextcloud/apps/deck/lib/Sharing/DeckShareProvider.php(780): OCA\Deck\Sharing\DeckShareProvider->resolveSharesForRecipient()
#8 /var/www/html/nextcloud/lib/private/Share20/Manager.php(1399): OCA\Deck\Sharing\DeckShareProvider->getSharedWith()
#9 /var/www/html/nextcloud/apps/files_sharing/lib/MountProvider.php(71): OC\Share20\Manager->getSharedWith()
#10 /var/www/html/nextcloud/lib/private/Files/Config/MountProviderCollection.php(89): OCA\Files_Sharing\MountProvider->getMountsForUser()
#11 /var/www/html/nextcloud/lib/private/Files/Config/MountProviderCollection.php(146): OC\Files\Config\MountProviderCollection->getMountsFromProvider()
#12 /var/www/html/nextcloud/lib/private/Files/SetupManager.php(219): OC\Files\Config\MountProviderCollection->addMountForUser()
#13 /var/www/html/nextcloud/lib/private/Files/SetupManager.php(318): OC\Files\SetupManager->OC\Files{closure}()
#14 /var/www/html/nextcloud/lib/private/Files/SetupManager.php(220): OC\Files\SetupManager->setupForUserWith()
#15 /var/www/html/nextcloud/lib/private/legacy/OC_Util.php(110): OC\Files\SetupManager->setupForUser()
#16 /var/www/html/nextcloud/lib/private/Files/Utils/Scanner.php(115): OC_Util::setupFS()
#17 /var/www/html/nextcloud/lib/private/Files/Utils/Scanner.php(200): OC\Files\Utils\Scanner->getMounts()
#18 /var/www/html/nextcloud/apps/files/lib/Command/Scan.php(180): OC\Files\Utils\Scanner->scan()
#19 /var/www/html/nextcloud/apps/files/lib/Command/Scan.php(241): OCA\Files\Command\Scan->scanFiles()
#20 /var/www/html/nextcloud/3rdparty/symfony/console/Command/Command.php(298): OCA\Files\Command\Scan->execute()
#21 /var/www/html/nextcloud/core/Command/Base.php(177): Symfony\Component\Console\Command\Command->run()
#22 /var/www/html/nextcloud/3rdparty/symfony/console/Application.php(1040): OC\Core\Command\Base->run()
#23 /var/www/html/nextcloud/3rdparty/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#24 /var/www/html/nextcloud/3rdparty/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#25 /var/www/html/nextcloud/lib/private/Console/Application.php(206): Symfony\Component\Console\Application->run()
#26 /var/www/html/nextcloud/console.php(100): OC\Console\Application->run()
#27 /var/www/html/nextcloud/occ(11): require_once('...')
#28 {main}

[apg1980]

the activity feed is broken as well if the latest deck app is enabled, can you confirm this?
i had to disable deck until its fixed on nextcloud 28.0.1

[damienvidalcabm]

Hello APG,
The activity feed is active.
The deck was working until I passed the last update.
But that only impacts my colleague.
I think I'm going to delete his Nextcloud account and create a new one for him.
She only uses the Deck mainly, by putting the right rights on it, it should work for her again.
thx,

[apg1980]

everytime i open activity i logg this:
{"reqId":"66Sho5GALUzZdNpk4p7P","level":3,"time":"2024-01-19T10:31:03+01:00","remoteAddr":"xxxxxx","user":"xxx","app":"no app in context","method":"GET","url":"/ocs/v2.php/apps/activity/api/v2/activity/all?format=json&previews=true&since=0","message":"Exception thrown: OCP\\AppFramework\\Db\\DoesNotExistException","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36","version":"28.0.1.1","exception":{"Exception":"OCP\\AppFramework\\Db\\DoesNotExistException","Message":"Did expect one result but found none when executing: query \"SELECT * FROM PREFIXdeck_boards WHERE (id = :dcValue2) AND (deleted_at= :dcValue1) ORDER BYid ASC\"; ","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":361,"function":"findOneQuery","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/nextcloud/apps/deck/lib/Db/BoardMapper.php","line":92,"function":"findEntity","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/nextcloud/apps/deck/lib/Service/PermissionService.php","line":199,"function":"find","class":"OCA\\Deck\\Db\\BoardMapper","type":"->"},{"file":"/var/www/nextcloud/apps/deck/lib/Service/PermissionService.php","line":111,"function":"getBoard","class":"OCA\\Deck\\Service\\PermissionService","type":"->"},{"file":"/var/www/nextcloud/apps/deck/lib/Service/PermissionService.php","line":160,"function":"getPermissions","class":"OCA\\Deck\\Service\\PermissionService","type":"->"},{"file":"/var/www/nextcloud/apps/deck/lib/Activity/ActivityManager.php","line":581,"function":"checkPermission","class":"OCA\\Deck\\Service\\PermissionService","type":"->"},{"file":"/var/www/nextcloud/apps/deck/lib/Activity/DeckProvider.php","line":114,"function":"canSeeBoardActivity","class":"OCA\\Deck\\Activity\\ActivityManager","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/GroupHelper.php","line":70,"function":"parse","class":"OCA\\Deck\\Activity\\DeckProvider","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/Data.php","line":248,"function":"addActivity","class":"OCA\\Activity\\GroupHelper","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/Controller/APIv2Controller.php","line":205,"function":"get","class":"OCA\\Activity\\Data","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/Controller/APIv2Controller.php","line":152,"function":"get","class":"OCA\\Activity\\Controller\\APIv2Controller","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":230,"function":"getFilter","class":"OCA\\Activity\\Controller\\APIv2Controller","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":137,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/ocs/v1.php","line":65,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/ocs/v2.php","line":23,"args":["/var/www/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","Line":283,"CustomMessage":"Exception thrown: OCP\\AppFramework\\Db\\DoesNotExistException"},"id":"65aa416bccd61"}

[sptcguy]

After deleting a deck board I have the same error coming up in my logs:

Did expect one result but found none when executing: query "SELECT * FROM PREFIXdeck_boards WHERE (id = :dcValue2) AND (deleted_at= :dcValue1) ORDER BYid ASC"

I also have to disable the deck app otherwise I get internal server errors when trying to use other apps.

[sptcguy]

I fixed the 500 issue by running DELETE FROM oc_deck_boards WHERE deleted_at <> 0; However my activity feed is still not working and I am still seeing the error above.

[mejo-]

I just ran into the same issue by deleting a board via the Deck Android app. My whole Nextcloud was broken afterwards for this particular user - every request resulted in the following exception. Only running DELETE FROM oc_deck_boards WHERE deleted_at != 0 fixed it for me.

It was on Nextcloud 27.1.6 with the latest Deck release.

Exception trace

{"Exception":"OCP\\AppFramework\\Db\\DoesNotExistException","Message":"Did expect one result but found none when executing: query \\"SELECT * FROM `*PREFIX*deck_boards` WHERE (`id` = :dcValue2) AND (`deleted_at` = :dcValue1) ORDER BY `id` ASC\\"; ","Code":0,"Trace":[{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/lib/public/AppFramework/Db/QBMapper.php","line":361,"function":"findOneQuery","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/apps/deck/lib/Db/BoardMapper.php","line":92,"function":"findEntity","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/apps/deck/lib/Service/PermissionService.php","line":199,"function":"find","class":"OCA\\Deck\\Db\\BoardMapper","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/apps/deck/lib/Service/PermissionService.php","line":111,"function":"getBoard","class":"OCA\\Deck\\Service\\PermissionService","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/apps/deck/lib/Service/PermissionService.php","line":160,"function":"getPermissions","class":"OCA\\Deck\\Service\\PermissionService","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/apps/deck/lib/Sharing/DeckShareProvider.php","line":289,"function":"checkPermission","class":"OCA\\Deck\\Service\\PermissionService","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/apps/deck/lib/Sharing/DeckShareProvider.php","line":668,"function":"applyBoardPermission","class":"OCA\\Deck\\Sharing\\DeckShareProvider","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/apps/deck/lib/Sharing/DeckShareProvider.php","line":780,"function":"resolveSharesForRecipient","class":"OCA\\Deck\\Sharing\\DeckShareProvider","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/lib/private/Share20/Manager.php","line":1408,"function":"getSharedWith","class":"OCA\\Deck\\Sharing\\DeckShareProvider","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/apps/files_sharing/lib/MountProvider.php","line":99,"function":"getSharedWith","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/lib/private/Files/Config/MountProviderCollection.php","line":89,"function":"getMountsForUser","class":"OCA\\Files_Sharing\\MountProvider","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/lib/private/Files/Config/MountProviderCollection.php","line":146,"function":"getMountsFromProvider","class":"OC\\Files\\Config\\MountProviderCollection","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/lib/private/Files/SetupManager.php","line":215,"function":"addMountForUser","class":"OC\\Files\\Config\\MountProviderCollection","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/lib/private/Files/SetupManager.php","line":318,"function":"OC\\Files\\{closure}","class":"OC\\Files\\SetupManager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/lib/private/Files/SetupManager.php","line":214,"function":"setupForUserWith","class":"OC\\Files\\SetupManager","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/lib/private/Files/SetupManager.php","line":392,"function":"setupForUser","class":"OC\\Files\\SetupManager","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/lib/private/Files/Mount/Manager.php","line":97,"function":"setupForPath","class":"OC\\Files\\SetupManager","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/lib/private/Files/View.php","line":1370,"function":"find","class":"OC\\Files\\Mount\\Manager","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/lib/private/Files/Node/Root.php","line":202,"function":"getFileInfo","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/lib/private/Files/Node/LazyUserFolder.php","line":74,"function":"get","class":"OC\\Files\\Node\\Root","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/apps/spreed/lib/TInitialState.php","line":151,"function":"get","class":"OC\\Files\\Node\\LazyUserFolder","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/apps/spreed/lib/Files/TemplateLoader.php","line":112,"function":"publishInitialStateForUser","class":"OCA\\Talk\\Files\\TemplateLoader","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/lib/private/EventDispatcher/ServiceEventListener.php","line":86,"function":"handle","class":"OCA\\Talk\\Files\\TemplateLoader","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":251,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":73,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/lib/private/EventDispatcher/EventDispatcher.php","line":94,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/lib/private/EventDispatcher/EventDispatcher.php","line":106,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/apps/dashboard/lib/Controller/DashboardController.php","line":85,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/lib/private/AppFramework/Http/Dispatcher.php","line":230,"function":"index","class":"OCA\\Dashboard\\Controller\\DashboardController","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/lib/private/AppFramework/Http/Dispatcher.php","line":137,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/lib/private/AppFramework/App.php","line":183,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"0:0:0:0:0:0:0:0"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/lib/base.php","line":1068,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/cloud.example.org/nextcloud-27.1.6/index.php","line":38,"function":"handleRequest","class":"OC","type":"0:0:0:0:0:0:0:0"}],"File":"/var/www/cloud.example.org/nextcloud-27.1.6/lib/public/AppFramework/Db/QBMapper.php","Line":283,"CustomMessage":"Exception thrown: OCP\\AppFramework\\Db\\DoesNotExistException"}