Fatal Error message
Permalink
I recently installed the update 5.4.1 and then i created a system backup. I then switched themes and this morning i found that some information on the pages of my site were gone. So I began the system backup recovery. Now I receive this message:
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 = '22'") ' in /home1/thehomg9/public_html/the-homes-tead/updates/concrete5.4.1. in /home1/thehomg9/public_html/the-homes-tead/updates/concrete5.4.1.1/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
I need to fix this ASAP my website is a very important source of income for me since it is an affiliate website. If someone can respond to this post or email me atwww.www.the_home_stead@yahoo.com... that would be greatly appreciated.
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 = '22'") ' in /home1/thehomg9/public_html/the-homes-tead/updates/concrete5.4.1. in /home1/thehomg9/public_html/the-homes-tead/updates/concrete5.4.1.1/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
I need to fix this ASAP my website is a very important source of income for me since it is an affiliate website. If someone can respond to this post or email me atwww.www.the_home_stead@yahoo.com... that would be greatly appreciated.
I would rollback the update, but the fatal error message is what i get when i go to any part of my website, including the concrete dashboard. I can't access the system recovery menu either. Any more suggestions?
downgrade by removing the line referencing 5.4.1.1 in config/site.php
Thanks nteaviation! I only wish I would have found your solution before I tried others and made things worse. Having to recover from my earlier mistakes, I'll document my recovery here for the sake of those that may fall into the same trap:
I first saw the same error as reported in this original post. Not knowing the cause, I first tried to refresh the site from my local folders using Dreamweaver. For some reason, this broke my connection with the database. So next I saw an error similar to this one (copied from another post at:http://www.concrete5.org/community/forums/chat/database-error1... when trying to browse to my site:
"Catchable fatal error: Argument 1 passed to ConfigStore::__construct() must be an instance of Database, null given, called in D:\Hosting\5063581\html\concrete\models\config.php on line 48 and defined in D:\Hosting\5063581\html\concrete\models\config.php on line 136"
1) So, to repair my connection, I decided to backup my entire C5 installation using my host's archive program, compressing everything into one handy file and downloading it to my local drive.
2) Next, I exported my database using phpMyAdmin and downloaded it to my local drive.
3) Then, I installed a fresh copy of C5 version 5.4.2.2, in a new location, creating a new empty database as well. (I had decided to move the site to a new server while fixing it. You may want to delete your current installation before installing the new one. But be sure you have good backups of everything first. I like the idea of leaving my old installation in tact until the new one is up and running)
4) Next, I made a backup of the new /config/site.php file.
5) Then, I uploaded my compressed site backup file to the root folder of my new C5 installation and uncompressed it, overwriting the new C5 install.
6) Almost done, I edited the /config/site.php replacing the values for "DB_USERNAME", "DB_PASSWORD" and "DB_DATABASE" with the corresponding values in the backup site.php file saved earlier. Save and upload.
7) Browsing to the site confirmed that I was back square one with the original error I saw first which, again, is identical to the one at the top of this post.
8) Last, to correct this condition, I dropped this command into the url: "http://www.yoursite.com/index.php/tools/required/upgrade.php" ( replace "www.yoursite.com" with your domain, of course) and followed the prompts to complete the upgrade.
After this my site was whole again, and updated to the latest version!
Many pieces of this correction can be found in other posts, but I thought it would be good to document it all in one place, step by step, as it worked for me.
Hope this helps someone else avoid the hours of horsin' around I went through.
I first saw the same error as reported in this original post. Not knowing the cause, I first tried to refresh the site from my local folders using Dreamweaver. For some reason, this broke my connection with the database. So next I saw an error similar to this one (copied from another post at:http://www.concrete5.org/community/forums/chat/database-error1... when trying to browse to my site:
"Catchable fatal error: Argument 1 passed to ConfigStore::__construct() must be an instance of Database, null given, called in D:\Hosting\5063581\html\concrete\models\config.php on line 48 and defined in D:\Hosting\5063581\html\concrete\models\config.php on line 136"
1) So, to repair my connection, I decided to backup my entire C5 installation using my host's archive program, compressing everything into one handy file and downloading it to my local drive.
2) Next, I exported my database using phpMyAdmin and downloaded it to my local drive.
3) Then, I installed a fresh copy of C5 version 5.4.2.2, in a new location, creating a new empty database as well. (I had decided to move the site to a new server while fixing it. You may want to delete your current installation before installing the new one. But be sure you have good backups of everything first. I like the idea of leaving my old installation in tact until the new one is up and running)
4) Next, I made a backup of the new /config/site.php file.
5) Then, I uploaded my compressed site backup file to the root folder of my new C5 installation and uncompressed it, overwriting the new C5 install.
6) Almost done, I edited the /config/site.php replacing the values for "DB_USERNAME", "DB_PASSWORD" and "DB_DATABASE" with the corresponding values in the backup site.php file saved earlier. Save and upload.
7) Browsing to the site confirmed that I was back square one with the original error I saw first which, again, is identical to the one at the top of this post.
8) Last, to correct this condition, I dropped this command into the url: "http://www.yoursite.com/index.php/tools/required/upgrade.php" ( replace "www.yoursite.com" with your domain, of course) and followed the prompts to complete the upgrade.
After this my site was whole again, and updated to the latest version!
Many pieces of this correction can be found in other posts, but I thought it would be good to document it all in one place, step by step, as it worked for me.
Hope this helps someone else avoid the hours of horsin' around I went through.
Your Welcome! Glad you got your site running again :) Re-running the "upgrade process" has saved my tail a few times. If it does not fix the problem then it may give you insight into what the issue may be.
http://www.yoursite.com/index.php/tools/required/upgrade.php...
Or: rollback your update and reload a MySQL Database backup that was done before you did the update.