Scheduled Tasks - product_download.media.cleanup failed
- 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
Assessment
This issue has not been assessed yet.