Hallo zusammen,
unsere Suche geht auf einmal nicht mehr. Im Shop (5.5.10 auf einem Timme nginx Server) wurde die letzten 8 Tage nichts aktualisiert oder verändert, d.h. von der Seite gab es keine Veränderungen.
Wenn man explizit nach einer Artikelnummer sucht so wird diese gefunden. Wenn man nach einem Wort/Begriff sucht dreht sich im Suchfeld der Kreis abert nichts passiert.
Wenn man im Backend den Suchindex unter Einstellungen neu aufbauen will kommt eine 503er Service unavailable Meldung. Wenn man es im SW “Intelligente Suche” Plugin über die
Vorschau versucht kommt im Plugin folgende Fehlermeldung (gekürzt weil Original zu lang):
Widgets
Seite
von 0
Keine Daten vorhanden
Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing 'SELECT SQL_CALC_FOUND_ROWS product.id as __product_id, variant.id as__ variant_id, variant.ordernumber as __variant_ordernumber, searchTable.* FROM s_articles product INNER JOIN s_articles_details variant ON variant.id = product.main_detail_id AND variant.active = 1 AND product.active = 1 LEFT JOIN s_articles_avoid_customergroups avoidCustomerGroup ON avoidCustomerGroup.articleID = product.id AND avoidCustomerGroup.customerGroupId IN (?) INNER JOIN s_articles_categories_ro productCategory ON productCategory.articleID = product.id AND productCategory.categoryID IN (?) INNER JOIN (SELECT a.id as product_id, (sr.relevance + IF(a.topseller = 1, 1, 0) + IF(a.datum >= DATE_SUB(NOW(),INTERVAL 10 DAY), 1, 0)) as ranking, sr.keywords, sr.relevances, a.topseller as isTopSeller FROM (SELECT srd.articleID, SUM(srd.relevance) as relevance, GROUP_CONCAT(srd.keywordID) as keywords, GROUP_CONCAT(srd.relevance) as relevances, COUNT(DISTINCT term) as termCount FROM ( SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, si.elementID as articleID FROM (SELECT 50 as relevance, 'effic' as term, 403362937 as keywordID UNION ALL SELECT 50 as relevance, 'effic' as term, 403362942 as keywordID UNION ALL SELECT 44 as relevance, 'effic' as term, 403359741 as keywordID UNION ALL SELECT 44 as relevance, 'effic' as term, 403360277 as keywordID UNION ALL SELECT 44 as relevance, 'effic' as term, 403362208 as keywordID UNION ALL SELECT 40 as relevance, 'effic' as term, 403362156 as keywordID UNION ALL SELECT 40 as relevance, 'effic' as term, 403404611 as keywordID UNION ALL SELECT 40 as relevance, 'effic' as term, 403722085 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 1 GROUP BY articleID, sm.term, sf.id UNION ALL SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, st2.articleID as articleID FROM (SELECT 50 as relevance, 'effic' as term, 403362937 as keywordID UNION ALL SELECT 50 as relevance, 'effic' as term, 403362942 as keywordID UNION ALL SELECT 44 as relevance, 'effic' as term, 403359741 as keywordID UNION ALL SELECT 44 as relevance, 'effic' as term, 403360277 as keywordID UNION ALL SELECT 44 as relevance, 'effic' as term, 403362208 as keywordID UNION ALL SELECT 40 as relevance, 'effic' as term, 403362156 as keywordID UNION ALL SELECT 40 as relevance, 'effic' as term, 403404611 as keywordID UNION ALL SELECT 40 as relevance, 'effic' as term, 403722085 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 2 INNER JOIN s_articles_categories st2 ON si.elementID = st2.categoryID GROUP BY articleID, sm.term, sf.id UNION ALL SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, st3.id as articleID FROM (SELECT 50 as relevance, 'effic' as term, 403362937 as keywordID UNION ALL SELECT 50 as relevance, 'effic' as term, 403362942 as keywordID UNION ALL SELECT 44 as relevance, 'effic' as term, 403359741 as keywordID UNION ALL SELECT 44 as relevance, 'effic' as term, 403360277 as keywordID UNION ALL SELECT 44 as relevance, 'effic' as term, 403362208 as keywordID UNION ALL SELECT 40 as relevance, 'effic' as term, 403362156 as keywordID UNION ALL SELECT 40 as relevance, 'effic' as term, 403404611 as keywordID UNION ALL SELECT 40 as relevance, 'effic' as term, 403722085 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 3 INNER JOIN s_articles st3 ON si.elementID = st3.supplierID GROUP BY articleID, sm.term, sf.id UNION ALL SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, st4.articleID as articleID FROM (SELECT 50 as relevance, 'effic' as term, 403362937 as keywordID UNION ALL SELECT 50 as relevance, 'effic' as term, 403362942 as keywordID UNION ALL SELECT 44 as relevance, 'effic' as term, 403359741 as keywordID UNION ALL SELECT 44 as relevance, 'effic' as term, 403360277 as keywordID UNION ALL SELECT 44 as relevance, 'effic' as term, 403362208 as keywordID UNION ALL SELECT 40 as relevance, 'effic' as term, 403362156 as keywordID UNION ALL SELECT 40 as relevance, 'effic' as term, 403404611 as keywordID UNION ALL SELECT 40 as relevance, 'effic' as term, 403722085 as keywordID) sm INNER JOIN s_search_index si term, 403722085 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 6 INNER JOIN s_articles_attributes st6 ON si.elementID = st6.Feature GROUP BY articleID, sm.term, sf.id) srd GROUP BY srd.articleID ORDER BY relevance DESC LIMIT 5000) sr INNER JOIN s_articles a ON a.id = sr.articleID)) searchTable ON searchTable.product_id = product.id INNER JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id WHERE avoidCustomerGroup.articleID IS NULL GROUP BY product.id ORDER BY searchTable.ranking DESC, variant.id ASC LIMIT 20' with params [1, 2453]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'st6.Feature' in 'on clause' in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 131 Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(855): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), 'SELECT SQL_CALC...', Array) #1 vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Connection->executeQuery('SELECT SQL_CALC...', Array, Array) #2 engine/Shopware/Bundle/SearchBundleDBAL/ProductNumberSearch.php(103): Doctrine\DBAL\Query\QueryBuilder->execute() #3 engine/Shopware/Bundle/SearchBundleDBAL/ProductNumberSearch.php(85): Shopware\Bundle\SearchBundleDBAL\ProductNumberSearch->getProducts(Object(Shopware\Bundle\SearchBundleDBAL\QueryBuilder)) #4 engine/Shopware/Bundle/SearchBundle/ProductSearch.php(64): Shopware\Bundle\SearchBundleDBAL\ProductNumberSearch->search(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext)) #5 engine/Shopware/Bundle/SearchBundle/VariantSearch.php(66): Shopware\Bundle\SearchBundle\ProductSearch->search(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext)) #6 custom/plugins/SwagFuzzy/Bundle/SearchBundle/FuzzyProductSearch.php(54): Shopware\Bundle\SearchBundle\VariantSearch->search(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext)) #7 custom/plugins/SwagFuzzy/Controllers/Backend/SwagFuzzyPreview.php(98): SwagFuzzy\Bundle\SearchBundle\FuzzyProductSearch->search(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext)) #8 custom/plugins/SwagFuzzy/Controllers/Backend/SwagFuzzyPreview.php(58): Shopware_Controllers_Backend_SwagFuzzyPreview->getList('effic', '3', '0', '20') #9 engine/Library/Enlight/Controller/Action.php(192): Shopware_Controllers_Backend_SwagFuzzyPreview->listAction() #10 engine/Library/Enlight/Controller/Dispatcher/Default.php(563): Enlight_Controller_Action->dispatch('listAction') #11 engine/Library/Enlight/Controller/Front.php(222): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #12 engine/Shopware/Kernel.php(202): Enlight_Controller_Front->dispatch() #13 vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #14 vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true) #15 engine/Shopware/Components/HttpCache/AppCache.php(260): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #16 vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #17 engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #18 shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #19 {main}
Hat jemand vielleicht eine Idee woran es liegen könnte? Besten Dank im Voraus!
Auch das komplette Deinstallieren der SW Intelligenten Suche hat nichts gebracht, d.h. auch die nackte SW Standardsuche funktioniert nicht mehr…
Keine Ahnung wo der Eintrag herkam… 