Update:
I read some rake tasks and saw rake posts:recover_uploads_from_index which seems to fix my issue. However I’m getting the following error:
undefined method `split' for nil:NilClass
from /var/www/discourse/app/models/site_setting.rb:151:in `s3_base_url'
I dont have s3 uploads enabled for my website 