mysql error
Permalink
hello i got this error out of
nowhere. i had this once before when i deleted a set that was in a gallery block. but this time it came out of nowhere. i found diefferent threads about it but no solution:
Exception 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 fv.fvType = '1' and fvIsApproved = '1' and ((select count(fID) from FileSetFiles where FileSetFiles.fID = f.fID and fsID in (-1)) = 0) and (f.uID = 3 or (select count(fID) from FileSetFiles where FileSetFiles.fID = f.fID and fsID in (-1)) = 0) order by fsDisplayOrder asc, fID asc ")
it would be nice to get some suggestions how to prevent it
nowhere. i had this once before when i deleted a set that was in a gallery block. but this time it came out of nowhere. i found diefferent threads about it but no solution:
Exception 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 fv.fvType = '1' and fvIsApproved = '1' and ((select count(fID) from FileSetFiles where FileSetFiles.fID = f.fID and fsID in (-1)) = 0) and (f.uID = 3 or (select count(fID) from FileSetFiles where FileSetFiles.fID = f.fID and fsID in (-1)) = 0) order by fsDisplayOrder asc, fID asc ")
it would be nice to get some suggestions how to prevent it

Youy are missing the fsDisplayOrder column in the FileSetFiles table. See attached. How this happended I have no clue.
well the table entry is there
and i can reproduce the error by deleting a fileset that is in a block.
be it a custom galleryblock or the slideshow block.
and i can reproduce the error by deleting a fileset that is in a block.
be it a custom galleryblock or the slideshow block.