How to find attachments without a file in filesystem

[JayBee4pl]

Hello,
we had an incident with our system and now our Database content is newer the our filesystem.
No we have attachments where the file in the datadir is missing.
Is there a way toch get a list of db entries where the file is missing?

Thanks in advance
Jens

[victor]

The database stores only information about the Attachment: name, type, size, etc. The attachment itself (its contents) is located directly in the your_instance_name/data/upload folder on your server or on AWS.
If you don't have a backup of your instance, there will be no way to restore your files.

[JayBee4pl]

????
Thats what i wrote.
I dont want to restore files. I want to delete orphaned db entries.

[victor]

It is unclear whether these files are marked in the database as deleted (deleted = 1). If so, they will be deleted automatically after some time. If they are (deleted = 0) and the deleted files are still in Administration > Attachments, you can filter them and delete them via the UI. And after some time they will be deleted automatically (from database).

A similar topic with examples about deleting files, attachments and the parameters that affect this is discussed here:https://forum.espocrm.com/forum/gene...after-removing.

[JayBee4pl]

They are not marked as deleted. Our DB restore was newer than the filesystemrestore. So we have DB entries without a file.