Issue Bug Closed

#51562sys_file records marked as deleted crash file list (AKA: remove sys_file.deleted flag)

Francois Suter 08/30/13, 11:48 updated 10/02/18, 12:09

Description

If some sys_file records have their “deleted” flag set to 1, the File > Filelist module will crash with exception “No file found for given UID”. It seems like the deleted flag is not used anymore, but was obviously used at some point in the past, since I have a few records with such a status in my database. I guess I’m not the only one.

Reproducing the error condition is easy: access the sys_file table in some DB management tool, set the deleted flag of some file to 1 and try to access the folder where it is stored in the File module. This results in an exception.

I’m not sure how this is best corrected. I have seen that there’s an intention to drop the deleted flag entirely, which seems fine if it is not used anyway, but that would be for 6.2 only. Something must be done for 6.0 and 6.1.

Reviews 7