Error On Page
Permalink
Recently, one of the pages on my site has become inaccessible. There is an error that I am not sure how to start debugging, because I can not remember doing anything to cause it. The error is as follows:
"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 fv.fvType = '1' and fvIsApproved = '1' order by fsDisplayOrder asc, fID asc limit 0,15 ")"
Any help would greatly be appreciated!
"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 fv.fvType = '1' and fvIsApproved = '1' order by fsDisplayOrder asc, fID asc limit 0,15 ")"
Any help would greatly be appreciated!
I never came across this error but, from searching the forums, it seems that you have a problem with a slideshow set to use a file set - maybe the fileset was deleted?
There is a thread in which this issue was resolved. Please read this:
http://www.concrete5.org/community/forums/usage/file-set-issue/...
Hope this helps!