# Fehler beim Aufbauen des Such-Index

**URL:** <https://forum.shopware.com/t/fehler-beim-aufbauen-des-such-index/56780>\
**Category:** Administration\
**Created:** [29. November 2018 um 16:21 UTC](https://forum.shopware.com/t/fehler-beim-aufbauen-des-such-index/56780 "2018-11-29T16:21:02Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![brettvormkopp](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/brettvormkopp/32/7788_2.png) [@brettvormkopp](https://forum.shopware.com/u/brettvormkopp)\
**Post date:** [11. März 2020 um 10:07 UTC](https://forum.shopware.com/t/fehler-beim-aufbauen-des-such-index/56780/6 "2020-03-11T10:07:11Z")

</div>

Hallo, habe das gleiche Problem.

**3xCritical**

- Category not found

- An exception occurred while executing 'INSERT … Text am Ende:

- An exception occurred while executing 'INSERT … Text am Ende:

gefolgt von **1x ERROR**

```
PDOException: SQLSTATE(42000): Syntax error or access violation: 1064 memory exhausted near 'sk.id as keywordID, 4043 as elementID, 5 as fieldID FROM s_search_keywords sk WH' at line 15995 in /vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1062 Stack trace:
#0 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1062): PDO->exec()
#1 /engine/Shopware/Bundle/SearchBundleDBAL/SearchTerm/SearchIndexer.php(223): Doctrine\DBAL\Connection->executeUpdate()
#2 /engine/Shopware/Plugins/Default/Core/RebuildIndex/Controllers/SearchIndex.php(38): Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchIndexer->build()
#3 /engine/Library/Enlight/Controller/Action.php(192): Shopware_Controllers_Backend_SearchIndex->buildAction()
#4 /engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight_Controller_Action->dispatch()
#5 /engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch()
#6 /engine/Shopware/Kernel.php(188): Enlight_Controller_Front->dispatch()
#7 /vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle()
#8 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(453): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
#9 /engine/Shopware/Components/HttpCache/AppCache.php(261): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward()
#10 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache->forward()
#11 /engine/Shopware/Components/HttpCache/AppCache.php(102): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass()
#12 /var/www/clients/client1/web1/web/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle()
#13

```

Hat jemand eine Lösung? Danke und Gruss.

SW 5.6.6.  
PHP 7.4.3  
nginx bei Timme

---

_[View the full topic](https://forum.shopware.com/t/fehler-beim-aufbauen-des-such-index/56780)._