Dashboard Upgrade 5.5.2.1 to 5.6.3.1 Failure - Database Failure
Permalink
Saved db before and after upgrade.
After upgrade the screen was blank, then when repointed site.php, got this error and still could not log into dashboard after checking the concrete pointers.
When I had shyc-cc.org/config/site.php pointed to define('DIRNAME_APP_UPDATED', 'concrete5.6.3.1_updater')
I then tried shyc-cc.org/config/site.php pointed to define('DIRNAME_APP_UPDATED', 'concrete5.5.2.1')
And then tried http://www.shyc-cc.org/index.php/tools/required/upgrade...
It said I had 5.6.3.1 and could not downgrade to 5.5.2.1
I hit it again and it said 5.5.2.1 and it indicated there was no upgrade available.
Then with shyc-cc.org/config/site.php pointed to define('DIRNAME_APP_UPDATED', 'concrete5.5.2.1')
Checked site.php again. Then installed Phpmyadmin and accessed the database. Backed it up again before any changes had been made.
1. Then noticed that there were double tables in the database, (EG: AreaGroupBlockTypes and areagroupblocktypes, etc). Had similar issue when going from Wamp to Linux server. Had to edit all tables. Does Concrete5 now automatically rewrite table with caps? What happened?
2. Also some of the Collate fields have latin1_swedish_ci instead of blank. How did this happen and should it be changed? How to change it if so. Maybe a secondary matter.
Then I dropped all the tables and imported an earlier db from before the attempted upgrade. Still getting the same error now! with site.php pointing to 5.5.2.1
Can anyone help me with some suggestions?
Should I delete all tables with caps?
Should I change all fields with latin1_swedish_ci to blank or ul8_general?
Should I try going back to 5.4.2.2?
Anything else?
Upon reflection, the first upgrades from 5.4.2.2 to 5.5.2.1 (I think) and 5.5.2.2 I prepared and cleaned cache and set in maintenance mode, but the last upgrade to 5.6.3.1 I might not have. At some point in there I upgraded some addons SortableFancy, Superfish, Slideshow (I think). I had 5.5.2.2 working!
After upgrade the screen was blank, then when repointed site.php, got this error and still could not log into dashboard after checking the concrete pointers.
When I had shyc-cc.org/config/site.php pointed to define('DIRNAME_APP_UPDATED', 'concrete5.6.3.1_updater')
PHP Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1054: Unknown column 'cPendingAction' in 'field list'] in EXECUTE("select Pages.cID, Pages.pkgID, Pages.cPointerID, Pages.cPointerExternalLink, Pages.cPointerExternalLinkNewWindow, Pages.cFilename, Collections.cDateAdded, Pages.cDisplayOrder, Collections.cDateModified, cInheritPermissionsFromCID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cPendingAction, cPendingActionUID, cPendingActionTargetCID, cPendingActionDatetime, cCheckedOutUID, cIsTemplate, uID, cPath, Pages.ctID, ctHandle, ctIcon, ptID, cParentID, cChildren, ctName, cCacheFullPageContent, cCacheFullPageContentOverrideLifetime, cCacheFullPageContentLifetimeCustom from Pages inner join Collections on Pages.cID = Collections.cID left join PageTypes on (PageTypes.ctID = Pages.ctID) left join PagePaths on (Pages.cID = PagePaths.cID and PagePaths.ppIsCanonical = 1) where Pages.cID = '99'")\n' in /home/shyc-cc.org/public_html/updates/concrete5.4.2.2/concrete/libraries/3rdparty/adod in /home/shyc-cc.org/public_html/updates/concrete5.4.2.2/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
I then tried shyc-cc.org/config/site.php pointed to define('DIRNAME_APP_UPDATED', 'concrete5.5.2.1')
And then tried http://www.shyc-cc.org/index.php/tools/required/upgrade...
It said I had 5.6.3.1 and could not downgrade to 5.5.2.1
I hit it again and it said 5.5.2.1 and it indicated there was no upgrade available.
Then with shyc-cc.org/config/site.php pointed to define('DIRNAME_APP_UPDATED', 'concrete5.5.2.1')
mysql error: [1054: Unknown column 'Pages.cIsActive' in 'field list'] in EXECUTE("select Pages.cID, Pages.pkgID, Pages.cPointerID, Pages.cPointerExternalLink, Pages.cIsActive, Pages.cIsSystemPage, Pages.cPointerExternalLinkNewWindow, Pages.cFilename, Collections.cDateAdded, Pages.cDisplayOrder, Collections.cDateModified, cInheritPermissionsFromCID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cPendingAction, cPendingActionUID, cPendingActionTargetCID, cPendingActionDatetime, cCheckedOutUID, cIsTemplate, uID, cPath, Pages.ctID, ctHandle, ctIcon, ptID, cParentID, cChildren, ctName, cCacheFullPageContent, cCacheFullPageContentOverrideLifetime, cCacheFullPageContentLifetimeCustom from Pages inner join Collections on Pages.cID = Collections.cID left join PageTypes on (PageTypes.ctID = Pages.ctID) left join PagePaths on (Pages.cID = PagePaths.cID and PagePaths.ppIsCanonical = 1) where Pages.cID = 1")
Checked site.php again. Then installed Phpmyadmin and accessed the database. Backed it up again before any changes had been made.
1. Then noticed that there were double tables in the database, (EG: AreaGroupBlockTypes and areagroupblocktypes, etc). Had similar issue when going from Wamp to Linux server. Had to edit all tables. Does Concrete5 now automatically rewrite table with caps? What happened?
2. Also some of the Collate fields have latin1_swedish_ci instead of blank. How did this happen and should it be changed? How to change it if so. Maybe a secondary matter.
Then I dropped all the tables and imported an earlier db from before the attempted upgrade. Still getting the same error now! with site.php pointing to 5.5.2.1
mysql error: [1054: Unknown column 'Pages.cIsActive' in 'field list'] in EXECUTE("select Pages.cID, Pages.pkgID, Pages.cPointerID, Pages.cPointerExternalLink, Pages.cIsActive, Pages.cIsSystemPage, Pages.cPointerExternalLinkNewWindow, Pages.cFilename, Collections.cDateAdded, Pages.cDisplayOrder, Collections.cDateModified, cInheritPermissionsFromCID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cPendingAction, cPendingActionUID, cPendingActionTargetCID, cPendingActionDatetime, cCheckedOutUID, cIsTemplate, uID, cPath, Pages.ctID, ctHandle, ctIcon, ptID, cParentID, cChildren, ctName, cCacheFullPageContent, cCacheFullPageContentOverrideLifetime, cCacheFullPageContentLifetimeCustom from Pages inner join Collections on Pages.cID = Collections.cID left join PageTypes on (PageTypes.ctID = Pages.ctID) left join PagePaths on (Pages.cID = PagePaths.cID and PagePaths.ppIsCanonical = 1) where Pages.cID = 1")
Can anyone help me with some suggestions?
Should I delete all tables with caps?
Should I change all fields with latin1_swedish_ci to blank or ul8_general?
Should I try going back to 5.4.2.2?
Anything else?
Upon reflection, the first upgrades from 5.4.2.2 to 5.5.2.1 (I think) and 5.5.2.2 I prepared and cleaned cache and set in maintenance mode, but the last upgrade to 5.6.3.1 I might not have. At some point in there I upgraded some addons SortableFancy, Superfish, Slideshow (I think). I had 5.5.2.2 working!
Then after trying to fix it the error changed to
By the way, I went through this last time with the damn capitalized tables, why does this always happen? See http://www.concrete5.org/community/forums/installation/moving-from-...
If I could laugh about this it might help, but right now I want to delete Concrete5