File Set Issue
Permalink 1 user found helpful
I accidentally deleted the file set and now I am getting this error on my site. I was using a file set for the banner and now the entire site is broken because of that. This is the error I am getting -
Mysql 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 ")
Please help me on how I can get out of this problem.
Mysql 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 ")
Please help me on how I can get out of this problem.
I rolled back to the 1st version and I am still seeing the same error. Unfortunately I was not making changes to the page default type. I directly went into the filesets, wanted to delete an image in the file set, since I was not able to do it there I just delelted it instead of going to the file manager and deleting it. I recreated the file set and it didn't help. After all the hard work....I am screwed...
Sent a pm I will do my best to help directly.
Ekko really saved my life. His solution was-
"To remove the slideshow block from system thereby deleting the error you will need to go to dashboard, than under the stacks, and blocks category, click block types. A list will show that has the entire list of blocks, find slideshow. Click it, and a menu will appear with buttons at the bootom for refresh, and remove. Try refresh first than go to dashboard, and under the speed settings click clear cache, clear your cache and refresh the home page."
This helped like a magic eraser.
"To remove the slideshow block from system thereby deleting the error you will need to go to dashboard, than under the stacks, and blocks category, click block types. A list will show that has the entire list of blocks, find slideshow. Click it, and a menu will appear with buttons at the bootom for refresh, and remove. Try refresh first than go to dashboard, and under the speed settings click clear cache, clear your cache and refresh the home page."
This helped like a magic eraser.
You should really mark Ekko with a best answer.
In case it's of use to anyone I just solved the same issue by updating the gallery table to the latest file set (using PhpMyAdmin) and then clearing the cache. Maybe it was just a caching issue though.
I had to do the same. For SQL newbies:
Go to the table btMultiEffectSlider (or btSlideshow if that is in use) and check all the fsID's there is. Compare to File Sets in use (www.domain.ltd/index.php/dashboard/files/sets/). Put mouse over the link and check the id at the end of the URL. When you find one fsID in the database that you cannot find in File Sets -> replace it with the newest File set id.
Some one should fix that bug in that / those modules....
Go to the table btMultiEffectSlider (or btSlideshow if that is in use) and check all the fsID's there is. Compare to File Sets in use (www.domain.ltd/index.php/dashboard/files/sets/). Put mouse over the link and check the id at the end of the URL. When you find one fsID in the database that you cannot find in File Sets -> replace it with the newest File set id.
Some one should fix that bug in that / those modules....
I am currently having this exact problem on just a single page but I am such a newbie I cannot follow the above directions....I apologize but can somebody help? I have contacted the person who originally built the site but he is out of the country and I am the current admin....
To roll them back effectively you need to delete them one by one, as even if you approve another version you as the admin will always see the most current version (the broken one) Hopefully you don't have to delete too many versions.