Upgrade killed the site. Need help with how to fix it
Permalink
I was in the backend and saw a button to download the latest version which I clicked and then another button showed offering install the update. Then the site just stopped working. Now the home page shows the text below and the login is gone too. Any ideas how to fix it? Thanks
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 = '5'") ' in /home/derykmax/public_html/updates/concrete5.4.1.1/concrete/librar in /home/derykmax/public_html/updates/concrete5.4.1.1/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
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 = '5'") ' in /home/derykmax/public_html/updates/concrete5.4.1.1/concrete/librar in /home/derykmax/public_html/updates/concrete5.4.1.1/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
Thanks for the quick reply.
I did as you said but there is no "DIRNAME_UPDATES" line that I can see.
After re uploading the new concrete folder and going to that link you said, I clicked upgrade again and the same thing happenned.
Since there is no "DIRNAME_UPDATES" line in the config do you have any other ideas?
This is the site.php file....
<?php
define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'derykmax_derykdb');
define('DB_PASSWORD', 'password');
define('DB_DATABASE', 'derykmax_plumbing');
define('BASE_URL', 'http://derykmaxfieldplumbing.com.au');
define('DIR_REL', '');
define('PASSWORD_SALT', 'QZG0Of1J9im7SXJVaZYqC3MHopF25MBxh1NetSwvzvMxoUnjhxR6f4uaoWBTgGN4');
?><?php define('DIRNAME_APP_UPDATED', 'concrete5.4.1.1');?>
I did as you said but there is no "DIRNAME_UPDATES" line that I can see.
After re uploading the new concrete folder and going to that link you said, I clicked upgrade again and the same thing happenned.
Since there is no "DIRNAME_UPDATES" line in the config do you have any other ideas?
This is the site.php file....
<?php
define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'derykmax_derykdb');
define('DB_PASSWORD', 'password');
define('DB_DATABASE', 'derykmax_plumbing');
define('BASE_URL', 'http://derykmaxfieldplumbing.com.au');
define('DIR_REL', '');
define('PASSWORD_SALT', 'QZG0Of1J9im7SXJVaZYqC3MHopF25MBxh1NetSwvzvMxoUnjhxR6f4uaoWBTgGN4');
?><?php define('DIRNAME_APP_UPDATED', 'concrete5.4.1.1');?>
Looks like the line is DIRNAME_APP_UPDATED, comment out that line instead of the DIRNAME_UPDATES and use your old concrete folder to go back to your previous install. See if that helps.
Also, which version of concrete you were running before the upgrade?
Also, which version of concrete you were running before the upgrade?
yep that got the old site up and running again. Thanks The current version is 5.4.0.5.
Make sure you backup your current DB before trying anything.
It seems like your upgrade/install is missing some files, make a back up of your DB and download the 5.4.1.1 version, unzip and upload only the concrete core folder to your root folder but first rename your old concrete folder to something like concreteOLD, then on your site.php file under your config folder comment out the line that starts with "DIRNAME_UPDATES" if you have that line.
Them re-run the upgrade by going to:
http://yoursite.com/index.php/tools/required/upgrade...
IF that does not work you can comment out the line that starts with "DIRNAME_UPDATES" on your site.php file and rename back to concrete your concreteOLD folder if you changed the name as per the instructions above that will run your site on your previous concrete version before the upgrade.