Upgrade to 5.7.5 results in an unexpected error.

Permalink 2 users found helpful
Hi there! We just upgraded one of our testsites from 5.7.4.x to 5.7.5.
Suddenly we go the following error (see below). Dashboard still works fine, however the site is not working anymore. Anyone?

Cannot re-run the upgrade, because there is no upgrade available according to the Dashboard.

Thanks! :)

---

An unexpected error occurred.

An exception occurred while executing 'select CollectionVersionBlocks.isOriginal, CollectionVersionBlocks.cbIncludeAll, Blocks.btCachedBlockRecord, BlockTypes.pkgID, CollectionVersionBlocks.cbOverrideAreaPermissions, CollectionVersionBlocks.cbOverrideBlockTypeCacheSettings, CollectionVersionBlocks.cbOverrideBlockTypeContainerSettings, CollectionVersionBlocks.cbEnableBlockContainer, CollectionVersionBlocks.cbDisplayOrder, Blocks.bIsActive, Blocks.bID, Blocks.btID, bName, bDateAdded, bDateModified, bFilename, btHandle, Blocks.uID from CollectionVersionBlocks inner join Blocks on (CollectionVersionBlocks.bID = Blocks.bID) inner join BlockTypes on (Blocks.btID = BlockTypes.btID) where CollectionVersionBlocks.arHandle = ? and CollectionVersionBlocks.cID = ? and (CollectionVersionBlocks.cvID = ? or CollectionVersionBlocks.cbIncludeAll=1) and CollectionVersionBlocks.bID = ?' with params ["Main", "143", "3", "129"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'CollectionVersionBlocks.cbOverrideBlockTypeContainerSettings' in 'field list'

1 Attachment

4Concrete5
 
SnefIT replied on at Permalink Reply
SnefIT
As the error tells you : there is missing a column. I think you did an update forum 5.7.4.2 to 5.7.5?
Can you rerun the update routine?

May be you should tell c5 a lie, and let it think it is still 5.7.4.2 (look in config files) and do the update again?
SnefIT replied on at Permalink Reply
SnefIT
As the error tells you : there is missing a column. I think you did an update forum 5.7.4.2 to 5.7.5?
Can you rerun the update routine?

May be you should tell c5 a lie, and let it think it is still 5.7.4.2 (look in config files) and do the update again?
4Concrete5 replied on at Permalink Reply
4Concrete5
Hi SnefIT, thanks for your reply. Yes the upgrade went from 5.7.4.2 to 5.7.5. The error occurred somewhere during the upgrade. Are you saying I should manually change this line in the Config? Won't that mess up anything?

../concrete/config/concrete.php

/**
* Current Version
*
* @var string
*/
'version' => '5.7.5',
'version_installed' => '5.7.5',
'version_db' => '20150713000000', // the key of the latest database migration
andrew replied on at Permalink Reply
andrew
Can you run through the steps you took to update concrete5?
4Concrete5 replied on at Permalink Reply
4Concrete5
Hi Andrew, thanks for your reply.

The current version was 5.7.4.2.

- Downloaded Concrete5.7.5. from Concrete5.com
- FTP't ONLY the /concrete5.7.5/CONCRETE directory from the downloaded folder to /public_html/updates/concrete5.7.5
- Ran the update by going to > Dashboard > Update Concrete5

Update suddenly stopped and gave me the error. Dashboard still works fine.

Look forward to hearing from you.
andrew replied on at Permalink Reply
andrew
Hmm, very strange. I just tried this locally and didn't have any issues – although the update did take a little while (since there's a bit to do under the hood.) Is there any chance you could upload the concrete/ directory as a .zip file and use a file manager or command line "unzip" program to unzip the concrete directory on the server? The concrete directory has a large number of files in it, and I'm wondering if some of them are being dropped by the upload process.
SnefIT replied on at Permalink Reply
SnefIT
Andrew,

Just curious. When they upload the directory again (with all files), how do they update again?
SnefIT replied on at Permalink Reply
SnefIT
Andrew,

I fixed it for 4Concrete5! Some files didn't get ftp'd. I did a new upload of all files (thanks "Beyond Compare"!).

I had to fool C5 a little (just an 575 update directory, letting C5 think that it was the 5.7.4.2) else I couldn't update it.

Because the previous update was not finished correctly, I had to manually add 2 columns to the CollectioVersionBlocks table. (cbOverrideBlockTypeContainerSettings and cbEnableBlockContainer).

After that, the update went just fine!

Let's start using c5.7.5 ;-)
exchangecore replied on at Permalink Reply
exchangecore
Ya this seems to be a more common occurrance. I've personally helped more than a handful of people who have tried to do the install only to find they're missing some files from the install base. I imagine this is due to the somewhat fickle nature of FTP and the substantial number of files possibly combined with flakey internet connections. Many FTP uploaders don't give an overly obvious indicator when a file has been skipped or failed. Even in Filezilla unless you're actually looking for it it's easy enough to overlook.

Honestly I think this is mostly just bad habits formed by those used to uploading small static sites via ftp, now adays it's far more common to upload your site as a single zip file, and unzip it via management tools (as the concrete5 install instructions indicate). This eliminates a lot of variables and additionally saves a LOT of time uploading.
a575606 replied on at Permalink Reply
Hi.. I'm having exactly the same problem, and my site is down as a result. Wonder if you can help. My upgrade failed and I'm missing the same database columns. Could you please tell me what type of columns they are supposed to be? i.e. INT, FLOAT, TEXT.. etc? I want to add them manually and try to rerun the update script. Thanks
SnefIT replied on at Permalink Reply
SnefIT
These are boolean, so tinyints.
ataraxy replied on at Permalink Reply
SnefIT, or anyone else here, any chance you could lend a hand athttps://www.concrete5.org/community/forums/installation/error-after-...

Thanks!
shoutmediaca replied on at Permalink Reply
shoutmediaca
Manually adding these columns worked for me. Thanks SnefIT!
ataraxy replied on at Permalink Reply
When v5.7.5.2 came out I thought that it was finally time to try this.

I manually added the columns, and then used Installatron to do the upgrade. The upgrade seems to have worked in that the site displays properly, but when I check the Environment Information it shows:

# concrete5 Version
Core Version - 5.7.5.2
Version Installed - 5.7.4.2
Database Version - 20150731000000


which suggests that the upgrade hasn't worked properly.

Has the upgrade completed properly, or is there still a problem?

Thanks
andrew replied on at Permalink Reply
andrew
You shouldn't ever need to manually update the database. The update process should take care of that for you. If you're using a third party installer to update it sounds like the installer you're using isn't running all the update scripts it needs to run in order to complete properly.
ataraxy replied on at Permalink Reply
andrew: Thanks for your comments, but you've got a whole thread here where the upgrade has failed, and the thread that I started at https://www.concrete5.org/community/forums/installation/error-after-... has two more people with the problem.

I suspect that the error I found in the htupgrade.result file:

An exception occurred while executing 'INSERT INTO SystemDatabaseMigrations (version) VALUES (?)' with params ["571"]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '571' for key 'PRIMARY'


is the underlying cause. Could you please have a look.

Thanks
linderoths replied on at Permalink Reply
I had the same problem after upgrading from 5.7.4 to 5.7.5.2, the update script didn't run so I had to go to <yoursite>/index.php/tools/required/upgrade and upgrade it there as stated by @triplei here:
https://www.concrete5.org/community/forums/usage/c5.7.3-error-adding...