error installing 8.0
Permalink
Hi C5
Istalled 5.7.10. Upgrade via placing version 8.0 Concrete folder in the upgrades directory, going to dashboard>system and settings> update Concrete5.
I get this right after hitting the install button:
Doctrine\DBAL\Exception\InvalidFieldNameException thrown with message "An exception occurred while executing 'select Pages.cID, Pages.pkgID, Pages.siteTreeID, Pages.cPointerID, Pages.cPointerExternalLink, Pages.cIsActive, Pages.cIsSystemPage, Pages.cPointerExternalLinkNewWindow, Pages.cFilename, Pages.ptID, Collections.cDateAdded, Pages.cDisplayOrder, Collections.cDateModified, cInheritPermissionsFromCID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cCheckedOutUID, cIsTemplate, uID, cPath, cParentID, cChildren, cCacheFullPageContent, cCacheFullPageContentOverrideLifetime, cCacheFullPageContentLifetimeCustom from Pages inner join Collections on Pages.cID = Collections.cID left join PagePaths on (Pages.cID = PagePaths.cID and PagePaths.ppIsCanonical = 1) where Pages.cID = ?' with params ["4"]:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Pages.siteTreeID' in 'field list'"
Stacktrace:
#17 Doctrine\DBAL\Exception\InvalidFieldNameException in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71
#16 Doctrine\DBAL\Driver\AbstractMySQLDriver:convertException in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:116
#15 Doctrine\DBAL\DBALException:driverExceptionDuringQuery in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:836
#14 Doctrine\DBAL\Driver\PDOException in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93
#13 PDOException in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91
#12 PDOStatement:execute in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91
#11 Doctrine\DBAL\Driver\PDOStatement:execute in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:830
#10 Doctrine\DBAL\Connection:executeQuery in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/src/Page/Page.php:145
#9 Concrete\Core\Page\Page:populatePage in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/src/Page/Page.php:120
#8 Concrete\Core\Page\Page:getByID in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/src/Page/Page.php:99
#7 Concrete\Core\Page\Page:getByPath in /home/arvcon1/public_html/packages/webli_enhanced_toolbar/controller.php:96
#6 Concrete\Package\WebliEnhancedToolbar\Controller:on_start in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/src/Application/Application.php:313
#5 Concrete\Core\Application\Application:setupPackages in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/src/Foundation/Runtime/Run/DefaultRunner.php:47
#4 Concrete\Core\Foundation\Runtime\Run\DefaultRunner:run in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/src/Foundation/Runtime/DefaultRuntime.php:102
#3 Concrete\Core\Foundation\Runtime\DefaultRuntime:run in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/dispatcher.php:39
#2 require in /home/arvcon1/public_html/concrete/bootstrap/configure.php:52
#1 require in /home/arvcon1/public_html/concrete/dispatcher.php:18
#0 require in /home/arvcon1/public_html/index.php:2
What to do? I have tried 3x to install and consistently get the same error.
Istalled 5.7.10. Upgrade via placing version 8.0 Concrete folder in the upgrades directory, going to dashboard>system and settings> update Concrete5.
I get this right after hitting the install button:
Doctrine\DBAL\Exception\InvalidFieldNameException thrown with message "An exception occurred while executing 'select Pages.cID, Pages.pkgID, Pages.siteTreeID, Pages.cPointerID, Pages.cPointerExternalLink, Pages.cIsActive, Pages.cIsSystemPage, Pages.cPointerExternalLinkNewWindow, Pages.cFilename, Pages.ptID, Collections.cDateAdded, Pages.cDisplayOrder, Collections.cDateModified, cInheritPermissionsFromCID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cCheckedOutUID, cIsTemplate, uID, cPath, cParentID, cChildren, cCacheFullPageContent, cCacheFullPageContentOverrideLifetime, cCacheFullPageContentLifetimeCustom from Pages inner join Collections on Pages.cID = Collections.cID left join PagePaths on (Pages.cID = PagePaths.cID and PagePaths.ppIsCanonical = 1) where Pages.cID = ?' with params ["4"]:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Pages.siteTreeID' in 'field list'"
Stacktrace:
#17 Doctrine\DBAL\Exception\InvalidFieldNameException in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71
#16 Doctrine\DBAL\Driver\AbstractMySQLDriver:convertException in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:116
#15 Doctrine\DBAL\DBALException:driverExceptionDuringQuery in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:836
#14 Doctrine\DBAL\Driver\PDOException in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93
#13 PDOException in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91
#12 PDOStatement:execute in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91
#11 Doctrine\DBAL\Driver\PDOStatement:execute in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:830
#10 Doctrine\DBAL\Connection:executeQuery in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/src/Page/Page.php:145
#9 Concrete\Core\Page\Page:populatePage in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/src/Page/Page.php:120
#8 Concrete\Core\Page\Page:getByID in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/src/Page/Page.php:99
#7 Concrete\Core\Page\Page:getByPath in /home/arvcon1/public_html/packages/webli_enhanced_toolbar/controller.php:96
#6 Concrete\Package\WebliEnhancedToolbar\Controller:on_start in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/src/Application/Application.php:313
#5 Concrete\Core\Application\Application:setupPackages in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/src/Foundation/Runtime/Run/DefaultRunner.php:47
#4 Concrete\Core\Foundation\Runtime\Run\DefaultRunner:run in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/src/Foundation/Runtime/DefaultRuntime.php:102
#3 Concrete\Core\Foundation\Runtime\DefaultRuntime:run in /home/arvcon1/public_html/updates/concrete5-8.0.0/concrete/dispatcher.php:39
#2 require in /home/arvcon1/public_html/concrete/bootstrap/configure.php:52
#1 require in /home/arvcon1/public_html/concrete/dispatcher.php:18
#0 require in /home/arvcon1/public_html/index.php:2
What to do? I have tried 3x to install and consistently get the same error.
This could be due to blocks (e.g. in packages you are using) which contain db.xlm files which are still based on AXMLS XML. It seems that these files need to be converted to Doctrine XML before the upgrade to version 8 is done (in my case at least this resolved the problem). An online tool to convert db.xml files based on AXMLS XML to Doctrine XML you find here:http://concrete5.github.io/doctrine-xml/...
@pichan,
I am sorry to not have acknowledged your reply earlier but I only saw it now - thanks for taking the time to help.
Question: Is it only those db.xml files located in the root/packages directory? I do have 2 add-ons that contain files with those extensions, but there are a few others elsewhere, too.
Marc
I am sorry to not have acknowledged your reply earlier but I only saw it now - thanks for taking the time to help.
Question: Is it only those db.xml files located in the root/packages directory? I do have 2 add-ons that contain files with those extensions, but there are a few others elsewhere, too.
Marc
m
@pichan: Thanks so much for that information, it solved the problem for me!
Fortunately the site that i was upgrading from 5.7 to 8.0.3 wasn't a productive one, because i had to uninstall all suspected add-ons prior to upgrading in order to get rid of that error, since it was not possible to update them to the latest, v8 compatible C5 version while running concrete5 5.7.
Not the ideal procedure for a live site...
Fortunately the site that i was upgrading from 5.7 to 8.0.3 wasn't a productive one, because i had to uninstall all suspected add-ons prior to upgrading in order to get rid of that error, since it was not possible to update them to the latest, v8 compatible C5 version while running concrete5 5.7.
Not the ideal procedure for a live site...
