Hallo! Ich bekomme nach einem Update folgende Fehlermeldung:
Kann mir jemand weiter helfen was zu tun ist???
Hallo! Ich bekomme nach einem Update folgende Fehlermeldung:
CRITICAL
Message:
An exception occurred while executing 'SELECT page.id, page.description, page.link, page.target, page.parentID, groups.key as `group`, mapping.key as mapping FROM s_cms_static page LEFT JOIN s_cms_static_groups groups ON groups.active = 1 LEFT JOIN s_cms_static_groups mapping ON groups.mapping_id = mapping.id LEFT JOIN s_core_shop_pages shops ON groups.id = shops.group_id AND shops.shop_id = ? WHERE (groups.active = 1) AND (page.active = 1) AND (CONCAT('|', page.grouping, '|') LIKE CONCAT('%|', groups.key, '|%')) AND ((mapping.id IS NULL OR shops.shop_id IS NOT NULL)) AND ((mapping.id IS NULL OR mapping.active=1)) AND ((page.shop_ids IS NULL OR page.shop_ids LIKE ?)) ORDER BY parentID ASC, mapping.key ASC, page.position ASC, page.description ASC' with params [1, "%|1|%"]:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'page.active' in 'where clause'
Time:
2018-02-20T09:10:31.914833+0100
Channel:
core
request:
{
"uri": "/",
"method": "GET",
"query": [],
"post": []
}
session:
No session data available
CRITICAL
Message:
An exception occurred while executing 'SELECT page.id, page.description, page.link, page.target, page.parentID, groups.key as `group`, mapping.key as mapping FROM s_cms_static page LEFT JOIN s_cms_static_groups groups ON groups.active = 1 LEFT JOIN s_cms_static_groups mapping ON groups.mapping_id = mapping.id LEFT JOIN s_core_shop_pages shops ON groups.id = shops.group_id AND shops.shop_id = ? WHERE (groups.active = 1) AND (page.active = 1) AND (CONCAT('|', page.grouping, '|') LIKE CONCAT('%|', groups.key, '|%')) AND ((mapping.id IS NULL OR shops.shop_id IS NOT NULL)) AND ((mapping.id IS NULL OR mapping.active=1)) AND ((page.shop_ids IS NULL OR page.shop_ids LIKE ?)) ORDER BY parentID ASC, mapping.key ASC, page.position ASC, page.description ASC' with params [1, "%|1|%"]:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'page.active' in 'where clause'
Time:
2018-02-20T09:10:31.935557+0100
Channel:
core
request:
{
"uri": "/",
"method": "GET",
"query": [],
"post": []
}
session:
No session data available
ERROR
Message:
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'page.active' in 'where clause' in /var/www/vhosts/shopverzeichnissss/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:828
Stack trace:
#0 /var/www/vhosts/shopverzeichnissss/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(828): PDOStatement->execute()
#1 /var/www/vhosts/shopverzeichnissss/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Connection->executeQuery('SELECT page.id,...', Array, Array)
#2 /var/www/vhosts/shopverzeichnissss/httpdocs/engine/Shopware/Components/SitePageMenu.php(69): Doctrine\DBAL\Query\QueryBuilder->execute()
#3 /var/www/vhosts/shopverzeichnissss/httpdocs/engine/Shopware/Plugins/Default/Core/ControllerBase/Bootstrap.php(150): Shopware\Components\SitePageMenu->getTree(1, NULL)
#4 /var/www/vhosts/shopverzeichnissss/httpdocs/engine/Shopware/Plugins/Default/Core/ControllerBase/Bootstrap.php(87): Shopware_Plugins_Core_ControllerBase_Bootstrap->getMenu(1, NULL)
#5 /var/www/vhosts/shopverzeichnissss/httpdocs/engine/Library/Enlight/Event/Handler/Plugin.php(149): Shopware_Plugins_Core_ControllerBase_Bootstrap->onPostDispatch(Object(Enlight_Controller_ActionEventArgs))
#6 /var/www/vhosts/shopverzeichnissss/httpdocs/engine/Library/Enlight/Event/EventManager.php(218): Enlight_Event_Handler_Plugin->execute(Object(Enlight_Controller_ActionEventArgs))
#7 /var/www/vhosts/shopverzeichnissss/httpdocs/engine/Library/Enlight/Controller/Action.php(200): Enlight_Event_EventManager->notify('Enlight_Control...', Object(Enlight_Controller_ActionEventArgs))
#8 /var/www/vhosts/shopverzeichnissss/httpdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(530): Enlight_Controller_Action->dispatch('indexAction')
#9 /var/www/vhosts/shopverzeichnissss/httpdocs/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#10 /var/www/vhosts/shopverzeichnissss/httpdocs/engine/Shopware/Kernel.php(191): Enlight_Controller_Front->dispatch()
#11 /var/www/vhosts/shopverzeichnissss/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(484): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#12 /var/www/vhosts/shopverzeichnissss/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#13 /var/www/vhosts/shopverzeichnissss/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(441): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#14 /var/www/vhosts/shopverzeichnissss/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(337): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true)
#15 /var/www/vhosts/shopverzeichnissss/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(189): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#16 /var/www/vhosts/shopverzeichnissss/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(203): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#17 /var/www/vhosts/shopverzeichnissss/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(116): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#18 /var/www/vhosts/shopverzeichnissss/httpdocs/shopware.php(118): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#19 {main}
Next Doctrine\DBAL\DBALException: An exception occurred while executing 'SELECT page.id, page.description, page.link, page.target, page.parentID, groups.key as `group`, mapping.key as mapping FROM s_cms_static page LEFT JOIN s_cms_static_groups groups ON groups.active = 1 LEFT JOIN s_cms_static_groups mapping ON groups.mapping_id = mapping.id LEFT JOIN s_core_shop_pages shops ON groups.id = shops.group_id AND shops.shop_id = ? WHERE (groups.active = 1) AND (page.active = 1) AND (CONCAT('|', page.grouping, '|') LIKE CONCAT('%|', groups.key, '|%')) AND ((mapping.id IS NULL OR shops.shop_id IS NOT NULL)) AND ((mapping.id IS NULL OR mapping.active=1)) AND ((page.shop_ids IS NULL OR page.shop_ids LIKE ?)) ORDER BY parentID ASC, mapping.key ASC, page.position ASC, page.description ASC' with params [1, "%|1|%"]:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'page.active' in 'where clause' in /var/www/vhosts/shopverzeichnissss/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:119
Stack trace:
#0 /var/www/vhosts/shopverzeichnissss/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(836): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), 'SELECT page.id,...', Array)
#1 /var/www/vhosts/shopverzeichnissss/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Connection->executeQuery('SELECT page.id,...', Array, Array)
#2 /var/www/vhosts/shopverzeichnissss/httpdocs/engine/Shopware/Components/SitePageMenu.php(69): Doctrine\DBAL\Query\QueryBuilder->execute()
#3 /var/www/vhosts/shopverzeichnissss/httpdocs/engine/Shopware/Plugins/Default/Core/ControllerBase/Bootstrap.php(150): Shopware\Components\SitePageMenu->getTree(1, NULL)
#4 /var/www/vhosts/shopverzeichnissss/httpdocs/engine/Shopware/Plugins/Default/Core/ControllerBase/Bootstrap.php(87): Shopware_Plugins_Core_ControllerBase_Bootstrap->getMenu(1, NULL)
#5 /var/www/vhosts/shopverzeichnissss/httpdocs/engine/Library/Enlight/Event/Handler/Plugin.php(149): Shopware_Plugins_Core_ControllerBase_Bootstrap->onPostDispatch(Object(Enlight_Controller_ActionEventArgs))
#6 /var/www/vhosts/shopverzeichnissss/httpdocs/engine/Library/Enlight/Event/EventManager.php(218): Enlight_Event_Handler_Plugin->execute(Object(Enlight_Controller_ActionEventArgs))
#7 /var/www/vhosts/shopverzeichnissss/httpdocs/engine/Library/Enlight/Controller/Action.php(200): Enlight_Event_EventManager->notify('Enlight_Control...', Object(Enlight_Controller_ActionEventArgs))
#8......