upgrade disater
Permalink
Just tried to upgrade a site from 5.7.5.4 to 5.7.5.5 through the dashboard and the site has gone with this message being displayed.
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.backgroundSize AS backgroundSize6, t0.backgroundPosition AS backgroundPosition7, t0.borderColor AS borderColor8, t0.borderStyle AS borderStyle9, t0.borderWidth AS borderWidth10, t0.borderRadius AS borderRadius11, t0.baseFontSize AS baseFontSize12, t0.alignment AS alignment13, t0.textColor AS textColor14, t0.linkColor AS linkColor15, t0.marginTop AS marginTop16, t0.marginBottom AS marginBottom17, t0.marginLeft AS marginLeft18, t0.marginRight AS marginRight19, t0.paddingTop AS paddingTop20, t0.paddingBottom AS paddingBottom21, t0.paddingLeft AS paddingLeft22, t0.paddingRight AS paddingRight23, t0.rotate AS rotate24, t0.boxShadowHorizontal AS boxShadowHorizontal25, t0.boxShadowVertical AS boxShadowVertical26, t0.boxShadowBlur AS boxShadowBlur27, t0.boxShadowSpread AS boxShadowSpread28, t0.boxShadowColor AS boxShadowColor29, t0.hideOnExtraSmallDevice AS hideOnExtraSmallDevice30, t0.hideOnSmallDevice AS hideOnSmallDevice31, t0.hideOnMediumDevice AS hideOnMediumDevice32, t0.hideOnLargeDevice AS hideOnLargeDevice33 FROM StyleCustomizerInlineStyleSets t0 WHERE t0.issID = ?' with params ["12"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.backgroundSize' in 'field list'
I can still get to the dashboard.
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.backgroundSize AS backgroundSize6, t0.backgroundPosition AS backgroundPosition7, t0.borderColor AS borderColor8, t0.borderStyle AS borderStyle9, t0.borderWidth AS borderWidth10, t0.borderRadius AS borderRadius11, t0.baseFontSize AS baseFontSize12, t0.alignment AS alignment13, t0.textColor AS textColor14, t0.linkColor AS linkColor15, t0.marginTop AS marginTop16, t0.marginBottom AS marginBottom17, t0.marginLeft AS marginLeft18, t0.marginRight AS marginRight19, t0.paddingTop AS paddingTop20, t0.paddingBottom AS paddingBottom21, t0.paddingLeft AS paddingLeft22, t0.paddingRight AS paddingRight23, t0.rotate AS rotate24, t0.boxShadowHorizontal AS boxShadowHorizontal25, t0.boxShadowVertical AS boxShadowVertical26, t0.boxShadowBlur AS boxShadowBlur27, t0.boxShadowSpread AS boxShadowSpread28, t0.boxShadowColor AS boxShadowColor29, t0.hideOnExtraSmallDevice AS hideOnExtraSmallDevice30, t0.hideOnSmallDevice AS hideOnSmallDevice31, t0.hideOnMediumDevice AS hideOnMediumDevice32, t0.hideOnLargeDevice AS hideOnLargeDevice33 FROM StyleCustomizerInlineStyleSets t0 WHERE t0.issID = ?' with params ["12"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.backgroundSize' in 'field list'
I can still get to the dashboard.
If you go to /index.php/tools/required/upgrade and re-run the upgrade does it fix the issue?
when i go there i get 'access denied'.
Im assuming this is because i'm not logged in but I can login now as have no access to dashboard. The access i had previously was only there in that session and now gone.
Im assuming this is because i'm not logged in but I can login now as have no access to dashboard. The access i had previously was only there in that session and now gone.
There are various posts relating to this error:
https://www.concrete5.org/developers/bugs/5-7-5-5/update-5.7.5.4...
https://www.concrete5.org/community/forums/installation/error-after-...
For some reason you are missing some database columns related to custom styles.
The fix seems to be to add them into the database manually:
https://github.com/concrete5/concrete5/issues/2981...
https://www.concrete5.org/developers/bugs/5-7-5-5/update-5.7.5.4...
https://www.concrete5.org/community/forums/installation/error-after-...
For some reason you are missing some database columns related to custom styles.
The fix seems to be to add them into the database manually:
https://github.com/concrete5/concrete5/issues/2981...
hi katalysis, appreciate your help but having no joy.
I have tried all these fixes and more and all lead to dead ends.
Im just having to rebuild the site as have wasted so much time on this already is now just dead time.
Very disappointed with C5, how can they release an upgrade path that ruins your website.
I have tried all these fixes and more and all lead to dead ends.
Im just having to rebuild the site as have wasted so much time on this already is now just dead time.
Very disappointed with C5, how can they release an upgrade path that ruins your website.
Before you give up, one last little suggestion.
In your top level /application/config folder, create a file called config.php
In that place the following code:
Then try going to yoursite.com/ccm/system/upgrade
The config file should disable the logged in check, allowing you to rerun the upgrade process.
In your top level /application/config folder, create a file called config.php
In that place the following code:
Then try going to yoursite.com/ccm/system/upgrade
The config file should disable the logged in check, allowing you to rerun the upgrade process.
yep tried that too.
yep tried that too.
