# SW 4.1: SQLSTATE\[42000\]: Syntax error or access violation:

**URL:** <https://forum.shopware.com/t/sw-4-1-sqlstate-42000-syntax-error-or-access-violation/14309>\
**Category:** Shopware 3.5\
**Tags:** general\
**Created:** [10. Juli 2013 um 14:30 UTC](https://forum.shopware.com/t/sw-4-1-sqlstate-42000-syntax-error-or-access-violation/14309 "2013-07-10T14:30:31Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rsielaff](https://avatars.discourse-cdn.com/v4/letter/r/b19c9b/32.png) [@rsielaff](https://forum.shopware.com/u/rsielaff)\
**Post date:** [10. Juli 2013 um 14:30 UTC](https://forum.shopware.com/t/sw-4-1-sqlstate-42000-syntax-error-or-access-violation/14309/1 "2013-07-10T14:30:31Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![hth](https://avatars.discourse-cdn.com/v4/letter/h/b77776/32.png) [@hth](https://forum.shopware.com/u/hth)\
**Post date:** [10. Juli 2013 um 18:59 UTC](https://forum.shopware.com/t/sw-4-1-sqlstate-42000-syntax-error-or-access-violation/14309/2 "2013-07-10T18:59:02Z")

</div>

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