Attachments not linked to card - files are still there

[reox]

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

I found out today that several cards that had attachments are now missing them. One card even shows them in the Android App, but I see only a placeholder thumbnail (all are images).

In the history of each card, I see that I added the attachment, but when I click on the filename, I get a JSON with content {"status":403,"message":"Permission denied"}.

The files that were originally attached are however still in Nextcloud, i.e., in the Deck folder.

I have no idea when this happened - it must have been an update in the past 6 Months though.

Other cards still have attachments - I haven't checked all my cards though, thus I'm not even sure what the pattern is. My only suspicion is, that these are all files I have uploaded via the Deck Android App - but I'm not 100% sure about that.

I checked the oc_deck_attachment table, and I cannot see the files there.

Is there anything else I can check? I might be able to recover backups from some months ago and could check the database there, but that would take some time. Would it be possible to go through the history of all cards (where is this stored though?), check if files were attached, then check if these files are still in nextcloud and re-attach them?

To Reproduce Steps to reproduce the behavior:

1. Create a card, add attachments
2. ??? - sorry, cannot reproduce :(

Expected behavior Attachments should not be removed from card

Client details: Independent of Client

Server details

Operating system: Debian

Web server: nginx

Database: psql

PHP version: 8.2

Nextcloud version: (see Nextcloud admin page) 27.1.2

Where did you install Nextcloud from: nextcloud

Signing status:

Login as admin user into your Nextcloud and access
http://example.com/index.php/settings/integrity/failed
paste the results here.

List of activated apps:

If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your Nextcloud installation folder

Nextcloud configuration:

If you have access to your command line run e.g.:
sudo -u www-data php occ config:list system
from within your Nextcloud installation folder

or

Insert your config.php content here
Make sure to remove all sensitive content such as passwords. (e.g. database password, passwordsalt, secret, smtp password, …)

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

Logs

Nextcloud log (data/nextcloud.log)

Insert your Nextcloud log here

Browser log

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

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

[juliusknorr]

The files should have a share to the deck card, can you check if that is listed in the sharing sidebar of files?

[reox]

The files should have a share to the deck card, can you check if that is listed in the sharing sidebar of files?

There is no share listed for those images and also no activity listed. Maybe the share was somehow removed? What could be the cause for that?

[reox]

I found some very old cards (created >3 years ago) where attachments are again missing from teh card. The attachment is still linked in the text, but just shows this:

I cannot see anything in the card's history. However, the actual file is still in the Deck folder.

I found also other cards where the attachments are still attached, but I see the same image in the text.

Is there anything I can do here?