Shopware 5 - SELECT SQL_CALC_FOUND_ROWS

Wir haben Shopware 5 installiert zum Testen, klappte auch soweit alles. Allerdings beim Öffnen der Einkaufswelten kommt immer folgende Fehlermeldung. Woran könnt es liegen? Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‚SELECT SQL_CALC_FOUND_ROWS emotions.id, emotions.name, emotions.active, emotions.device, emotions.is_landingpage as isLandingPage, emotions.parent_id as parentId, emotions.modified, GROUP_CONCAT(categories.description) AS categoriesNames, ( CASE WHEN (emotions.is_landingpage = 1 AND emotions.parent_id IS NOT NULL) THEN parent.name WHEN (emotions.is_landingpage = 1 AND emotions.parent_id IS NULL) THEN emotions.name ELSE GROUP_CONCAT(categories.description) END ) as groupingState FROM s_emotion emotions LEFT JOIN s_emotion_categories emotionCategories ON emotions.id = emotionCategories.emotion_id LEFT JOIN s_categories categories ON categories.id = emotionCategories.category_id LEFT JOIN s_emotion parent ON parent.id = emotions.parent_id GROUP BY emotions.id ORDER BY emotions.is_landingpage ASC, groupingState ASC, emotions.parent_id ASC LIMIT 50 OFFSET 0‘: SQLSTATE[HY001]: Memory allocation error: 1038 Out of sort memory, consider increasing server sort buffer size in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 91 Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), ‚SELECT SQL_CALC…‘, Array) #1 vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(204): Doctrine\DBAL\Connection->executeQuery(‚SELECT SQL_CALC…‘, Array, Array) #2 Shopware/Controllers/Backend/Emotion.php(99): Doctrine\DBAL\Query\QueryBuilder->execute() #3 Enlight/Controller/Action.php(159): Shopware_Controllers_Backend_Emotion->listAction() #4 Enlight/Controller/Dispatcher/Default.php(524): Enlight_Controller_Action->dispatch(‚listAction‘) #5 Enlight/Controller/Front.php(227): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #6 Shopware/Kernel.php(143): Enlight_Controller_Front->dispatch() #7 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(490): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #8 Shopware/Components/HttpCache/AppCache.php(257): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #9 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(261):

Das hier ist die Ursache: [quote]Memory allocation error: 1038 Out of sort memory, consider increasing server sort buffer size[/quote] Du (oder Dein Hoster) muß die sort_buffer_size für den MySQL-Server erhöhen: https://dev.mysql.com/doc/refman/5.5/en … uffer_size