Gigantic uploads folder

[shalmaxb]

I had a look into another installation, where the same happens. Some attachments are related, others not. I do not see a pattern yet.

[yuri]

Whenever an Image or File field is written, it should set the Related field in the attachment. For some reason it does not work in your instance.

[shalmaxb]

all attachments do not have parent, all orphans do not have parent and related.
Not orphans have related.

In the moment I cannot upload new image, as it is a client`s installation.

[yuri]

Does the attachment has empty Parent are Related?

[yuri]

What if you upload a new image? Would it be orphan?

[shalmaxb]

Record created 7.3.2024, image uploaded 8.3.2024
I also looked into the database, this record never had been deleted.

[yuri]

In what year was it uploaded? IIRC we didn't store the Related field in the attachment back in the day.

[shalmaxb]

yuri, here screenshots from orphans and respective detail view.

[victor]

Yes. For moving existing attachments you can use: https://docs.espocrm.com/administrat...ng-attachments.

[shalmaxb]

yes, image type, upload from GUI

[Russ]

> it's almost impossible to check data through linux command line

It's not supposed to. You can check your attachments at Administration > Attachments. You can filter orphan attachments and delete them. Find largest ones.

thanks

[yuri]

In a field of Image type? Did you upload that image via the UI? Or maybe by some automation?

[shalmaxb]

I have a custom entity, where I have images. The example, I gave, was one image still in use in one record of that entity, but showed up in orphans, which I thought is for deleted images.
I only tested with this one image, maybe there might be others marked as orphans, despite still in use.

[yuri]

> which is still in use. I can see that by the ID.

Where exactly it's used?

> deleted/not deleted

Not possible. Deleted just not listed.

[shalmaxb]

yuri I had a look into that in my app. I can display all attachments or the orphans only. But I see e.g. one attachment (an image) in the orphans list, which is still in use, not deleted. I can see that by the ID.
It would also be nice to have some more columns in the list view, like ID and deleted/not deleted (like in the MySQL database as 1 or 0).
Can I modify the list display by editing the json for the list layout? Or wouldn`t you not recommend that?