Shopware: Error building the search index

Shopware: Error building the search index

Shopware shows you numerous errors for “UNION ALL” and “SQLSTATE[42000]: Syntax error or access violation: 1064 memory exhausted near”? Then you probably have quite a lot of items in your online store which is pushing Shopware to its limits.

First of all you can try to execute PHP with

-d memory_limit=4096M

to allocate more memory:

/opt/plesk/php/7.4/bin/php -d memory_limit=4096M httpdocs/bin/console sw:refresh:search:index

If this does not work you can still split the setup into smaller packages:

Geschützter Bereich

Dieser Inhalt ist passwortgeschützt. Bitte gib dein Passwort ein um den Inhalt freizuschalten.

This should solve the problem even on smaller webhosting packages.

Leave a Reply

Your email address will not be published. Required fields are marked *