Unexpected Error occurred while upgrading :'(
Permalink
Hi,
Today I attempted to upgrade from 5.3.3.1 to 5.4.1 but failed sadly.
When going to the upgrade URL and running the scripts i got the following error....
I have attempted to exicute this within the MySQL query browser but failed again, not having much luck am I.
Anyhow if someone could point me in the write direction with this is would be much appreciated and would follow with a massive......THANKS!!!!
Cheers,
Chris
P.S. - I've attached screenshot
Today I attempted to upgrade from 5.3.3.1 to 5.4.1 but failed sadly.
When going to the upgrade URL and running the scripts i got the following error....
An Unexpected Error occurred while upgrading: 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 = 0")
I have attempted to exicute this within the MySQL query browser but failed again, not having much luck am I.
Anyhow if someone could point me in the write direction with this is would be much appreciated and would follow with a massive......THANKS!!!!
Cheers,
Chris
P.S. - I've attached screenshot
I upgraded straight from 5.3.3.1 to 5.4.1 as well and had problems too. I restored back to my backup and then upgraded to 5.4.0.5 then to 5.4.1..
Everything upgraded properly, but now I'm getting the following error when I try to update a page the second time (the first time it updates fine).
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '3-103' for key 1] in EXECUTE("insert into CollectionVersionBlockStyles (cID, cvID, bID, arHandle, csrID) values ('103', '24', '3', 'Header Nav', '0')") ' in /home/spencera/public_html/updates/concrete5.4.1/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home/spencera/public_html/updates/concrete5.4.1/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'insert into Col...', false, Object(ADODB_mysql)) #1 /home/spencera/public_html/updates/concrete5.4.1/concrete/libraries/3rdparty/adodb/adodb.inc.php(993): ADOConnection->_Execute('insert into Col...') #2 /home/spencera/public_html/updates/concrete5.4.1/concrete/libraries/database.php(73): ADOConnection->Execute('insert into Col...', Array) #3 /home/spencera/public_html/updates/concrete5.4.1/concrete/models/block.php(404): Database->__call(Array, Array) #4 /home/spencera/public_html/ in /home/spencera/public_html/updates/concrete5.4.1/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
Any ideas what might be the problem? Should I restore and try upgrading again or is there something specific that would fix this?
Thanks so much!
Everything upgraded properly, but now I'm getting the following error when I try to update a page the second time (the first time it updates fine).
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '3-103' for key 1] in EXECUTE("insert into CollectionVersionBlockStyles (cID, cvID, bID, arHandle, csrID) values ('103', '24', '3', 'Header Nav', '0')") ' in /home/spencera/public_html/updates/concrete5.4.1/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home/spencera/public_html/updates/concrete5.4.1/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'insert into Col...', false, Object(ADODB_mysql)) #1 /home/spencera/public_html/updates/concrete5.4.1/concrete/libraries/3rdparty/adodb/adodb.inc.php(993): ADOConnection->_Execute('insert into Col...') #2 /home/spencera/public_html/updates/concrete5.4.1/concrete/libraries/database.php(73): ADOConnection->Execute('insert into Col...', Array) #3 /home/spencera/public_html/updates/concrete5.4.1/concrete/models/block.php(404): Database->__call(Array, Array) #4 /home/spencera/public_html/ in /home/spencera/public_html/updates/concrete5.4.1/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
Any ideas what might be the problem? Should I restore and try upgrading again or is there something specific that would fix this?
Thanks so much!
Works......my hero!!!
Even after restoring my backup and upgrading step by step I still encountered issues. I found that once I cleared and restored my database from scratch this was resolved... Just an FYI for anyone else who comes across this issue.
hope this helps