Hallo
wir verwenden Shopware 5.2.21
Im Frontend erhalte ich folgende fehlermeldung nachdem ich den Cache geleert habe und im Frontend auf eine Kategorie klicke.
Was könnte die fehlermeldug auslösen?
Kann mir jemand weiterhelfen?
Ups! Ein Fehler ist aufgetreten!
Die nachfolgenden Hinweise sollten Ihnen weiterhelfen.
An exception occurred while executing 'INSERT IGNORE INTO s_search_index (keywordID, elementID, fieldID) SELECT sk.id as keywordID, 29919 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‘001091010’) UNION ALL SELECT sk.id as keywordID, 29920 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‘001091250’) UNION ALL SELECT sk.id as keywordID, 29921 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‘001092000’) UNION ALL SELECT sk.id as keywordID, 29922 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‘001093000’) UNION ALL SELECT sk.id as keywordID, 29923 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‘001093220’) UNION ALL SELECT sk.id as keywordID, 29924 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‘001093490’) UNION ALL SELECT sk.id as keywordID, 29925 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‘001094000’) UNION ALL SELECT sk.id as keywordID, 29926 as elementID, 5 as fieldID…
Stack trace:
#0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(996): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‘INSERT IGNORE I…’, Array)
#1 engine/Shopware/Bundle/SearchBundleDBAL/SearchTerm/SearchIndexer.php(203): Doctrine\DBAL\Connection->executeUpdate(‘INSERT IGNORE I…’)
#2 engine/Shopware/Bundle/SearchBundleDBAL/SearchTerm/SearchIndexer.php(96): Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchIndexer->build()
#3 engine/Shopware/Bundle/SearchBundleDBAL/SearchTerm/SearchTermQueryBuilder.php(84): Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchIndexer->validate()
#4 var/cache/production_201703211201/proxies/ShopwareProductionda39a3ee5e6b4b0d3255bfef95601890afd80709ProjectContainer.php(1681): 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), Object(Shopware\Bundle\SearchBundleDBAL\SearchTerm\TermHelper))
#5 vendor/symfony/dependency-injection/Container.php(314): ShopwareProductionda39a3ee5e6b4b0d3255bfef95601890afd80709ProjectContainer->getShopwareSearchdbal_SearchQueryBuilderDbalService()
#6 engine/Shopware/Components/DependencyInjection/Container.php(182): Symfony\Component\DependencyInjection\Container->get(‘shopware_search…’, 1)
#7 engine/Shopware/Components/DependencyInjection/Container.php(138): Shopware\Components\DependencyInjection\Container->doLoad(‘shopware_search…’, 1)…