I’ve got a site where it seems that a bunch of uploads have been removed from the uploads table in the database, but still exist in the filesystem. This leaves links to these broken. I’ve fixed a few by re-uploading files into a new topic to create the record in the DB (at the time I thought that th…

Yeah our history here with uploads is quite spotty, and it is our fault.. @sam can you recommend someone to give a quick bit of advice?

This can work, you just have to be careful to test on local … also look at 2x / 3x directories there are uploads everywhere.

I’m trying something like this: def add_missing_files_to_uploads public_directory = Rails.root.join("public").to_s db = RailsMultisite::ConnectionManagement.current_db uploads_directory = File.join(public_directory, 'uploads', db).to_s # uploads and optimized images missing = 0 matched …

Hi @pfaffman . I was reading this topic as it looks a promising solution for my problem here . Did you manage to get to a good result in the end?

Sorry, I can’t remember. It looks to Sam and me like it’ll work. I just solved a simulator problem by creating a post and into it inserting a link to all of the images and then rebaking all of the posts that contain transparent.gif. This looks like a somewhat more elegant solution. I would say …

I wonder if this is the best method nowadays? I’m trying to recover uploads that are on the filesystem but not in the database after a bad S3 migration (with the old rake:s3_migrate).

[صورة] satonotdead: I wonder if this is the best method nowadays? There isn’t really a good method. :crying_cat: But, yeah. That’s still the idea. I don’t think anything has changed in Discourse since then. Typically, I’d do a couple by hand to make sure that it does what’s expected. Also, …

Okay, I solved it with Claude and a lot of praise. I’m sharing what I did in order to help anyone else with a similar or the same issue. I’m not sure if that’s the most clever and optimal method to use, just the one that worked for me. Please be careful and keep in mind that I’m not an expert but …

إعادة إضافة التحميلات المفقودة إلى قاعدة البيانات

الدعم

codinghorror (Jeff Atwood) 28 مايو 2020، 3:01ص 2

نعم، تاريخنا هنا مع التحميلات غير مستقر، والخطأ منا.. @سام، هل يمكنك التوصية بشخص لتقديم نصيحة سريعة؟

الموضوع		الردود	مرات العرض
How to control this mess of shifting uploads from S3 to local Support s3	2	136	3 يوليو 2025
Migrate_to_S3 Fails on Rebake Self-hosting	17	2785	10 سبتمبر 2022
Missing uploads after S3 → S3 migration Support	0	464	16 مايو 2022
Troubles with uploads after DO Spaces datacenter change Support	7	884	19 يونيو 2021
False positives on "posts are not remapped to new S3 upload URL" Bug s3	5	293	22 يونيو 2025

إعادة إضافة التحميلات المفقودة إلى قاعدة البيانات

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