Suche nach "100%" erzeugt einen Fehler bei uns im Onlineshop

Shopware 6 (German)
1

Hi, wir verkaufen Produkte von dem Hersteller „100%“. Wenn ich bei uns im Onlineshop nach dem Hersteller suche kommt nach ca. 5 Sekunden die Fehlermeldung „Leider ist etwas schief gelaufen“. Suche-Shopware-Fehler-100

Beispielname für Artikel: 100% Armega Regal MX MTB Brille rot verspiegelt.
Gibt es die Möglichkeit „100%“ suchbar zu machen in Shopware?
Wir nutzen Shopware 6.4

LG
Max

2

Die Suche nach 100% funktioniert bei mir problemlos. Entweder habt ihr ein Plugin, dass etwas überschreibt, die Konfiguration ist fehlerhaft oder der Shop hat ein generelles Problem.

Am besten den JavaScript bzw. die 500er Response analysieren.

3

Moin,

mmh, wirklich schräg, habe ich auch, wenn ich bei den Sucheinstellungen beim Such-Verhalten auf „UND“-Suche gehe.

Shopware 6.4.5.1 Stable Version, keine Plugins, nur ca. 1000 Produkte testweise importiert,
insofern kann das an keinem Plugin liegen, Fehlkonfiguration auch nicht, da ich in der Konfiguration nur das „UND“ geändert habe.

Allerdings habe ich das Verhalten schon bei der Eingabe von 100, 200, „Kugelschreiber 100“… allerdings nicht bei 50 und anderen Zahlen, sehr schräg.
Shopware macht da eine super SQL-Query und am Ende bekommt man einen Thread stack overrun:

 DriverException
