# Syntax Error bei der Suche PDOException SQLSTATE\[42000\]

**URL:** <https://forum.shopware.com/t/syntax-error-bei-der-suche-pdoexception-sqlstate-42000/26136>\
**Category:** Programmierung\
**Created:** [9. April 2015 um 10:18 UTC](https://forum.shopware.com/t/syntax-error-bei-der-suche-pdoexception-sqlstate-42000/26136 "2015-04-09T10:18:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![zwilla](https://avatars.discourse-cdn.com/v4/letter/z/74df32/32.png) [@zwilla](https://forum.shopware.com/u/zwilla)\
**Post date:** [9. April 2015 um 10:18 UTC](https://forum.shopware.com/t/syntax-error-bei-der-suche-pdoexception-sqlstate-42000/26136/1 "2015-04-09T10:18:13Z")

</div>

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`

---

<div class="post-metadata">

**Author:** ![zwilla](https://avatars.discourse-cdn.com/v4/letter/z/74df32/32.png) [@zwilla](https://forum.shopware.com/u/zwilla)\
**Post date:** [9. April 2015 um 10:50 UTC](https://forum.shopware.com/t/syntax-error-bei-der-suche-pdoexception-sqlstate-42000/26136/2 "2015-04-09T10:50:20Z")

</div>

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