HEEEEELLLP! what the heck has just happened.
Permalink
Hi,
I am panicking as I was going to show the site to the client tomorrow, just did a bit of tinkering with a slideshow on my front page and BAM!
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 ")
I cannot log into the home page and all content including slideshow down is completely missing.
I can however log into other pages off the nav and able to clear cache but no change.
I have a backup which will give me some of the stuff back, but I wanted to know if anyone could see from my error above if this is solvable otherwise.
www.www.destinationromsey.co.uk...
Cheers all
I am panicking as I was going to show the site to the client tomorrow, just did a bit of tinkering with a slideshow on my front page and BAM!
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 ")
I cannot log into the home page and all content including slideshow down is completely missing.
I can however log into other pages off the nav and able to clear cache but no change.
I have a backup which will give me some of the stuff back, but I wanted to know if anyone could see from my error above if this is solvable otherwise.
www.www.destinationromsey.co.uk...
Cheers all
John,
Thanks for the speedy reply. I am afraid I panicked and reverted to a backup. That cured it straight away, but I have a little extra work to do now updating the bits which I stooopidly forgot to back up.
Your idea sounds good tho, thanks
Is everyone on here mainly on 5.5 or are you all too sensible and are waiting for some of the kinks to be ironed out ;o)
I dove straight into 5.5 and I must admit I keep getting scary moments like this, plus so many of the great add ons are not compatible.
Thanks for your help
Nick
Thanks for the speedy reply. I am afraid I panicked and reverted to a backup. That cured it straight away, but I have a little extra work to do now updating the bits which I stooopidly forgot to back up.
Your idea sounds good tho, thanks
Is everyone on here mainly on 5.5 or are you all too sensible and are waiting for some of the kinks to be ironed out ;o)
I dove straight into 5.5 and I must admit I keep getting scary moments like this, plus so many of the great add ons are not compatible.
Thanks for your help
Nick
Hi,
I received the same error as the person above.
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 ")
I was working with filesets and a slideshow when this happened. I am missing most of my home page including the dashboard. When I directly to the dashboard url, I get this message:
Not Found
The requested URL /index.php/dashboard was not found on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
I am using Firebug to see if there are any errors. Here's one:
ccm_menuInit is not defined
[Break On This Error]
$(function() {ccm_menuInit(ccm_menuObj114157)});
Basically, I have lost my site and don't know what to do.
Thank you for any help!
I received the same error as the person above.
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 ")
I was working with filesets and a slideshow when this happened. I am missing most of my home page including the dashboard. When I directly to the dashboard url, I get this message:
Not Found
The requested URL /index.php/dashboard was not found on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
I am using Firebug to see if there are any errors. Here's one:
ccm_menuInit is not defined
[Break On This Error]
$(function() {ccm_menuInit(ccm_menuObj114157)});
Basically, I have lost my site and don't know what to do.
Thank you for any help!
Damn! I must say, seeing these comments don't make me feel comfortable...
At this point, I'm still in the testing phase with Concrete5. I have not used it with any paying clients. It seems like a great program, but hand coding a site seems more reliable.
At this point, I'm still in the testing phase with Concrete5. I have not used it with any paying clients. It seems like a great program, but hand coding a site seems more reliable.
Hello,
I am browsing the forums because I had an error message appear while I was trying to edit a website that's been neglected for over a year. My website has disappeared, all I get is text on a white field. (It seems a similar message was talked about in this forum about a year ago.) Here is the error message:
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 ")
I followed the suggestion of going into the dashboard, and was able to get it, but can see no way of reverting to a previous version (which I am happy to do - I would not be losing anything worthwhile of what I was experimenting with today...) Thanks in advance for any help!
I am browsing the forums because I had an error message appear while I was trying to edit a website that's been neglected for over a year. My website has disappeared, all I get is text on a white field. (It seems a similar message was talked about in this forum about a year ago.) Here is the error message:
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 ")
I followed the suggestion of going into the dashboard, and was able to get it, but can see no way of reverting to a previous version (which I am happy to do - I would not be losing anything worthwhile of what I was experimenting with today...) Thanks in advance for any help!
sitename.com/index.php/dashboard/