HTTP 500 Internal Server Error
An exception occurred while executing 'SELECT `product`.`id`, SUM(IF(`product.searchKeywords`.`keyword` = ? , '0.7' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.4' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.4' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.3' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.3' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + 
..........................................................
IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.1' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` LIKE ? , '1' * `product.searchKeywords`.`ranking`, 0)) as _score FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN (SELECT `product.searchKeywords`.`product_id` as id, `product.searchKeywords`.`product_version_id` FROM `product_search_keyword` `product.searchKeywords` WHERE (`product.searchKeywords`.`language_id` = ? AND `product.searchKeywords`.`keyword` IN (?, ?, ?, ?, ?))) `product.searchKeywords_1` ON `product`.`id` = `product.searchKeywords_1`.`id` AND `product`.`version_id` = `product.searchKeywords_1`.`product_version_id` LEFT JOIN (SELECT `product.searchKeywords`.`product_id` as id, `product.searchKeywords`.`product_version_id` FROM `product_search_keyword` `product.searchKeywords` WHERE (`product.searchKeywords`.`language_id` = ? AND `product.searchKeywords`.`keyword` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))) `product.searchKeywords_2` ON `product`.`id` = `product.searchKeywords_2`.`id` AND `product`.`version_id` = `product.searchKeywords_2`.`product_version_id` LEFT JOIN `product_search_keyword` `product.searchKeywords` ON `product`.`id` = `product.searchKeywords`.`product_id` AND `product`.version_id = `product.searchKeywords`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND (`product.searchKeywords_1`.id IS NOT NULL AND `product.searchKeywords_1`.id IS NOT NULL) AND (`product.searchKeywords_2`.id IS NOT NULL AND `product.searchKeywords_2`.id IS NOT NULL) AND NOT (`product`.`display_group` <=> ?))) GROUP BY `product`.`display_group` HAVING _score >= ? ORDER BY _score DESC LIMIT 10' with params ["kugelschreiber", "10cm", "10w", "9-10", "7-10", "5260610", "3179132610", "3179143910", "3179142510", "3179138210", "3179136810", "3179135610", "3179135210", "3179135110", "3179135100", "3179132810", "3179130110", "3179148110", "3179124910", "3179121910", "3179119810", "3179114810", "3179113510", "3179108210", "3179104910", "3179104810", "3179104710", "3179144810", "3179154410", "3179154010", "3179189610", "3180037610", "3180037510", "3179199610", "3179197610", "3179197510", "3179196210", "3179192710", "3179192010", "3179191610", "3179189410", "3179102010", "3179186110", "3179184510", "3179179810", "3179175010", "3179174710", "3179173910", "3179162610", "3179158410", "3179158110", "3179155610", "3179102610", "3178197810", "3180039310", "3178115210", "3178120180", "3178120110", "3178119710", "3178119610", "3178119510", "3178119410", "3178116910", "3178116110", "3178115510", "3178114410", "3178120610", "3178114310", "3178114210", "3178113810", "3178113710", "3178113310", "3178111810", "3178107910", "3178101010", "3178100110", "3178120410", "3178120910", "3178143910", "3178131010", "3178142310", "3178139210", "3178139110", "3178138810", "3178138710", "3178138610", "3178138510", "3178138210", "3178131410", "3178129110", "3178121510", "3178129010", "3178128910", "3178127010", "3178126910", "3178126110", "3178125110", "3178124710", "3178122710", "3178122610", "3178121610", "3180037710", "31800410", "5261210", "31874010", "40436170", "40436120", "40433210", "40433160", "40324190", "40323150", "40323140", "40269130", "40265310", "3187301210", "40459610", "3186400810", "31862010", "3186200910", "3185201410", "3184403410", "3184402210", "31819010", "3181500110", "31812410", "40436410", "40610810", "3181111110", "40850210", "5260210", "5260100", "5244140", "5244130", "5244120", "5232010", "5231180", "5231120", "5231110", "40850130", "40610910", "40850120", "40820410", "40820310", "40762160", "40762150", "40762120", "40762110", "40762100", "40742010", "40732210", "3181111310", "3181110610", "3180068510", "3180589010", "3180840710", "3180720910", "3180715010", "3180697810", "3180697510", "3180681510", "3180665210", "3180660710", "3180597310", "3180585910", "3180841010", "31804010", "3180341010", "31801710", "3180072710", "3180072510", "3180071610", "3180071310", "3180070810", "3176198410", "3180840810", "3180841210", "3181110310", "3180954510", "3181042310", "3181042210", "3181039410", "3181038610", "3181037510", "3181037210", "3181036010", "3181035810", "3180955110", "3180954310", "31808510", "3180952010", "3180950710", "3180948210", "3180947910", "3180944210", "3180942410", "3180938810", "3180936810", "3180936610", "3180930710", "3180070610", "aluminiumkugelschreiber", "3176182810", "3173160810", "3173165010", "3173164710", "3173163610", "3173163110", "3173162910", "3173162610", "3173162210", "3173161310", "3173161210", "3173159410", "3173167310", "3173154610", "3173151610", "3173148610", "3173146310", "3173143610", "3173139510", "3173135710", "3173127910", "3173127110", "3173165310", "3173171610", "3173122310", "3174100410", "3174122110", "3174119610", "3174119210", "3174118710", "3174117510", "3174117410", "3174117210", "3174114810", "3174113310", "3173196410", "3173172110", "3173191210", "3173188310", "317318280010", "3173181610", "3173181010", "3173180910", "3173179510", "3173179010", "3173173510", "3173173410", "3173124210", "3173121510", "3174127410", "2052310", "31718160", "3171815110", "3171812610", "31718120", "3171811910", "3171802910", "31615510", "31614910", "2052410", "2052190", "3171820310", "2052160", "2052140", "2051910", "2051810", "2051310", "2051140", "170x220m", "kunstoffkugelschreiber", "kugelschreiberetui", "kugelschreiber-set", "3171818910", "3171961110", "3173118610", "3172113110", "3173117510", "3172116910", "3172116210", "3172115710", "3172115610", "3172114810", "3172114710", "3172114510", "3172113810", "3172111910", "3171961210", "3172111610", "3172110610", "3172110210", "3172109710", "3172109410", "3172109310", "3172108410", "3172104610", "3172103410", "3172102610", "3174122610", "3174127510", "3176179910", "3174187310", "3174195110", "3174193410", "3174193210", "3174192810", "3174192510", "3174192310", "3174191510", "3174190310", "3174190110", "3174187210", "3174195810", "3174187110", "3174186510", "3174186110", "3174184910", "3174184510", "3174183610", "3174183510", "3174181510", "3174179410", "3174177910", "3174195310", "3174197110", "3174177610", "3176111210", "3176129410", "3176124910", "3176121310", "3176120110", "3176119410", "3176117710", "3176117310", "31761170", "3176116110", "3176110810", "3174199010", "3176109710", "3176108010", "3176107610", "3176106310", "3176105710", "3176101310", "3175700410", "3175700310", "3175700210", "3175240810", "3174177810", "3174177510", "3174129910", "3174146910", "3174150710", "3174150210", "3174150110", "3174149510", "3174149410", "3174149110", "3174148810", "3174148110", "3174148010", "3174146610", "3174152410", "3174142110", "3174141710", "3174136610", "3174136510", "3174135010", "3174134810", "3174133910", "3174133510", "3174132810", "3174132210", "3174152010", "3174153010", "3174177310", "3174161810", "3174177210", "3174176410", "3174176210", "3174175910", "3174175110", "3174169610", "3174169110", "3174165710", "3174162310", "3174161010", "3174153110", "3174159010", "3174158810", "3174158610", "3174157210", "3174157010", "3174156710", "3174156610", "3174154910", "3174154310", "3174154210", "3176135010", "%kugelschreiber 100%", "\x2f\xbb\x5f\xe2\xe2\x9a\x4d\x70\xaa\x58\x54\xce\x7c\xe3\xe2\x0b", "aluminiumkugelschreiber", "kugelschreiber", "kugelschreiber-set", "kugelschreiberetui", "kunstoffkugelschreiber", "\x2f\xbb\x5f\xe2\xe2\x9a\x4d\x70\xaa\x58\x54\xce\x7c\xe3\xe2\x0b", "10cm", "10w", "170x220m", "2051140", "2051310", "2051810", "2051910", "2052140", "2052160", "2052190", "2052310", "2052410", "31614910", "31615510", "3171802910", "3171811910", "31718120", "3171812610", "3171815110", "31718160", "3171818910", "3171820310", "3171961110", "3171961210", "3172102610", "3172103410", "3172104610", "3172108410", "3172109310", "3172109410", "3172109710", "3172110210", "3172110610", "3172111610", "3172111910", "3172113110", "3172113810", "3172114510", "3172114710", "3172114810", "3172115610", "3172115710", "3172116210", "3172116910", "3173117510", "3173118610", "3173121510", "3173122310", "3173124210", "3173127110", "3173127910", "3173135710", "3173139510", "3173143610", "3173146310", "3173148610", "3173151610", "3173154610", "3173159410", "3173160810", "3173161210", "3173161310", "3173162210", "3173162610", "3173162910", "3173163110", "3173163610", "3173164710", "3173165010", "3173165310", "3173167310", "3173171610", "3173172110", "3173173410", "3173173510", "3173179010", "3173179510", "3173180910", "3173181010", "3173181610", "317318280010", "3173188310", "3173191210", "3173196410", "3174100410", "3174113310", "3174114810", "3174117210", "3174117410", "3174117510", "3174118710", "3174119210", "3174119610", "3174122110", "3174122610", "3174127410", "3174127510", "3174129910", "3174132210", "3174132810", "3174133510", "3174133910", "3174134810", "3174135010", "3174136510", "3174136610", "3174141710", "3174142110", "3174146610", "3174146910", "3174148010", "3174148110", "3174148810", "3174149110", "3174149410", "3174149510", "3174150110", "3174150210", "3174150710", "3174152010", "3174152410", "3174153010", "3174153110", "3174154210", "3174154310", "3174154910", "3174156610", "3174156710", "3174157010", "3174157210", "3174158610", "3174158810", "3174159010", "3174161010", "3174161810", "3174162310", "3174165710", "3174169110", "3174169610", "3174175110", "3174175910", "3174176210", "3174176410", "3174177210", "3174177310", "3174177510", "3174177610", "3174177810", "3174177910", "3174179410", "3174181510", "3174183510", "3174183610", "3174184510", "3174184910", "3174186110", "3174186510", "3174187110", "3174187210", "3174187310", "3174190110", "3174190310", "3174191510", "3174192310", "3174192510", "3174192810", "3174193210", "3174193410", "3174195110", "3174195310", "3174195810", "3174197110", "3174199010", "3175240810", "3175700210", "3175700310", "3175700410", "3176101310", "3176105710", "3176106310", "3176107610", "3176108010", "3176109710", "3176110810", "3176111210", "3176116110", "31761170", "3176117310", "3176117710", "3176119410", "3176120110", "3176121310", "3176124910", "3176129410", "3176135010", "3176179910", "3176182810", "3176198410", "3178100110", "3178101010", "3178107910", "3178111810", "3178113310", "3178113710", "3178113810", "3178114210", "3178114310", "3178114410", "3178115210", "3178115510", "3178116110", "3178116910", "3178119410", "3178119510", "3178119610", "3178119710", "3178120110", "3178120180", "3178120410", "3178120610", "3178120910", "3178121510", "3178121610", "3178122610", "3178122710", "3178124710", "3178125110", "3178126110", "3178126910", "3178127010", "3178128910", "3178129010", "3178129110", "3178131010", "3178131410", "3178138210", "3178138510", "3178138610", "3178138710", "3178138810", "3178139110", "3178139210", "3178142310", "3178143910", "3178197810", "3179102010", "3179102610", "3179104710", "3179104810", "3179104910", "3179108210", "3179113510", "3179114810", "3179119810", "3179121910", "3179124910", "3179130110", "3179132610", "3179132810", "3179135100", "3179135110", "3179135210", "3179135610", "3179136810", "3179138210", "3179142510", "3179143910", "3179144810", "3179148110", "3179154010", "3179154410", "3179155610", "3179158110", "3179158410", "3179162610", "3179173910", "3179174710", "3179175010", "3179179810", "3179184510", "3179186110", "3179189410", "3179189610", "3179191610", "3179192010", "3179192710", "3179196210", "3179197510", "3179197610", "3179199610", "3180037510", "3180037610", "3180037710", "3180039310", "31800410", "3180068510", "3180070610", "3180070810", "3180071310", "3180071610", "3180072510", "3180072710", "31801710", "3180341010", "31804010", "3180585910", "3180589010", "3180597310", "3180660710", "3180665210", "3180681510", "3180697510", "3180697810", "3180715010", "3180720910", "3180840710", "3180840810", "3180841010", "3180841210", "31808510", "3180930710", "3180936610", "3180936810", "3180938810", "3180942410", "3180944210", "3180947910", "3180948210", "3180950710", "3180952010", "3180954310", "3180954510", "3180955110", "3181035810", "3181036010", "3181037210", "3181037510", "3181038610", "3181039410", "3181042210", "3181042310", "3181110310", "3181110610", "3181111110", "3181111310", "31812410", "3181500110", "31819010", "3184402210", "3184403410", "3185201410", "3186200910", "31862010", "3186400810", "3187301210", "31874010", "40265310", "40269130", "40323140", "40323150", "40324190", "40433160", "40433210", "40436120", "40436170", "40436410", "40459610", "40610810", "40610910", "40732210", "40742010", "40762100", "40762110", "40762120", "40762150", "40762160", "40820310", "40820410", "40850120", "40850130", "40850210", "5231110", "5231120", "5231180", "5232010", "5244120", "5244130", "5244140", "5260100", "5260210", "5260610", "5261210", "7-10", "9-10", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", 20, "\x9e\xee\xe5\x49\x70\x66\x4f\x8b\x80\xbe\x96\x61\x7e\x1d\xed\x6b", true, null, 0.1]:

SQLSTATE[HY000]: General error: 1436 Thread stack overrun: 164768 bytes used of a 196608 byte stack, and 32000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.

Die Query ist gekürzt, da es sonst zu viele Zeichen hier im Forum sind.

Na ja, wenn das an meinen Daten liegt, wäre das schlecht, woher soll ich wissen, welche Daten dafür verantwortlich sein sollten.

Gruss,
Werner.

4

Da ist die Antwort. Der MySQL thread_stack reicht nicht aus, um die Query auszuführen. Erhöhen, dann sollte es gehen.

Oder Keyword Ranking in der Suche deaktivieren.

5

Hi,

ja, nachdem ich den Mysql thread_stack auf 256K erhöht habe, geht es jetzt.

Ganz verstanden habe ich die Query auf die Schnelle aber nocht nicht, muss ich mir in Ruhe irgendwann nochmal anschauen. Vor allem ist mir nicht klar, warum das bei der Einstellung „ODER“ beim Such-Verhalten nicht auftritt.
Hatte mich mit der Suche bisher noch nicht so sehr befasst, wenn ich ehrlich bin, kommt noch.

Gruß,
Werner.

6

Wenn 1 von 2 oder mehreren Bedingungen erfüllt ist, dann müssen die weiteren Bedingungen nicht abgefragt werden. Sprich der Speicher wird frei.

Wenn alle Bedingungen erfüllt sein müssen, müssen alle Bedingungen getestet werden, sprich mehr im Speicher.

7

Hi, ich habe ein Ticket dazu im Issue Tracker angelegt. Gerne hochvoten damit es von Shopware bearbeitet wird.

LG
Max