Check page tree integrity throw exception under TYPO3 12

[mediaessenz]

If I start the command with ddev typo3 dbdoctor:health -m interactive I get this exception in the console:

Check page tree integrity
-------------------------

 Class: PagesBrokenTree
 Actions: remove
 This health check finds "pages" records with their "pid" set to pages that do
 not exist in the database. Pages without proper connection to the tree root are never
 shown in the backend. They are removed.

Uncaught TYPO3 Exception PDOStatement::bindParam(): Argument #4 ($maxLength) must be of type int, null given
thrown in file /var/www/html/vendor/typo3/cms-core/Classes/Database/Driver/DriverStatement.php
in line 104

Tried it with TYPO3 12.4.11 and 12.4.12 under PHP 8.2.16

[lolli42]

mmmh. I don't understand where this comes from. since cli does not print backtraces properly, could you maybe hack that place and print_r() or var_dump() a backtrace, and paste it here, to see how this is triggered?

[mediaessenz]

I think I found the bad guy:
It's this call inside the RecordsHelper::getRecord method of your extension, which produces the exception:

$statement->bindParam(1, $uid, Connection::PARAM_INT);

As far as I see, this bindParam method of the doctrine AbstractStatementMiddleware is deprecated (see doctrine/dbal#5563) and bindValue should be used instead.

[mediaessenz]

Maybe the problem come from the choosen database driver, which is 'pdo_mysql' in my case.

[mediaessenz]

Replacing all bindParam calls in this RecordsHelper class with bindValue solve the problem.

[lolli42]

release 0.6.2