'An unexpected error occured'

Permalink 1 user found helpful
I was changing a few things on a page of my site, henryshandmadesoap.com and without thinking about it, deleted a file set from the dashboard that was on the page. When I want back to the site I found this:

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 ")

Now I can't edit the page in any way, not even delete it and start over. Help?

 
mdzoidberg replied on at Permalink Reply
mdzoidberg
Try this, from dashboard sitemap, click on that page and select properties->versions and select a version from before you added the file set? This at least should let you edit the page, you can then delete the version giving you the problems.
hbenagh replied on at Permalink Reply
Tried that already but it didn't work. I ended up deleting the page and
starting again. At least I'll know not to make that mistake again. Live and
learn. Thanks for the help though.

hbenagh
waroly replied on at Permalink Reply
I am having exactly the same problem. I was trying to use filesets when this happened and I have no dashboard available even via URL. Most of my home page is missing and I cannot access any subpages. Any ideas?
waroly replied on at Permalink Reply
I've also noticed that when I first launch the page, everything looks fine. It's only when I log in that everything appears to go haywire.
tommyh replied on at Permalink Reply
tommyh
Just did an update to a clients site to 5.4.2.2 and am trying to get the install up to the latest update in steps... But I too got this error:

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,1000 ")


Any ideas how to repair this?