shopware / shopware/shopware

Scheduled Tasks - product_download.media.cleanup failed

Open
#5,378 1 comment 0 reactions 1 assignee Claimed by @nguyenytran View on GitHub
component/inventory-products domain/discovery domain/inventory Platform(Default) priority/low
Dominant language
PHP
Stars
3.4k
Forks
1.2k
Avg merge
2d 23h
Merged PRs (30d)
433

Description

*PHP Version:* 8.2 | *Shopware Version:* 6.6.7.1 | *Affected area / extension:* Platform(Default)

----

*_Expected behaviour:_*

Execute Task without error.

*_Actual behaviour:_*

Task exits with:
Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay" at ExceptionConverter.php line 118 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1104): An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay at /is/htdocs/wp13707735_6J5JOPKX6E/www/www.spexx.org/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:118)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1104): SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay at /is/htdocs/wp13707735_6J5JOPKX6E/www/www.spexx.org/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay at /is/htdocs/wp13707735_6J5JOPKX6E/www/www.spexx.org/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130)"} []

*_How to reproduce:_*

Manually start Task product_download.media.cleanup in Tools Plugin (Friends of Shopware)

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.