How to locate a fileset
Permalink
I was editing a fileset to delete one of two files in the fileset. When I saved it, it hung for a while but eventually the control came back, but the file was not deleted. So I deleted it again. With that, the fileset seems to become corrupted (or is gone). It no longer shows up in the fileset list. At the place where the fileset is accessed, the following error message shows up:
An unexpected error occurred.
mysql error: [1054: Unknown column 'fsDisplayOrder' in 'order clause'] in EXECUTE("SELECT DISTINCT f.fID, u.uName as fvAuthorName FROM Files f INNER JOIN FileVersions fv ON f.fID = fv.fID LEFT JOIN Users u on u.uID = fv.fvAuthorUID left join FileSearchIndexAttributes on (fv.fID = FileSearchIndexAttributes.fID) where 1=1 and fvIsApproved = '1' and ((select count(fID) from FileSetFiles where FileSetFiles.fID = f.fID and fsID in (-1)) = 0) and (f.uID = 0 or (select count(fID) from FileSetFiles where FileSetFiles.fID = f.fID and fsID in (-1)) = 0) order by fsDisplayOrder asc ")
The page with the above error can not be edited (the edit button on the upper left corner is missing).
My question is: How do I locate this fileset and hopefully delete it from its location? Or, if the fileset is indeed gone, how can I edit the page to get rid of the reference to the fileset? Thanks.
An unexpected error occurred.
mysql error: [1054: Unknown column 'fsDisplayOrder' in 'order clause'] in EXECUTE("SELECT DISTINCT f.fID, u.uName as fvAuthorName FROM Files f INNER JOIN FileVersions fv ON f.fID = fv.fID LEFT JOIN Users u on u.uID = fv.fvAuthorUID left join FileSearchIndexAttributes on (fv.fID = FileSearchIndexAttributes.fID) where 1=1 and fvIsApproved = '1' and ((select count(fID) from FileSetFiles where FileSetFiles.fID = f.fID and fsID in (-1)) = 0) and (f.uID = 0 or (select count(fID) from FileSetFiles where FileSetFiles.fID = f.fID and fsID in (-1)) = 0) order by fsDisplayOrder asc ")
The page with the above error can not be edited (the edit button on the upper left corner is missing).
My question is: How do I locate this fileset and hopefully delete it from its location? Or, if the fileset is indeed gone, how can I edit the page to get rid of the reference to the fileset? Thanks.
I'd be interested if/how you solved this. I'm getting a similar error but I can see the column is present in FileSetFiles (where I assume it should be). I'm therefore assuming that a file set is corrupt in some way, but it's been a while since I've used Concrete 5 and the structure of the particular pages where the problem seems to be escapes me!
