Hallo, nach der Installation von Shopware 5.0.4 wird folgende Fehlermeldung im Frontend angezeigt: Ups! Ein Fehler ist aufgetreten! Wir wurden bereits über das Problem informiert und arbeiten an einer Lösung, bitte versuchen Sie es in Kürze erneut. Das Backend ist erreichbar, die Systemvoraussetzungen sind alle erfüllt. Bei der Installation ist habe ich folgende Fehlermeldung erhalten: SQLSTATE [HY000] [2002] No such fole or directory Nachdem ich den Datenbank Server von localhost auf 127.0.0.1 geändert habe, wurde die Installation ohne Fehler abgeschlossen. Der Fehler-Log zeigt folgende Fehlermeldung: exception ‘PDOException’ with message ‘SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘meta’ in ‘field list’’ in /www2/www.demoseite.info/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:699 Stack trace: #0 /www2/www.demoseite.info/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(699): PDO->query(‘SELECT id as id…’) #1 /www2/www.demoseite.info/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(630): Doctrine\DBAL\Connection->executeQuery(‘SELECT id as id…’, Array, Array) #2 /www2/www.demoseite.info/engine/Shopware/Bundle/SearchBundleDBAL/SearchTerm/SearchIndexer.php(146): Doctrine\DBAL\Connection->fetchAll(‘SELECT id as id…’) #3 /www2/www.demoseite.info/engine/Shopware/Bundle/SearchBundleDBAL/SearchTerm/SearchIndexer.php(105): Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchIndexer->build() #4 /www2/www.demoseite.info/engine/Shopware/Bundle/SearchBundleDBAL/SearchTerm/SearchTermQueryBuilder.php(76): Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchIndexer->validate() #5 /www2/www.demoseite.info/cache/production_201509160944/proxies/ShopwareProductionProjectContainer.php(752): Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchTermQueryBuilder->__construct(Object(Shopware_Components_Config), Object(Doctrine\DBAL\Connection), Object(Shopware\Bundle\SearchBundleDBAL\SearchTerm\CacheKeywordFinder), Object(Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchIndexer)) #6 /www2/www.demoseite.info/vendor/symfony/dependency-injection/Symfony/Component/DependencyInjection/Container.php(327): ShopwareProductionProjectContainer->getShopwareSearchdbal_SearchQueryBuilderDbalService() #7 /www2/www.demoseite.info/engine/Shopware/Components/DependencyInjection/Container.php(253): Symfony\Component\DependencyInjection\Container->get(‘shopware_search…’) #8 /www2/www.demoseite.info/engine/Shopware/Components/DependencyInjection/Container.php(199): Shopware\Components\DependencyInjection\Container->load(‘shopware_search…’) #9 /www2/www.demoseite.info/cache/production_201509160944/proxies/ShopwareProductionProjectContainer.php(740): Shopware\Components\DependencyInjection\Container->get(‘shopware_search…’) #10 /www2/www.demoseite.info/vendor/symfony/dependency-injection/Symfony/Component/DependencyInjection/Container.php(327): ShopwareProductionProjectContainer->getShopwareSearchdbal_SearchConditionHandlerDbalService() #11 /www2/www.demoseite.info/engine/Shopware/Components/DependencyInjection/Container.php(253): Symfony\Component\DependencyInjection\Container->get(‘shopware_search…’) #12 /www2/www.demoseite.info/engine/Shopware/Components/DependencyInjection/Container.php(199): Shopware\Components\DependencyInjection\Container->load(‘shopware_search…’) #13 /www2/www.demoseite.info/cache/production_201509160944/proxies/ShopwareProductionProjectContainer.php(668): Shopware\Components\DependencyInjection\Container->get(‘shopware_search…’) #14 /www2/www.demoseite.info/vendor/symfony/dependency-injection/Symfony/Component/DependencyInjection/Container.php(327): ShopwareProductionProjectContainer->getShopwareSearchdbal_DbalQueryBuilderFactoryService() #15 /www2/www.demoseite.info/engine/Shopware/Components/DependencyInjection/Container.php(253): Symfony\Component\DependencyInjection\Container->get(‘shopware_search…’) #16 /www2/www.demoseite.info/engine/Shopware/Components/DependencyInjection/Container.php(199): Shopware\Components\DependencyInjection\Container->load(‘shopware_search…’) #17 /www2/www.demoseite.info/cache/production_201509160944/proxies/ShopwareProductionProjectContainer.php(636): Shopware\Components\DependencyInjection\Container->get(‘shopware_search…’) #18 /www2/www.demoseite.info/vendor/symfony/dependency-injection/Symfony/Component/DependencyInjection/Container.php(327): ShopwareProductionProjectContainer->getShopwareSearch_ProductNumberSearchService() #19 /www2/www.demoseite.info/engine/Shopware/Components/DependencyInjection/Container.php(253): Symfony\Component\DependencyInjection\Container->get(‘shopware_search…’) #20 /www2/www.demoseite.info/engine/Shopware/Components/DependencyInjection/Container.php(199): Shopware\Components\DependencyInjection\Container->load(‘shopware_search…’) #21 /www2/www.demoseite.info/engine/Shopware/Core/sArticles.php(199): Shopware\Components\DependencyInjection\Container->get(‘shopware_search…’) #22 /www2/www.demoseite.info/engine/Shopware/Components/Modules.php(73): sArticles->__construct() #23 /www2/www.demoseite.info/engine/Shopware/Components/Modules.php(95): Shopware_Components_Modules->loadModule(‘sArticles’) #24 /www2/www.demoseite.info/engine/Shopware/Components/Modules.php(149): Shopware_Components_Modules->getModule(‘Articles’) #25 /www2/www.demoseite.info/engine/Shopware/Controllers/Widgets/Compare.php(32): Shopware_Components_Modules->Articles() #26 /www2/www.demoseite.info/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Widgets_Compare->indexAction() #27 /www2/www.demoseite.info/engine/Library/Enlight/Controller/Dispatcher/Default.php(524): Enlight_Controller_Action->dispatch(‘indexAction’) #28 /www2/www.demoseite.info/engine/Library/Enlight/Template/Plugins/function.action.php(97): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #29 /www2/www.demoseite.info/cache/production_201509160944/templates/frontend_emotion_black_de_DE_1/bf/33/2d/bf332d1935e1eb40a53ed16f92d0ae5f79072ae0.snippet.index.tpl.php(200): smarty_function_action(Array, Object(Enlight_Template_Default)) #30 /www2/www.demoseite.info/engine/Library/Smarty/sysplugins/smarty_internal_templatebase.php(180): content_560c49d3c835b2_56040658(Object(Enlight_Template_Default)) #31 /www2/www.demoseite.info/engine/Library/Enlight/View/Default.php(274): Smarty_Internal_TemplateBase->fetch() #32 /www2/www.demoseite.info/engine/Library/Enlight/Controller/Plugins/ViewRenderer/Bootstrap.php(216): Enlight_View_Default->render(Object(Enlight_Template_Default)) #33 /www2/www.demoseite.info/engine/Library/Enlight/Controller/Plugins/ViewRenderer/Bootstrap.php(242): Enlight_Controller_Plugins_ViewRenderer_Bootstrap->renderTemplate(Object(Enlight_Template_Default)) #34 /www2/www.demoseite.info/engine/Library/Enlight/Controller/Plugins/ViewRenderer/Bootstrap.php(136): Enlight_Controller_Plugins_ViewRenderer_Bootstrap->render() #35 [internal function]: Enlight_Controller_Plugins_ViewRenderer_Bootstrap->onPostDispatch(Object(Enlight_Controller_ActionEventArgs)) #36 /www2/www.demoseite.info/engine/Library/Enlight/Event/Handler/Default.php(91): call_user_func(Array, Object(Enlight_Controller_ActionEventArgs)) #37 /www2/www.demoseite.info/engine/Library/Enlight/Event/EventManager.php(211): Enlight_Event_Handler_Default->execute(Object(Enlight_Controller_ActionEventArgs)) #38 /www2/www.demoseite.info/engine/Library/Enlight/Controller/Action.php(202): Enlight_Event_EventManager->notify(‘Enlight_Control…’, Object(Enlight_Controller_ActionEventArgs)) #39 /www2/www.demoseite.info/engine/Library/Enlight/Controller/Dispatcher/Default.php(524): Enlight_Controller_Action->dispatch(‘genericErrorAct…’) #40 /www2/www.demoseite.info/engine/Library/Enlight/Controller/Front.php(227): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #41 /www2/www.demoseite.info/engine/Shopware/Kernel.php(143): Enlight_Controller_Front->dispatch() #42 /www2/www.demoseite.info/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(490): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #43 /www2/www.demoseite.info/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #44 /www2/www.demoseite.info/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(447): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #45 /www2/www.demoseite.info/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(347): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #46 /www2/www.demoseite.info/engine/Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #47 /www2/www.demoseite.info/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(211): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #48 /www2/www.demoseite.info/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #49 /www2/www.demoseite.info/shopware.php(101): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #50 {main} Next exception ‘Doctrine\DBAL\DBALException’ with message ‘An exception occurred while executing ‘SELECT id as id, meta FROM s_categories’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘meta’ in ‘field list’’ in /www2/www.demoseite.info/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 Stack trace: #0 /www2/www.demoseite.info/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), ‘SELECT id as id…’, Array) #1 /www2/www.demoseite.info/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(630): Doctrine\DBAL\Connection->executeQuery(‘SELECT id as id…’, Array, Array) #2 /www2/www.demoseite.info/engine/Shopware/Bundle/SearchBundleDBAL/SearchTerm/SearchIndexer.php(146): Doctrine\DBAL\Connection->fetchAll(‘SELECT id as id…’) #3 /www2/www.demoseite.info/engine/Shopware/Bundle/SearchBundleDBAL/SearchTerm/SearchIndexer.php(105): Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchIndexer->build() #4 /www2/www.demoseite.info/engine/Shopware/Bundle/SearchBundleDBAL/SearchTerm/SearchTermQueryBuilder.php(76): Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchIndexer->validate() #5 /www2/www.demoseite.info/cache/production_201509160944/proxies/ShopwareProductionProjectContainer.php(752): Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchTermQueryBuilder->__construct(Object(Shopware_Components_Config), Object(Doctrine\DBAL\Connection), Object(Shopware\Bundle\SearchBundleDBAL\SearchTerm\CacheKeywordFinder), Object(Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchIndexer)) #6 /www2/www.demoseite.info/vendor/symfony/dependency-injection/Symfony/Component/DependencyInjection/Container.php(327): ShopwareProductionProjectContainer->getShopwareSearchdbal_SearchQueryBuilderDbalService() #7 /www2/www.demoseite.info/engine/Shopware/Components/DependencyInjection/Container.php(253): Symfony\Component\DependencyInjection\Container->get(‘shopware_search…’) #8 /www2/www.demoseite.info/engine/Shopware/Components/DependencyInjection/Container.php(199): Shopware\Components\DependencyInjection\Container->load(‘shopware_search…’) #9 /www2/www.demoseite.info/cache/production_201509160944/proxies/ShopwareProductionProjectContainer.php(740): Shopware\Components\DependencyInjection\Container->get(‘shopware_search…’) #10 /www2/www.demoseite.info/vendor/symfony/dependency-injection/Symfony/Component/DependencyInjection/Container.php(327): ShopwareProductionProjectContainer->getShopwareSearchdbal_SearchConditionHandlerDbalService() #11 /www2/www.demoseite.info/engine/Shopware/Components/DependencyInjection/Container.php(253): Symfony\Component\DependencyInjection\Container->get(‘shopware_search…’) #12 /www2/www.demoseite.info/engine/Shopware/Components/DependencyInjection/Container.php(199): Shopware\Components\DependencyInjection\Container->load(‘shopware_search…’) #13 /www2/www.demoseite.info/cache/production_201509160944/proxies/ShopwareProductionProjectContainer.php(668): Shopware\Components\DependencyInjection\Container->get(‘shopware_search…’) #14 /www2/www.demoseite.info/vendor/symfony/dependency-injection/Symfony/Component/DependencyInjection/Container.php(327): ShopwareProductionProjectContainer->getShopwareSearchdbal_DbalQueryBuilderFactoryService() #15 /www2/www.demoseite.info/engine/Shopware/Components/DependencyInjection/Container.php(253): Symfony\Component\DependencyInjection\Container->get(‘shopware_search…’) #16 /www2/www.demoseite.info/engine/Shopware/Components/DependencyInjection/Container.php(199): Shopware\Components\DependencyInjection\Container->load(‘shopware_search…’) #17 /www2/www.demoseite.info/cache/production_201509160944/proxies/ShopwareProductionProjectContainer.php(636): Shopware\Components\DependencyInjection\Container->get(‘shopware_search…’) #18 /www2/www.demoseite.info/vendor/symfony/dependency-injection/Symfony/Component/DependencyInjection/Container.php(327): ShopwareProductionProjectContainer->getShopwareSearch_ProductNumberSearchService() #19 /www2/www.demoseite.info/engine/Shopware/Components/DependencyInjection/Container.php(253): Symfony\Component\DependencyInjection\Container->get(‘shopware_search…’) #20 /www2/www.demoseite.info/engine/Shopware/Components/DependencyInjection/Container.php(199): Shopware\Components\DependencyInjection\Container->load(‘shopware_search…’) #21 /www2/www.demoseite.info/engine/Shopware/Core/sArticles.php(199): Shopware\Components\DependencyInjection\Container->get(‘shopware_search…’) #22 /www2/www.demoseite.info/engine/Shopware/Components/Modules.php(73): sArticles->__construct() #23 /www2/www.demoseite.info/engine/Shopware/Components/Modules.php(95): Shopware_Components_Modules->loadModule(‘sArticles’) #24 /www2/www.demoseite.info/engine/Shopware/Components/Modules.php(149): Shopware_Components_Modules->getModule(‘Articles’) #25 /www2/www.demoseite.info/engine/Shopware/Controllers/Widgets/Compare.php(32): Shopware_Components_Modules->Articles() #26 /www2/www.demoseite.info/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Widgets_Compare->indexAction() #27 /www2/www.demoseite.info/engine/Library/Enlight/Controller/Dispatcher/Default.php(524): Enlight_Controller_Action->dispatch(‘indexAction’) #28 /www2/www.demoseite.info/engine/Library/Enlight/Template/Plugins/function.action.php(97): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #29 /www2/www.demoseite.info/cache/production_201509160944/templates/frontend_emotion_black_de_DE_1/bf/33/2d/bf332d1935e1eb40a53ed16f92d0ae5f79072ae0.snippet.index.tpl.php(200): smarty_function_action(Array, Object(Enlight_Template_Default)) #30 /www2/www.demoseite.info/engine/Library/Smarty/sysplugins/smarty_internal_templatebase.php(180): content_560c49d3c835b2_56040658(Object(Enlight_Template_Default)) #31 /www2/www.demoseite.info/engine/Library/Enlight/View/Default.php(274): Smarty_Internal_TemplateBase->fetch() #32 /www2/www.demoseite.info/engine/Library/Enlight/Controller/Plugins/ViewRenderer/Bootstrap.php(216): Enlight_View_Default->render(Object(Enlight_Template_Default)) #33 /www2/www.demoseite.info/engine/Library/Enlight/Controller/Plugins/ViewRenderer/Bootstrap.php(242): Enlight_Controller_Plugins_ViewRenderer_Bootstrap->renderTemplate(Object(Enlight_Template_Default)) #34 /www2/www.demoseite.info/engine/Library/Enlight/Controller/Plugins/ViewRenderer/Bootstrap.php(136): Enlight_Controller_Plugins_ViewRenderer_Bootstrap->render() #35 [internal function]: Enlight_Controller_Plugins_ViewRenderer_Bootstrap->onPostDispatch(Object(Enlight_Controller_ActionEventArgs)) #36 /www2/www.demoseite.info/engine/Library/Enlight/Event/Handler/Default.php(91): call_user_func(Array, Object(Enlight_Controller_ActionEventArgs)) #37 /www2/www.demoseite.info/engine/Library/Enlight/Event/EventManager.php(211): Enlight_Event_Handler_Default->execute(Object(Enlight_Controller_ActionEventArgs)) #38 /www2/www.demoseite.info/engine/Library/Enlight/Controller/Action.php(202): Enlight_Event_EventManager->notify(‘Enlight_Control…’, Object(Enlight_Controller_ActionEventArgs)) #39 /www2/www.demoseite.info/engine/Library/Enlight/Controller/Dispatcher/Default.php(524): Enlight_Controller_Action->dispatch(‘genericErrorAct…’) #40 /www2/www.demoseite.info/engine/Library/Enlight/Controller/Front.php(227): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #41 /www2/www.demoseite.info/engine/Shopware/Kernel.php(143): Enlight_Controller_Front->dispatch() #42 /www2/www.demoseite.info/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(490): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #43 /www2/www.demoseite.info/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #44 /www2/www.demoseite.info/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(447): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #45 /www2/www.demoseite.info/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(347): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #46 /www2/www.demoseite.info/engine/Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #47 /www2/www.demoseite.info/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(211): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #48 /www2/www.demoseite.info/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #49 /www2/www.demoseite.info/shopware.php(101): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #50 {main} Time: 2015-09-30T22:45:16.479743+0200 Channel: core request: { “uri”: “/”, “method”: “GET”, “query”: , “post”: } session: { “sessionId”: “7e60606e12bb67acdf4b884a8217bf77ae8f2853”, “Bot”: false, “sOutputNet”: false, “sUserId”: null } shopId: 1 shopName: demoseite.info Wie kann der Fehler behoben werden? Grüße Dirk
Ich vermute, da ist bei der Instalation etwas schief gegangen. Am besten leerst Du die Datenbank und führst die Installation nochmal durch.
Evtl. MariaDB mit group_concat_max_len = 4? Siehe administration-f102/shopware5-und-mariadb-t31076.html