Bug #98301
closed
Undefined function in AbstractPostgreSQLDriver.php
0%
Description
When using the Upgrade Wizards in 11.5.15 i get the following errors on the cli:
php typo3/sysext/core/bin/typo3 upgrade:run
! [NOTE] Wizard databaseRowsUpdateWizard does not need to make changes.
! [NOTE] Wizard TYPO3\CMS\FrontendLogin\Updates\MigrateFeloginPluginsCtype does not need to make changes.
! [NOTE] Wizard BK2K\BootstrapPackage\Updates\AccordionContentElementUpdate does not need to make changes.
! [NOTE] Wizard BK2K\BootstrapPackage\Updates\AccordionMediaOrientUpdate does not need to make changes.
! [NOTE] Wizard BK2K\BootstrapPackage\Updates\BackendLayoutUpdate does not need to make changes.
In AbstractPostgreSQLDriver.php line 102:
An exception occurred while executing 'SELECT COUNT("uid") FROM "tt_content" WHERE ("CType" = ?) AND ("layout" IN (100, 110, 120, 130)) AND ("tt_content"."deleted" = 0)' with params ["bullets"]:
SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: character varying = integer
LINE 1: ...M "tt_content" WHERE ("CType" = $1) AND ("layout" IN (100, 1...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
In Exception.php line 18:
SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: character varying = integer
LINE 1: ...M "tt_content" WHERE ("CType" = $1) AND ("layout" IN (100, 1...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
In PDOStatement.php line 117:
SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: character varying = integer
LINE 1: ...M "tt_content" WHERE ("CType" = $1) AND ("layout" IN (100, 1...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
upgrade:run [<wizardName>]
Updated by Stefan Bürk about 2 years ago
- Status changed from New to Needs Feedback
Can you please add your used PostgresSQL version to the ticket description ?
Updated by Gerald Z about 2 years ago
psql (PostgreSQL) 13.8 (Debian 13.8-0+deb11u1)
Updated by Stefan Bürk about 2 years ago
Can it be that the errors comes from a bootstrap package update wizard ? Could find a core upgrade in v11/main doing these sql queries ...
Maybe rerun upgrade wizards with -vvv
See https://github.com/benjaminkott/bootstrap_package/blob/94afc27f9dfc887e836ae1b5ff17c26ee06ce22a/Classes/Updates/BulletContentElementUpdate.php#L72
The upgrade wizards seems to be from the bootstrap package. So so you may create an issue there instead.
$queryBuilder->expr()->in('layout', [100, 110, 120, 130])
should be
$queryBuilder->expr()->in('layout', $queryBuilder->createNamedParameter(
[100, 110, 120, 130],
\TYPO3\CMS\Core\Database\Connection::PARAM_INT_ARRAY
)
at least I guess so .. you may try it out first to replace it locally in the bootstrap package update wizard.
if that does not work, report it also here.
Updated by Gerald Z about 2 years ago
OK, with -vvv enabled I can confirm this is a bootstrap_package error.
Updated by Gerald Z about 2 years ago
OK, i fixed one of the bootstrap files locally and then some of these errors are gone. Looks like your solution works for PostgreSQL. There are more files with the same error. Will report as a bug with bootstrap_package.
Updated by Gerald Z about 2 years ago
I submitted a issue with bootstrap_package: https://github.com/benjaminkott/bootstrap_package/issues/1202
Please close.
Updated by Riccardo De Contardi about 2 years ago
- Status changed from Needs Feedback to Closed
- Assignee deleted (
Stefan Bürk)
@Gerald Z Thank you for your feedback.
Closed in agreement with the reporter.
If you think that this is the wrong decision or experience the issue again on a fresh TYPO3 installation, please open a new issue with a reference to this one.