trouble migrating site
Permalink
wow, for as accessible C5 is for editing a site's content, I'm surprised and disheartened to be entering into so much complexity in order to move a site from one server to another :(
I've followed and reviewed some threads here about the topic and have gotten lost in some esoteric errors… here’s where I’m stumped currently:
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1054: Unknown column 'Pages.cPointerExternalLinkNewWindow' 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 = 1") ' in /home/maghith/deeplycalm.com/concrete/libraries/3rdparty/adodb/adodb in /home/maghith/deeplycalm.com/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
I don’t know what to do about this… I’m wondering if part of the difficulty is that the mysql database export was from concrete 5.3.1.1 and the Dreamhost one click installer supplied me with 5.4.1.1… maybe? If I’d found it easier to update then I wouldn’t be trying to migrate & jump a version gap at the same time… perhaps that’s not a problem. I can’t help but compare my experience here with that of wordpress… I don’t know if that’s a bugbear here but I’ve had more ease with these kinds of operations there (updating especially!)
what would you need to know about my situation to make it easy, easier, or even just possible to help me?
here are the threads I’ve consulted:
http://www.concrete5.org/index.php?cID=1479...
http://www.concrete5.org/community/forums/customizing_c5/best-proce...
http://www.concrete5.org/documentation/installation/moving_a_site...
http://www.concrete5.org/community/forums/chat/transferring-concret...
http://www.concrete5.org/community/forums/chat/how_to_move_a_c5_web...
I've followed and reviewed some threads here about the topic and have gotten lost in some esoteric errors… here’s where I’m stumped currently:
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1054: Unknown column 'Pages.cPointerExternalLinkNewWindow' 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 = 1") ' in /home/maghith/deeplycalm.com/concrete/libraries/3rdparty/adodb/adodb in /home/maghith/deeplycalm.com/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
I don’t know what to do about this… I’m wondering if part of the difficulty is that the mysql database export was from concrete 5.3.1.1 and the Dreamhost one click installer supplied me with 5.4.1.1… maybe? If I’d found it easier to update then I wouldn’t be trying to migrate & jump a version gap at the same time… perhaps that’s not a problem. I can’t help but compare my experience here with that of wordpress… I don’t know if that’s a bugbear here but I’ve had more ease with these kinds of operations there (updating especially!)
what would you need to know about my situation to make it easy, easier, or even just possible to help me?
here are the threads I’ve consulted:
http://www.concrete5.org/index.php?cID=1479...
http://www.concrete5.org/community/forums/customizing_c5/best-proce...
http://www.concrete5.org/documentation/installation/moving_a_site...
http://www.concrete5.org/community/forums/chat/transferring-concret...
http://www.concrete5.org/community/forums/chat/how_to_move_a_c5_web...
It happens that the previous site is on an expired hosting account - so I just removed and manually installed the 5.3.1.1 version and added the correct info in the site.php file. Wonderfully, this worked and I could navigate around the restored site, however when I went to log in I found out the username or password had changed, so I wasn't able to go about the upgrade at the moment (the reset email address is my friend's rather than mine…). What I can say from memory about the process was much more involved than just clicking yes to confirm - the functionality to bring in the updated version wasn't part of the package, you'd have to bring this in through ftp, etc. Wordpress used to be this way but that changed some time ago. What I'm saying is I'm surprised to see the difference between the C5 user experience of editing content vs that of maintenance.
thanks for replying to my question - it did prompt me into resolving the problem! :)
thanks for replying to my question - it did prompt me into resolving the problem! :)
Happy to hear you got it worked out!
Actually in 5.4.x the update process is managed through the dashboard...
Please keep in mind that Concrete is still a relatively young project. While this means that they have been able to get a lot of things right, improving on what has come before, it also means that a little patience might be required as the project matures.
The old update process is really not so bad... I would strongly suggest you do this now before you relaunch this site as it may save you some headaches in the future. Also you have your db and site already nicely backed-up in the unlikely event anything goes wonky on you.
There are a raft of improvements and new features in the newest version...
Best wishes to you.
Actually in 5.4.x the update process is managed through the dashboard...
Please keep in mind that Concrete is still a relatively young project. While this means that they have been able to get a lot of things right, improving on what has come before, it also means that a little patience might be required as the project matures.
The old update process is really not so bad... I would strongly suggest you do this now before you relaunch this site as it may save you some headaches in the future. Also you have your db and site already nicely backed-up in the unlikely event anything goes wonky on you.
There are a raft of improvements and new features in the newest version...
Best wishes to you.
I've come back around to take this install through these steps - only to find what I guess came up two months ago - in trying to move to 5.3.3 (dashboard says "You are running 5.3.2.") yet when I move the new, or rather next "concrete" folder into place and visit the index.php/tools/required/upgrade url, I get this message across the top:
Warning: Call-time pass-by-reference has been deprecated in /home/USER/MYDOMAIN.com/concrete/models/attribute/key.php on line 247
(that line is "$q = $db->GetInsertSQL(&$rs, $columnHeaders);" btw - I don't know what to do with it) and this is what is says below the message above:
Upgrade Concrete5
You must first upgrade your site to version 5.3.2
- which is where it reports being, 5.3.2, I don't know what to do
Warning: Call-time pass-by-reference has been deprecated in /home/USER/MYDOMAIN.com/concrete/models/attribute/key.php on line 247
(that line is "$q = $db->GetInsertSQL(&$rs, $columnHeaders);" btw - I don't know what to do with it) and this is what is says below the message above:
Upgrade Concrete5
You must first upgrade your site to version 5.3.2
- which is where it reports being, 5.3.2, I don't know what to do
I don't think it makes any sense to do any trouble-shooting at all until that's resolved!
What problems were you having upgrading?