Hallo, wir bekommen seit 4.1 folgende Fehlermeldung bei Suchen: SQLSTATE[42000]: Syntax error or access violation: 1064 memory exhausted near ‘as term, 381106 as keywordID UNION ALL SELECT 50 as relevance, ‘10’ as term, 822’ at line 10 in Zend/Db/Statement/Pdo.php on line 234 Stack trace: #0 Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #1 Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’? SELECT…’, Array) #3 Enlight/Components/Db/Adapter/Pdo/Mysql.php(75): Zend_Db_Adapter_Pdo_Abstract->query(’? SELECT…’, Array) #4 Zend/Db/Adapter/Abstract.php(755): Enlight_Components_Db_Adapter_Pdo_Mysql->query(’? SELECT…’, Array) #5 Shopware/Components/Search/Adapter/Default.php(678): Zend_Db_Adapter_Abstract->fetchRow(’? SELECT…’, Array) #6 Shopware/Components/Search/Adapter/Default.php(910): Shopware_Components_Search_Adapter_Default->getSearchCountResults(‘sr.relevance+IF…’, ‘? FRO…’) #7 Shopware/Components/Search.php(71): Shopware_Components_Search_Adapter_Default->search(‘MediaPad 10 LIN…’, Array) #8 Shopware/Controllers/Frontend/Search.php(166): Shopware_Components_Search->search(‘MediaPad 10 LIN…’, Array) #9 Enlight/Controller/Action.php(148): Shopware_Controllers_Frontend_Search->defaultSearchAction() #10 Enlight/Controller/Dispatcher/Default.php(521): Enlight_Controller_Action->dispatch(‘defaultSearchAc…’) #11 Enlight/Controller/Front.php(214): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #12 Shopware/Components/HttpCache/HttpKernel.php(79): Enlight_Controller_Front->dispatch() #13 Symfony/Component/HttpKernel/HttpCache/HttpCache.php(434): Shopware\Components\HttpCache\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #14 Shopware/Components/HttpCache/AppCache.php(234): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #15 Symfony/Component/HttpKernel/HttpCache/HttpCache.php(403): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #16 Symfony/Component/HttpKernel/HttpCache/HttpCache.php(303): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #17 Shopware/Components/HttpCache/AppCache.php(158): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #18 Symfony/Component/HttpKernel/HttpCache/HttpCache.php(192): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #19 Shopware/Components/HttpCache/AppCache.php(110): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #20 Shopware/Bootstrap.php(70): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #21 Enlight/Application.php(192): Shopware_Bootstrap->run() #22 shopware.php(83): Enlight_Application->run() #23 {main} Vielleicht hat ja jemand einen Tip. Eckdaten: 48000 Artikel, 800 Katergorien MfG Rüdiger
Ist das die intelligente Suche? Dann überschreitet wahrscheinlich die Kombinationsanzahl den Speicher. Man müsste dort Relevanzen einstellen können. die Zahl hoch setzen. Viele Grüße HTH