Hallo ihr Lieben, ich hoffe mir kann jemand helfen.
Seit heute bekomme ich im Backend unter Einstellungen/Grundeinstellungen/Storefront folgenden Error:
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}
OK
Hat jemand evtl eine Idee wie sich das beheben lässt?
Danke schonmal!