Hallo Zusammen, wer findet hier den Syntax error, Fehlender Operator, aber welcher und wo, oder doch was anderes? Shopware 5 RC2 Vielen Dank für Hinweise. Falls Ihr der Meinung seid, dass ein Bug vorliegt, dann öffne ich ein Ticket. Diese FehlerMeldung: [color=red]debug: exception ‚PDOException‘ with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‚[/color][color=orange]GROUP BY articleID, sm.term, sf.id[/color] [color=red]UNION ALL SELECT MAX(sf.relevance * sm.r‘ at line 12[/color] hier mal die Abfrage: SELECT MAX( sr.relevance + IF(a.topseller = 1, 50, 0) + IF(a.datum \>= DATE\_SUB(NOW(),INTERVAL 7 DAY), 25, 0)) FROM (SELECT srd.articleID, SUM(srd.relevance) as relevance FROM ( SELECT MAX(sf.relevance \* sm.relevance) as relevance, sm.keywordID, si.elementID as articleID FROM (SELECT 80 as relevance, 'auto' as term, 61001 as keywordID) sm INNER JOIN s\_search\_index si ON sm.keywordID = si.keywordID I NNER 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, st2.articleID as articleID FROM (SELECT 80 as relevance, 'auto' as term, 61001 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 I NNER 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, st3.id as articleID FROM (SELECT 80 as relevance, 'auto' as term, 61001 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, st4.articleID as articleID FROM (SELECT 80 as relevance, 'auto' as term, 61001 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 = 4 INNER JOIN s\_articles\_details st4 ON si.elementID = st4.id GROUP BY articleID, sm.term, sf.id UNION ALL SELECT MAX(sf.relevance \* sm.relevance) as relevance, sm.keywordID, st5.articleID as articleID FROM (SELECT 80 as relevance, 'auto' as term, 61001 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 = 5 INNER JOIN s\_articles st5 ON si.elementID = st5. GROUP BY articleID, sm.term, sf.id UNION ALL SELECT MAX(sf.relevance \* sm.relevance) as relevance, sm.keywordID, st6.articleID as articleID FROM (SELECT 80 as relevance, 'auto' as term, 61001 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\_filter\_articles st6 ON si.elementID = st6.valueID GROUP BY articleID, sm.term, sf.id) srd GROUP BY srd.articleID LIMIT 5000) sr INNER JOIN s\_articles a ON a.id = sr.articleID
Fehler gefunden! Ich habe wohl zu viele Relevanz Felder definiert, zuvor 9 Felder und nun habe ich 2 gelöscht, dann kommt der Fehler nicht mehr. Ist das nun ein Bug oder keiner und einfach nur Dummheit meiner Seite, zu glauben man könnte mehr als 9 Relevanz Felder definieren? Gruß Zwilla p.s. Absichtlich herbeigeführter Fehler ist das nicht. Wenn ich die Möglichkeit bekommen einen Fehler zu machen, dann tue ich Ihn! (Error-Handling) Das Fehlt an dieser Stelle