Error after upgrading from v5.7.4.2 to v5.7.5.1 using Installatron on GoDaddy

Permalink
After upgrading my site from v5.7.4.2 to v5.7.5.1 using Installatron on GoDaddy, my site stops working with the following error:

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", "2", "11"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'CollectionVersionBlocks.cbOverrideBlockTypeContainerSettings' in 'field list'


The same error is reported in http://www.concrete5.org/community/forums/installation/upgrade-to-5... but it's not clear how to fix it given that I want to use Installatron.

Any suggestions?

Thanks!

Edit: Looking around I found an htupgrade.result file. This includes the message:

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'


Does this help at all?

View Replies:
theana27 replied on at Permalink Reply
theana27
I have the same error.

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'
LTO replied on at Permalink Reply
Hello, I have a similar error after updating to 5.7.5.1.

An exception occurred while executing 'SELECT t0.issID AS issID1, t0.customClass AS customClass2, t0.backgroundColor AS backgroundColor3, t0.backgroundImageFileID AS backgroundImageFileID4, t0.backgroundRepeat AS backgroundRepeat5, t0.borderColor AS borderColor6, t0.borderStyle AS borderStyle7, t0.borderWidth AS borderWidth8, t0.borderRadius AS borderRadius9, t0.baseFontSize AS baseFontSize10, t0.alignment AS alignment11, t0.textColor AS textColor12, t0.linkColor AS linkColor13, t0.marginTop AS marginTop14, t0.marginBottom AS marginBottom15, t0.marginLeft AS marginLeft16, t0.marginRight AS marginRight17, t0.paddingTop AS paddingTop18, t0.paddingBottom AS paddingBottom19, t0.paddingLeft AS paddingLeft20, t0.paddingRight AS paddingRight21, t0.rotate AS rotate22, t0.boxShadowHorizontal AS boxShadowHorizontal23, t0.boxShadowVertical AS boxShadowVertical24, t0.boxShadowBlur AS boxShadowBlur25, t0.boxShadowSpread AS boxShadowSpread26, t0.boxShadowColor AS boxShadowColor27, t0.hideOnExtraSmallDevice AS hideOnExtraSmallDevice28, t0.hideOnSmallDevice AS hideOnSmallDevice29, t0.hideOnMediumDevice AS hideOnMediumDevice30, t0.hideOnLargeDevice AS hideOnLargeDevice31 FROM StyleCustomizerInlineStyleSets t0 WHERE t0.issID = ?' with params ["107"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.hideOnExtraSmallDevice' in 'field list'
SnefIT replied on at Permalink Reply
Sorry, I don't have any experience with Installatron.

The missing database column (after you add this one, you'll get a message you mis another one also) will be the first step.

I have manually fooled C5 with another 5.7.5 directory in the updates, letting C5 think it was an 5.7.4.2 version. Then I could run the update again.

I hope this will help you.
ataraxy replied on at Permalink Reply
Thanks for letting me know.

What's the easiest way to add the columns, just SSH in and run a mySQL session?
SnefIT replied on at Permalink Reply
Or something like phpMyAdmin. Personally I use the MySQL Workbench (or SQLYog).
ataraxy replied on at Permalink Reply
I've seen phpMyAdmin in cPanel so I'll give that a go, and move to other things if necessary.

Thanks for your help!
ataraxy replied on at Permalink Reply 2 Attachments
In case this helps, this web site was set up using concrete5 v5.7.3.1 and then updated to v5.7.4.2. That update was fine.

I've just tried to reproduce this path in XAMPP and there is a big difference in the SystemDatabaseMigrations table which has the error in the htupgrade.result file. In XAMPP the table shows only dates. In GoDaddy, there are dates and something representing version numbers. I've attached screenshots.