It looks like this is happening because some string is too long but this hasn't been a problem before. I found this support page that explains my problem but doesn't help me with a solution:
"External storage containers appear as <Missing: filename.ext> if either database file name, open storage path, or container file name is long"
The files show as <Missing: filename.ext> but if I copy/ paste them from the container they show up fine. Is this really because the URL is too long because this was working before. I tried shortening the name of the table, the field and I tried storing the container data locally/ externally secured and externally open.
Any help is greatly appreciated.