Update error with wizard MigrateMediaToAssetsForTextMediaCe

[Oktopuce]

The wizard MigrateMediaToAssetsForTextMediaCe tries to update the new database field for extension "fluid_styled_content" with this request:

$connection = GeneralUtility::makeInstance(ConnectionPool::class)->getConnectionForTable('sys_file_reference');
$updateQueryBuilder = $connection->createQueryBuilder();
$updateQueryBuilder->update('sys_file_reference')
    ->leftJoin('sys_file_reference','tt_content','tt_content')
    ->where(
        $updateQueryBuilder->expr()->and(
            $updateQueryBuilder->expr()->eq(
                'tt_content.CType', $updateQueryBuilder->createNamedParameter('textmedia', \PDO::PARAM_STR)
            ),
            $updateQueryBuilder->expr()->gt('media', $updateQueryBuilder->createNamedParameter(0, \PDO::PARAM_INT)),
        )
    )->set('tt_content.assets', 'tt_content.media', false)
    ->set('sys_file_reference.fieldname', 'assets')
    ->set('tt_content.media', 0)
->executeStatement();

but this can't work, join condition are not supported by doctrine/dbal because the join method is not supported in all db engines for delete or update.

And this result whit a query like this:

UPDATE `sys_file_reference`
SET `tt_content`.`assets`            = tt_content.media,
    `sys_file_reference`.`fieldname` = ?,
    `tt_content`.`media`             = ?
WHERE ((`tt_content`.`CType` = ?) AND (`media` > ?));

and the error:

(1/3) #1054 Doctrine\DBAL\Exception\InvalidFieldNameException
An exception occurred while executing a query: Unknown column 'tt_content.CType' in 'where clause'

The solution is to make a select query and then update the database.

And there is also an error with join because there is no join condition between sys_file_reference and tt_content, the join should have been like this:

->leftJoin(
    'sys_file_reference','tt_content','tt_content',
    $queryBuilder->expr()->eq('sys_file_reference.uid_foreign', $queryBuilder->quoteIdentifier('tt_content.uid'))
)