Issue Bug Closed

#106803Doctrine DBAL 4.3-dev exception on "InvalidColumnDeclaration" in DB compare (EXT:seo pages.sitemap_priority column)

Franz Holzinger 06/01/25, 19:52 updated 12/02/25, 13:59

Description

TYPO3 13.4.14dev

½ Doctrine\DBAL\Exception\InvalidColumnDeclaration
Column “sitemap_priority” has invalid type
in /path/vendor/doctrine/dbal/src/Exception/InvalidColumnDeclaration.php line 16
final class InvalidColumnDeclaration extends LogicException implements Exception
{
public static function fromInvalidColumnType(string $columnName, InvalidColumnType $e): self {
return new self(sprintf(‘Column “%s” has invalid type’, $columnName), 0, $e);
}
}
at Doctrine\DBAL\Exception\InvalidColumnDeclaration::fromInvalidColumnType()
in /path/vendor/doctrine/dbal/src/Platforms/AbstractPlatform.php line 1505
*/
public function getDecimalTypeDeclarationSQL(array $column): string {
if (! isset($column[‘precision’])) {
throw InvalidColumnDeclaration::fromInvalidColumnType($column[‘name’], ColumnPrecisionRequired::new());
}
if (! isset($column[‘scale’])) {
throw InvalidColumnDeclaration::fromInvalidColumnType($column[‘name’], ColumnScaleRequired::new());
at Doctrine\DBAL\Platforms\AbstractPlatform->getDecimalTypeDeclarationSQL()
in /path/vendor/doctrine/dbal/src/Platforms/AbstractMySQLPlatform.php line 677 * {@inheritDoc}
*/
public function getDecimalTypeDeclarationSQL(array $column): string {
return parent::getDecimalTypeDeclarationSQL($column) . $this->getUnsignedDeclaration($column);
}
    /**
    * {@inheritDoc}
at Doctrine\DBAL\Platforms\AbstractMySQLPlatform->getDecimalTypeDeclarationSQL()
in /path/vendor/doctrine/dbal/src/Types/DecimalType.php line 26
debug (‘B’);
debug ($column, ‘getSQLDeclaration $column’);
debug (‘E’);
        return $platform->getDecimalTypeDeclarationSQL($column);
}
    public function convertToPHPValue(mixed $value, AbstractPlatform $platform): ?string
    {
getSQLDeclaration $column
array(14 items)
name => ‘sitemap_priority’ (16 chars)
type => Doctrine\DBAL\Types\DecimalTypeprototypeobject
default => ‘0.5’ (3 chars)
notnull => TRUE
length => 0 (integer)
precision => NULL
scale => 0 (integer)
fixed => FALSE
unsigned => FALSE
autoincrement => FALSE
columnDefinition => NULL
comment => ‘’ (0 chars)
values => array(empty)
version => FALSE

The array index precision = NULL leads to this exception.

Reviews 2