Hallo,
habe gerade unseren Shop (ist noch nicht live) auf 5.6.3 upgedatet.
Die Produktseiten sind nun komplett leer (500 Internal Server Error), da es wohl Probleme mit dem Suchindex gibt.
Die Fehlermeldung ist die folgende im Log-File, ziemlich monströööösssssssssss der Insert-Befehl,
wie kommt den Shopware auf sowas?
Der Suchindex läßt sich auch nicht per Hand wieder aufbauen. Dort ergibt sich auch dieser Fehler.
Ein Plugin bzgl. der Suche haben wir meines Wissens nicht, alles Shopware-Standard. Vor dem Update gab es das Problem nicht.
Kann die komplette Query nicht hier reinkopieren weil ich ansonsten die Meldung „Nachricht ist 588102 Zeichen zu lang“ bekomme.
Danke im Voraus.
An exception occurred while executing 'INSERT IGNORE INTO s_search_index (keywordID, elementID, fieldID) SELECT sk.id as keywordID, 3187 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010001‘) UNION ALL SELECT sk.id as keywordID, 3188 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010001s‘) UNION ALL SELECT sk.id as keywordID, 3189 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010003‘) UNION ALL SELECT sk.id as keywordID, 3190 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010003s‘) UNION ALL SELECT sk.id as keywordID, 3191 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010004‘) UNION ALL SELECT sk.id as keywordID, 3192 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010004s‘) UNION ALL SELECT sk.id as keywordID, 3193 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010018‘) UNION ALL SELECT sk.id as keywordID, 3194 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010029‘) UNION ALL SELECT sk.id as keywordID, 3195 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010034‘) UNION ALL SELECT sk.id as keywordID, 3196 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010041‘) UNION ALL SELECT sk.id as keywordID, 3197 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010047‘) UNION ALL SELECT sk.id as keywordID, 3198 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010049‘) UNION ALL SELECT sk.id as keywordID, 3199 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010053‘) UNION ALL SELECT sk.id as keywordID, 3200 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010057‘) UNION ALL SELECT sk.id as keywordID, 3201 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010060‘) UNION ALL SELECT sk.id as keywordID, 3202 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010062‘) UNION ALL SELECT sk.id as keywordID, 3203 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010063‘) UNION ALL SELECT sk.id as keywordID, 3204 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010094‘) UNION ALL SELECT sk.id as keywordID, 3205 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010094m‘) UNION ALL SELECT sk.id as keywordID, 3211 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010145‘) UNION ALL SELECT sk.id as keywordID, 3206 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010155‘) UNION ALL SELECT sk.id as keywordID, 3207 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010156‘) UNION ALL SELECT sk.id as keywordID, 3208 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010157‘) UNION ALL SELECT sk.id as keywordID, 3209 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010158‘) UNION ALL SELECT sk.id as keywordID, 3210 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010159‘) UNION ALL SELECT sk.id as keywordID, 3212 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010178‘) UNION ALL SELECT sk.id as keywordID, 3213 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010180be‘) UNION ALL SELECT sk.id as keywordID, 3214 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010180bk‘) UNION ALL SELECT sk.id as keywordID, 3224 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010180rd‘) UNION ALL SELECT sk.id as keywordID, 3215 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010192‘) UNION ALL SELECT sk.id as keywordID, 3216 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010193m‘) UNION ALL SELECT sk.id as keywordID, 3217 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010193s‘) UNION ALL SELECT sk.id as keywordID, 3222 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010201rd‘) UNION ALL SELECT sk.id as keywordID, 3223 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010201s‘) UNION ALL SELECT sk.id as keywordID, 3218 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010203‘) UNION ALL SELECT sk.id as keywordID, 3219 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010204‘) UNION ALL SELECT sk.id as keywordID, 3225 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010210‘) UNION ALL SELECT sk.id as keywordID, 3220 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010230‘) UNION ALL SELECT sk.id as keywordID, 3227 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010252‘) UNION ALL SELECT sk.id as keywordID, 3226 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2010262mg‘) UNION ALL …
UNION ALL SELECT sk.id as keywordID, 2753 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2538224496‘) UNION ALL SELECT sk.id as keywordID, 2754 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2538224499‘) UNION ALL SELECT sk.id as keywordID, 2740 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2538224940‘) UNION ALL SELECT sk.id as keywordID, 2743 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2538224941‘) UNION ALL SELECT sk.id as keywordID, 2742 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2538224942‘) UNION ALL SELECT sk.id as keywordID, 2741 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2538224943‘) UNION ALL SELECT sk.id as keywordID, 2739 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2538224944‘) UNION ALL SELECT sk.id as keywordID, 2737 as elementID, 5 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (‚2538224945‘)’: SQLSTATE(42000): Syntax error or access violation: 1064 memory exhausted near ‚sk.id as keywordID, 2741 as elementID, 5 as fieldID FROM s_search_keywords sk WH‘ at line 15995
