[4.x]: gc/run throws Postgre Exeption

[r-anwar]

What happened?

Description

php craft gc/run throws following Exception:

at task: > deleting partial Neo block data ...

'PDOException' with message 'SQLSTATE[HY000]: General error: 7 number of parameters must be between 0 and 65535

Expected behavior

Pagination of DELETE SQL statements using an appropriate limit.

Actual behavior

Probably no pagination used.

Craft CMS version

4.14.15

PHP version

8.2.28

Operating system and version

Ubuntu 22.04.5 LTS

Database type and version

PostgreSQL 16.8

Image driver and version

No response

Installed plugins and versions

Blitz 4.23.13
Control Panel CSS 2.6.0
Cookies 4.0.1
Dates & Opening Hours dev-main
Embedded Assets 4.2.3
Enforce password 2.0.0
Glossary 2.0.1
Hyper 1.3.6
Imager X 4.5.1.1
Incognito Field 1.3.0
Inventory 2.2.0
KeyChain 4.0.0
Matrix Colors 3.0.0
Minify 4.0.1
Neo 4.4.1
Publisher X 3.0.1
Redactor 3.1.0
Redactor Anchors 1.5.0
Relax 2.0.2
SAML Service Provider 4.3.1
Sprig 2.13.1
SuperSort 4.0.0
Super Table 3.0.15

[i-just]

Hi, thanks for getting in touch! Can you please share a full stack trace for this?

[r-anwar]

@i-just

in /app/vendor/yiisoft/yii2/db/Schema.php:676

Error Info:
Array
(
[0] => HY000
[1] => 7
[2] => number of parameters must be between 0 and 65535
)

Caused by: Exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 7 number of parameters must be between 0 and 65535'

in /app/vendor/yiisoft/yii2/db/Command.php:1320

Stack trace: #0 /app/vendor/yiisoft/yii2/db/Command.php(1320): PDOStatement->execute() #1 /app/vendor/yiisoft/yii2/db/Command.php(1120): yii\db\Command->internalExecute() #2 /app/vendor/craftcms/cms/src/helpers/Db.php(1140): yii\db\Command->execute() #3 /app/vendor/craftcms/cms/src/services/Gc.php(310): craft\helpers\Db::delete() #4 /app/vendor/spicyweb/craft-neo/src/Plugin.php(252): craft\services\Gc->deletePartialElements() #5 [internal function]: benf\neo\Plugin->benf\neo\{closure}() #6 /app/vendor/yiisoft/yii2/base/Event.php(312): call_user_func() #7 /app/vendor/yiisoft/yii2/base/Component.php(650): yii\base\Event::trigger() #8 /app/vendor/craftcms/cms/src/services/Gc.php(149): yii\base\Component->trigger() #9 /app/vendor/craftcms/cms/src/console/controllers/GcController.php(56): craft\services\Gc->run() #10 [internal function]: craft\console\controllers\GcController->actionRun() #11 /app/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array() #12 /app/vendor/yiisoft/yii2/base/Controller.php(178): yii\base\InlineAction->runWithParams() #13 /app/vendor/yiisoft/yii2/console/Controller.php(180): yii\base\Controller->runAction() #14 /app/vendor/craftcms/cms/src/console/ControllerTrait.php(90): yii\console\Controller->runAction() #15 /app/vendor/craftcms/cms/src/console/Controller.php(216): craft\console\Controller->traitRunAction() #16 /app/vendor/yiisoft/yii2/base/Module.php(552): craft\console\Controller->runAction() #17 /app/vendor/yiisoft/yii2/console/Application.php(180): yii\base\Module->runAction() #18 /app/vendor/craftcms/cms/src/console/Application.php(91): yii\console\Application->runAction() #19 /app/vendor/yiisoft/yii2/console/Application.php(147): craft\console\Application->runAction() #20 /app/vendor/craftcms/cms/src/console/Application.php(122): yii\console\Application->handleRequest() #21 /app/vendor/yiisoft/yii2/base/Application.php(384): craft\console\Application->handleRequest() #22 /app/craft(16): yii\base\Application->run() #23 {main}

[i-just]

Thanks! I raised a PR for this.

[brandonkelly]

Craft 4.15.3 and 5.7.5 are out with a fix for that. Thanks again!