Updating foreign installations from 5.4.2.2 onwards. Other solutions sought and tried, none worked.
Permalink
The trouble began when my company overtook some installations for hosting from another company. Most of the installations are old (5.4.2.2 generally, some older, some newer) and i've had endless trouble trying to update them.
Searching the forums lead to a lot of different solutions, but none worked in this particular case. I'll do my best to be as specific as possible, and be thankful for any and help help that can be offered.
I'll use the site butikblossom.dk as the example, since it's the one i've tried the most solutions on.
I'm doing all this locally with Mamp, with a backed-up database and a user with full permissions in said database.
It runs Concrete5.4.2.2 and i have tried upgrading it 5.5.0, 5.5.1 and most other 5.5* manually and automatically.
I also tried a suggestion of uploading the update to /updates/concrete5.5.0/
Then going into site.php and adding
define('DIRNAME_APP_UPDATED', 'concrete5.5.0');
Then going to /index.php/tools/upgrade?force=1
The result varies depending on which version i try to update to. When trying 5.5.0, the site can still load, but that's about all it still does. Attached images is what the site looks like logged in as the admin. Updating further than that results in an error message similar to the one below on load.
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")
I suspected the problem could be that the devs that created the site had fiddled in the core concrete folder, but i tested it out and that doesn't seem to be it.
My end goal is to update the installations to 5.6.3.3, not the newest 5.7.
I hope someone can help, we're on a bit of a deadline and since trying out existing suggestions yielded nothing, i hope someone may have a suggestion.
Edit:
Made some progress, apparently the guys who created the site added files of their own in sitename/elements, sitename/themes, sitename/single_pages and sitename/tools.
I haven't grasped completely why they're there, but it seems removing them solves the updating problem. The files must have been interfering with the dashboard and other elements.
Searching the forums lead to a lot of different solutions, but none worked in this particular case. I'll do my best to be as specific as possible, and be thankful for any and help help that can be offered.
I'll use the site butikblossom.dk as the example, since it's the one i've tried the most solutions on.
I'm doing all this locally with Mamp, with a backed-up database and a user with full permissions in said database.
It runs Concrete5.4.2.2 and i have tried upgrading it 5.5.0, 5.5.1 and most other 5.5* manually and automatically.
I also tried a suggestion of uploading the update to /updates/concrete5.5.0/
Then going into site.php and adding
define('DIRNAME_APP_UPDATED', 'concrete5.5.0');
Then going to /index.php/tools/upgrade?force=1
The result varies depending on which version i try to update to. When trying 5.5.0, the site can still load, but that's about all it still does. Attached images is what the site looks like logged in as the admin. Updating further than that results in an error message similar to the one below on load.
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")
I suspected the problem could be that the devs that created the site had fiddled in the core concrete folder, but i tested it out and that doesn't seem to be it.
My end goal is to update the installations to 5.6.3.3, not the newest 5.7.
I hope someone can help, we're on a bit of a deadline and since trying out existing suggestions yielded nothing, i hope someone may have a suggestion.
Edit:
Made some progress, apparently the guys who created the site added files of their own in sitename/elements, sitename/themes, sitename/single_pages and sitename/tools.
I haven't grasped completely why they're there, but it seems removing them solves the updating problem. The files must have been interfering with the dashboard and other elements.
