Forums

HELP - error 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 FileSearchIn

Permalink
help , for mistake i have delete one file set for one scroll image in home page and i recreated the file set but the error appear

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 FileSearchIn

help me please
 
Remo replied on at Permalink Reply
Remo
What version of concrete5 are you using? I think I've created a pull request a while ago which fixed this issue.
Remo replied on at Permalink Reply
Remo
Here's the change of which I think it should get rid of that error message:https://github.com/concrete5/concrete5/pull/567/files...
pdrago replied on at Permalink Reply
yes i know but i havent a programmer i can utilize concrete5 only like user , only user interface for building my site , how i can resolve this error in my site ?
Remo replied on at Permalink Reply
Remo
I'd definitely recommend to upgrade to the latest version!

I know a bunch of solutions to this problem but if you aren't familiar with PHP & Co I only have one thing in mind: Delete the page and recreate it.
pdrago replied on at Permalink Reply
i utilize concrete5 version 5.5.2.1.