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:
This should solve the problem even on smaller webhosting packages.