# Shopware 5 - SELECT SQL\_CALC\_FOUND\_ROWS

**URL:** <https://forum.shopware.com/t/shopware-5-select-sql-calc-found-rows/25985>\
**Category:** Installation/Einstieg\
**Created:** [1. April 2015 um 11:22 UTC](https://forum.shopware.com/t/shopware-5-select-sql-calc-found-rows/25985 "2015-04-01T11:22:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jampshop](https://avatars.discourse-cdn.com/v4/letter/j/c77e96/32.png) [@jampshop](https://forum.shopware.com/u/jampshop)\
**Post date:** [1. April 2015 um 11:22 UTC](https://forum.shopware.com/t/shopware-5-select-sql-calc-found-rows/25985/1 "2015-04-01T11:22:21Z")

</div>

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):

---

<div class="post-metadata">

**Author:** ![TimmeHosting](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/timmehosting/32/15580_2.png) [@TimmeHosting](https://forum.shopware.com/u/TimmeHosting)\
**Post date:** [7. April 2015 um 01:30 UTC](https://forum.shopware.com/t/shopware-5-select-sql-calc-found-rows/25985/2 "2015-04-07T01:30:19Z")

</div>

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](https://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar%5C_sort%5C_buffer%5C_size)