Layout problem (spacing between columns) after update to 5.4.2
Permalink 1 user found helpfulThe 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?
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 ")
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!
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.
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?
Thanks for explaining how to get the update available to run through the dashboard.
<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?
Yes it displays at the bottom of the homepagehttp://www.tzchristmas.com
and the page formatting is off.
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.
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.
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.