Hi, Recently I ended up being the last remaining admin and maintainer of a basic Discourse Docker image instance that was originally installed on our server in 2021 (I think) and mostly updated by someone else. For some time now, possibly right from the start we’ve been having a problem with upload…

Hello and welcome @Uphill4721 :slight_smile: I think there’s some relevant info in these topics, if I remember rightly: [صورة] How to make an image orphaned so that it gets removed? Support Because message revisions are kept, and older removed messages a…

Thanks for the fast response! Those topics and a few more linked in them have become quite familiar to me while trying to solve this issue but unfortunately they haven’t provided any definitive solution to this problem. Yesterday on the staging server I ran these commands modified for topics and p…

This is purely speculative but from a quick look at the post, post_upload and upload models, you can probably find out if you have orphaned uploads (database objects) with this: Upload.find_by_sql("select * from uploads where id in (select upload_id from post_uploads where post_id not in (select id…

Thank you for the reply! The query works but it lists only two uploads and their details. There should be hundreds or thousands of uploads matching the orphan criteria, most are image files originally uploaded by users while making normal posts. We’re currently using only official plugins: hooks:…

Going through similiar topics to gather possibly matching unsolved cases, here’s a good example on how these situations might even cause legal issues due to user uploads not getting orphaned and permanently removed like they should: [صورة] I got a copyright strike to PDF fil…

Hello. I am facing the same or similar issue, can’t figure out why the files can’t get deleted. Anyone else having this issue still? I ran some SQL queries and the “stuck” upload references seems to be all Drafts, but I checked my and other users Drafts and there are none. The Drafts tables are emp…

Yeah, we’re still having this issue too. I’d really like to sort it out somehow, our forum gets a lot of uploads but only a fraction of them need to be preserved long term so lots of disk space is being wasted. Any suggestions for troubleshooting appreciated. [صورة] kilometrs: Theoretically I …

I installed the forum 2 weeks ago and it has this problem since beginning. Looks like some bug. Can you run the same SQL query and check if there are lots of stuck “Drafts” references? Its easy to see, I have dozens of them but in drafts table there are 2, maybe 3 real drafts. Looks like they don’t…

Another relevant topic, I posted on there as I wasn’t aware of this topic. [صورة] Auto purge uploads from old deleted posts Feature Discourse already automatically removes orphan unreferenced uploads. Why not expand this functionality and erase uploads from del…

التحميلات لا يتم يتيمها وتنظيفها

الدعم

JammyDodger 22 مارس 2023، 1:55م 2

أهلاً بك @Uphill4721

أعتقد أن هناك بعض المعلومات ذات الصلة في هذه المواضيع، إذا كنت أتذكر بشكل صحيح:

الموضوع		الردود	مرات العرض
Auto purge uploads from old deleted posts Feature	6	1219	23 فبراير 2026
Is there a way to delete old/irrelevant uploads? Support	23	6432	25 فبراير 2020
Cleaning up uploads and purging uploads from S3 Site Management reference , file-management	2	1154	24 ديسمبر 2024
How to Delete Uploaded Files? Support	28	8221	18 فبراير 2025
How to make an image orphaned so that it gets removed? Support	20	3151	27 يناير 2022

التحميلات لا يتم يتيمها وتنظيفها

الموضوعات ذات الصلة