[Erledigt] SW Suche geht von jetzt auf nachher nicht mehr

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…

Hm,

Column not found: 1054 Unknown column 'st6.Feature'

Laut der Meldung bezieht sich das wohl auf die Tabelle „s_articles_attributes“. Da war wohl mal eine Spalte „Feature“ die es nun plötzlich nicht mehr gibt. Solche Fehler kommen meist nicht aus heiterem Himmel. Vielleicht mal den Cache komplett löschen und neu versuchen.

1 Like

Und in der Sucheinstellung mal nachgucken ob diese Tabelle dort mit einbezogen wurde.

1 Like

Tausend Dank ihr Beiden!

@R4M schrieb:

Hm,

Column not found: 1054 Unknown column ‚st6.Feature‘

Laut der Meldung bezieht sich das wohl auf die Tabelle „s_articles_attributes“. Da war wohl mal eine Spalte „Feature“ die es nun plötzlich nicht mehr gibt. Solche Fehler kommen meist nicht aus heiterem Himmel. Vielleicht mal den Cache komplett löschen und neu versuchen.

Habe die Einstellungen nochmal mit denen in unserer Testumgebung abgeglichen und dabei einen „neuen“ Eintrag in den Tabelleneinstellungen der intelligenten Suche des Produktivshops gefunden den es in unserer Testumgebung so nicht gibt. Eintrag gelöscht und jetzt funktioniert die Suche wieder… Wearing-Sunglasses Keine Ahnung wo der Eintrag herkam… Foot-in-Mouth

Suchindex lässt sich zwar immer immer noch nicht manuell über die Einstellungen neu aufbauen, aber das schaue ich mir nächste Woche in Ruhe an sobald die BlackFriday Horde durch ist…

Nochmals vielen Dank!

 

 

1 Like

Danke für dein Feedback!