Layout problem (spacing between columns) after update to 5.4.2
Permalink 1 user found helpful
I updated from 5.4.1.1 to 5.4.2 a few hours ago, and suddenly the spacing between my columns in my layouts are ignored. Where I had two columns with a 25px spacing between them before is now just impossible to read.
The same thing happens when I create a new layout or when I edit an existing one.
Is this a bug or just my installation being strange?
The same thing happens when I create a new layout or when I edit an existing one.
Is this a bug or just my installation being strange?
The newly released 5.4.2.1 fixes this issue.
I am not seeing an option to upgrade to 5.4.2.1 from my dashboard. My site is saying that I am up to date with 5.4.2. Is there another place I should be looking for the 5.4.2.1 update? TIA
5.4.2.1 did not solve it. (updating from 5.4.1.1)Same problem here! As a relatively new user I am completely lost.
I don't no where to write that uDefaultLanguage. Can't even log in to the dashboard anymore.
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' and ((select count(fID) from FileSetFiles where FileSetFiles.fID = f.fID and fsID in (2,3,4,6,-1)) = 0) and (f.uID = 0 or (select count(fID) from FileSetFiles where FileSetFiles.fID = f.fID and fsID in (-1)) = 0) and (f.fID not in (45)) order by fsDisplayOrder asc, fID asc limit 0,1000 ")
I don't no where to write that uDefaultLanguage. Can't even log in to the dashboard anymore.
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' and ((select count(fID) from FileSetFiles where FileSetFiles.fID = f.fID and fsID in (2,3,4,6,-1)) = 0) and (f.uID = 0 or (select count(fID) from FileSetFiles where FileSetFiles.fID = f.fID and fsID in (-1)) = 0) and (f.fID not in (45)) order by fsDisplayOrder asc, fID asc limit 0,1000 ")
What host do you use and does your host utilize phpmyadmin?
http://www.hoststar.ch/
yes: phpmyadmin
Even though I made a backup both of the server-content and the database, I was not able to recover my content. It was not possible to use the .sql dumbfile from concrete5. Asked an information scientist. Did not work either. Restoring the db from within concrete5: messed up everything.
Now, I've installed the newest version, and try typing manually the content from the old db for the rest of my weekend. I won't update anymore in the future!
yes: phpmyadmin
Even though I made a backup both of the server-content and the database, I was not able to recover my content. It was not possible to use the .sql dumbfile from concrete5. Asked an information scientist. Did not work either. Restoring the db from within concrete5: messed up everything.
Now, I've installed the newest version, and try typing manually the content from the old db for the rest of my weekend. I won't update anymore in the future!
So currently you can not login to access the dashboard or the edit bar correct?
according to your PHP error you posted the column fsDisplayOrder does not exist in your database so you need to add it manually.
1. First access your database using phpMyadmin.
2. Open your concrete database(by clicking on it)
3. You should see a huge list of tables scroll through them till you find one that is labeled "FileSetFiles" (click on it)
4. You should now see some tabs; Browse, Structure, SQL, etc. Click on Structure.
5. In the "Add" section (typically under the column names) add a new field at the end of the table and hit go.
6. Enter these fileds
6.a. Column: fsDisplayOrder
6.b. Type: INT
6.c. Length/Values: 10
6.d. Attributes: UNSIGNED
6.e. Leave the rest blank or as is.
6.f. Click on "Save" and you should be good to go.
1. First access your database using phpMyadmin.
2. Open your concrete database(by clicking on it)
3. You should see a huge list of tables scroll through them till you find one that is labeled "FileSetFiles" (click on it)
4. You should now see some tabs; Browse, Structure, SQL, etc. Click on Structure.
5. In the "Add" section (typically under the column names) add a new field at the end of the table and hit go.
6. Enter these fileds
6.a. Column: fsDisplayOrder
6.b. Type: INT
6.c. Length/Values: 10
6.d. Attributes: UNSIGNED
6.e. Leave the rest blank or as is.
6.f. Click on "Save" and you should be good to go.
Thanks a lot for your effort.
I'm sure, it would have solved the problem…
Unfortunately I can't test it now, decided to delete everything.
For future updates: What's the best way to backup?
I'm sure, it would have solved the problem…
Unfortunately I can't test it now, decided to delete everything.
For future updates: What's the best way to backup?
if your host supports a full site backup, including database and files, that would be the best. if not, backup the entire root folder of your server and use phpmyadmin to export a database backup file, to your local host(your computer)
Yeah you need to visit the concrete5 download page (link up at the very top of this page) and download the 5.2.4.1 version. Upload those files to your "upgrade" directory on your server. Should be where your concrete5 installation is. Once you have done this you will be able to install it from your dashboard under system and upgrades. Hope this helps.
Thanks! I didn't realize the updates weren't 'connected' like the marketplace is but I am VERY relieved that they aren't. I was worried my admin users would be updating without me knowing about it.
Thanks for explaining how to get the update available to run through the dashboard.
Thanks for explaining how to get the update available to run through the dashboard.
No problem, but keep in mind that main C5 updates are available strait from the dashboard/market place. Not sure why subsequent releases arnt. But if your worried about admins updating, you should consider making a different user group with less admin functions.
I just attempted to update to 5.4.2.2 and I got the error:
<code>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 ")</code>
I checked the db and the fsDisplayOrder is already there. Any ideas?
<code>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 ")</code>
I checked the db and the fsDisplayOrder is already there. Any ideas?
So are you not able to login?
Yes I can login and see the dashboard.
Then where are you seeing this error. Is it on a public page I can view?
Hi,
Yes it displays at the bottom of the homepagehttp://www.tzchristmas.com
and the page formatting is off.
Yes it displays at the bottom of the homepagehttp://www.tzchristmas.com
and the page formatting is off.
OK, Yeah something weird is definitely going on here. Your most likely having issues with your layout because your webpage isn't rendering all the code. Just by looking at the source code, your missing all the end elements. (I.E. </body></html>)
I need to know if your "DEBUG" mode is set to "Production" or "Development". To do this follow these steps:
1: Log in to your dashboard
2: Click on the Settings tab or the "Sitewide Settings" tab (I'm not sure if all the versions are the same, it should be the Sitewide Settings)
3: Click on the "DEBUG" tab at the top of the page. (should be next to General, Email, etc.)
4: Make sure the radio button next to "Production" is selected. Then click "Set Debug Level"
Reply to this post once you've check these settings so I can take another look.
I need to know if your "DEBUG" mode is set to "Production" or "Development". To do this follow these steps:
1: Log in to your dashboard
2: Click on the Settings tab or the "Sitewide Settings" tab (I'm not sure if all the versions are the same, it should be the Sitewide Settings)
3: Click on the "DEBUG" tab at the top of the page. (should be next to General, Email, etc.)
4: Make sure the radio button next to "Production" is selected. Then click "Set Debug Level"
Reply to this post once you've check these settings so I can take another look.
Hi,
Thank you for taking the time to help me out. I really appreciate it.
I have completed those steps. Let me know if you need me to do anything else.
Thank you for taking the time to help me out. I really appreciate it.
I have completed those steps. Let me know if you need me to do anything else.
Well that was worth a shot. Go ahead put the debug mode back to development. Do you have any Blocks being used at the bottom of that page?
Thanks so much...Yes there is a footer missing and some java snow that is supposed to display.
Needless to say I will be backing up the entire site and database before updating again.
A solution to this layout issue would be great.