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
![nteaviation](/files/avatars/15984.jpg)
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.