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?

adajad
View Replies: View Best Answer
bmccarthy replied on at Permalink Reply
I'm in the same boat. This new upgrade scared the crap out of me. Layout spacing is only one issue with the 5.4.2 update. Also the login was a huge issue, the new update apparently has a new database field for the users "uDefaultLanguage" and the only solution was to manually add the field to the database just to login to concrete5.

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.
jgaris replied on at Permalink Best Answer Reply
The newly released 5.4.2.1 fixes this issue.
hopskipjumperoo replied on at Permalink Reply
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
algro replied on at Permalink Reply
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 ")
bmccarthy replied on at Permalink Reply
What host do you use and does your host utilize phpmyadmin?
algro replied on at Permalink Reply
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!
bmccarthy replied on at Permalink Reply
So currently you can not login to access the dashboard or the edit bar correct?
bmccarthy replied on at Permalink Reply
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.
algro replied on at Permalink Reply
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?
bmccarthy replied on at Permalink Reply
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)
bmccarthy replied on at Permalink Reply
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. 
hopskipjumperoo replied on at Permalink Reply
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.
bmccarthy replied on at Permalink Reply
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.
tommyh replied on at Permalink Reply
tommyh
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?
bmccarthy replied on at Permalink Reply
So are you not able to login?
tommyh replied on at Permalink Reply
tommyh
Yes I can login and see the dashboard.
bmccarthy replied on at Permalink Reply
Then where are you seeing this error. Is it on a public page I can view?
tommyh replied on at Permalink Reply
tommyh
Hi,

Yes it displays at the bottom of the homepagehttp://www.tzchristmas.com

and the page formatting is off.
bmccarthy replied on at Permalink Reply
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.
tommyh replied on at Permalink Reply
tommyh
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.
bmccarthy replied on at Permalink Reply
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?
tommyh replied on at Permalink Reply
tommyh
Thanks so much...Yes there is a footer missing and some java snow that is supposed to display.