#106803Doctrine DBAL 4.3-dev exception on "InvalidColumnDeclaration" in DB compare (EXT:seo pages.sitemap_priority column)
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.