Softr DB - File Attachment Getting Corrupted on Table Sort

Hi Team,

I have a File Type Column in my Database Which I am using to store Thumbnail Images for my Videos.

When I sorted this field in a different order, all Images got corrupted and I was not able to use the images. Had to reupload all of them.

I just tried Sort the Tables in a different Sort order. I have a sort order column in my Table as well.

So Looks like images got corrupted when the entire table was quickly changed to a different sort order.

I haven’t checked if this happens on any other major operation on the table. please please check.

Hi @AmeerKhatri6167 have you contacted support about this yet? if not, please do. They need to look into it further. Thanks!

@AmeerKhatri6167 I just checked seems to be fine… can you share a quick recording on this ?

Hi @artur and @Jjenglert ,

I am not able to re-create the issue. I tried.
May be it was a 1 time thing something on my side.

I will make a recording next time it happens. There are instances where the uploaded file suddenly goes corrupt. But I am not able to recreate them. But If i figure out a pattern I will share a screen recording.

Thanks for quick responses.

1 Like

Sounds good. Thanks!

Hi. Same issue with me for uploaded thumbnails (.png).
No issues with larger files.

Repeated, random corruption.

Additional issue of corrupted Images non-visible in original files field, but visible in Related Record Look Up referring to said file field.

Hi everyone,
I still haven’t found a solution for images breaking in Softr.

Some images break, some don’t — and I can’t figure out the logic behind it. I tried both options in the image field settings (refresh URL every hour vs. permanent/unlimited), but in both cases images still end up broken.

What I’ve noticed most: the issue seems to start more often when the image is coming from a Lookup field.

Use case: it’s a user profile photo. I have records linked to a user, and in those related records I display the user’s photo via Lookup. After a while, some of those photos become broken.

Does anyone know the root cause or a reliable workaround?

Should I avoid Lookup and instead copy/upload the user photo into each record via Workflow (or a hidden field)?
But then if the user updates their profile photo, older records will still show the old image — which is also not ideal.

Any suggestions?

At the same time, I have a Make.com scenario that updates the photo in this table, and it fails with a 400 Bad Request error every time. I still haven’t been able to figure out the cause.

Few months back there was an issue where copied images were keeping referencing original and then original being deleted would corrupt the copied images… That has been fixed…

I would appreciate if you could check if you create a new entry/image and check if they are stable

@Mehmet you can also DM you Database URL and I will check the system logs

I’ve redone it and will keep you posted. Thanks Artur!

I’ve tried deleting field and record the recreating.

The looked up image now appear in the Database and has not corrupted. But it is not longer appears in the Apps or on the actual website.

See screen shots below:

Database:

App Editor

Website

Hello @artur,

Thank you very much for your response. I removed the file field and recreated it, then reuploaded the images. I did the same for the lookup fields—deleted and recreated them. I ran over 100 tests and didn’t encounter any issues. It took some effort, but it seems the problem was resolved with the new links.

Thanks again.


Hello @StevenQ,

In the interface, fields are linked via field_id. If you remove a field, you need to add the new field back to the interface for it to appear.

Best regards.

Of course. That’s so obvious now. Thanks Mehmet. All working now. Cheers Artur!