# Error im backend: MAX\_JOIN\_SIZE

**URL:** <https://forum.shopware.com/t/error-im-backend-max-join-size/57373>\
**Category:** Administration\
**Created:** [9. Januar 2019 um 15:17 UTC](https://forum.shopware.com/t/error-im-backend-max-join-size/57373 "2019-01-09T15:17:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![WoodBury](https://avatars.discourse-cdn.com/v4/letter/w/5e9695/32.png) [@WoodBury](https://forum.shopware.com/u/WoodBury)\
**Post date:** [9. Januar 2019 um 15:17 UTC](https://forum.shopware.com/t/error-im-backend-max-join-size/57373/1 "2019-01-09T15:17:00Z")

</div>

Hallo ihr Lieben, ich hoffe mir kann jemand helfen.

Seit heute bekomme ich im Backend unter Einstellungen/Grundeinstellungen/Storefront folgenden Error:

&nbsp;

&nbsp;

Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‘SELECT s0\_.id AS id\_0, COALESCE(s1\_.label, s2\_.label, s0\_.label, s0\_.name) AS sclr\_1, COUNT(s3\_.id) AS sclr\_2, s4\_.translations AS translations\_3 FROM s\_core\_config\_forms s0\_ LEFT JOIN s\_core\_config\_elements s5\_ ON s0\_.id = s5\_.form\_id LEFT JOIN s\_core\_config\_element\_translations s6\_ ON s5\_.id = s6\_.element\_id AND (s6\_.locale\_id IN (?, ?)) LEFT JOIN s\_core\_config\_form\_translations s1\_ ON s0\_.id = s1\_.form\_id AND (s1\_.locale\_id = ?) LEFT JOIN s\_core\_config\_form\_translations s2\_ ON s0\_.id = s2\_.form\_id AND (s2\_.locale\_id = ?) LEFT JOIN s\_core\_config\_forms s3\_ ON s0\_.id = s3\_.parent\_id LEFT JOIN s\_core\_plugins s4\_ ON s0\_.plugin\_id = s4\_.id WHERE s0\_.parent\_id = ? GROUP BY s0\_.id’ with params [1, 1, 1, 1, 80]: SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX\_JOIN\_SIZE rows; check your WHERE and use SET SQL\_BIG\_SELECTS=1 or SET MAX\_JOIN\_SIZE=# if the SELECT is okay in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 119 Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(836): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‘SELECT s0\_.id A…’, Array) #1 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection-\>executeQuery(‘SELECT s0\_.id A…’, Array, Array, NULL) #2 vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(321): Doctrine\ORM\Query\Exec\SingleSelectExecutor-\>execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(969): Doctrine\ORM\Query-\>\_doExecute() #4 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(924): Doctrine\ORM\AbstractQuery-\>executeIgnoreQueryCache(NULL, 2) #5 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(739): Doctrine\ORM\AbstractQuery-\>execute(NULL, 2) #6 engine/Shopware/Controllers/Backend/Config.php(102): Doctrine\ORM\AbstractQuery-\>getArrayResult() #7 engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_Config-\>getNavigationAction() #8 engine/Library/Enlight/Controller/Dispatcher/Default.php(530): Enlight\_Controller\_Action-\>dispatch(‘getNavigationAc…’) #9 engine/Library/Enlight/Controller/Front.php(223): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #10 engine/Shopware/Kernel.php(189): Enlight\_Controller\_Front-\>dispatch() #11 vendor/symfony/http-kernel/HttpCache/HttpCache.php(491): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #12 engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #13 vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #14 engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #15 shopware.php(118): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #16 {main} &nbsp;

_OK_

&nbsp;

Hat jemand evtl eine Idee wie sich das beheben lässt?&nbsp;

Danke schonmal!

---

<div class="post-metadata">

**Author:** ![Outworld86](https://avatars.discourse-cdn.com/v4/letter/o/67e7ee/32.png) [@Outworld86](https://forum.shopware.com/u/Outworld86)\
**Post date:** [8. Juli 2019 um 08:40 UTC](https://forum.shopware.com/t/error-im-backend-max-join-size/57373/2 "2019-07-08T08:40:04Z")

</div>

Hallo, hattest du eine Lösung finden können? Bei uns leider das selbe Problem.