Unknown database type enum requested

[vision]

Hello everyone!

Ubuntu 20.04
PHP 8.1
aimeos/aimeos-laravel: "~2022.10"

Facing this porblem during: "php artisan aimeos:setup --option=setup/default/demo:1" :

Initializing or updating the Aimeos database tables for site "default"
Migrating: vendor/aimeos/aimeos-core/setup/TypesMigrateColumns.php

Doctrine\DBAL\Exception

Unknown database type enum requested, Doctrine\DBAL\Platforms\MySQL80Platform may not support it.

at vendor/doctrine/dbal/src/Platforms/AbstractPlatform.php:441
437▕
438▕ $dbType = strtolower($dbType);
439▕
440▕ if (! isset($this->doctrineTypeMapping[$dbType])) {
➜ 441▕ throw new Exception(
442▕ 'Unknown database type ' . $dbType . ' requested, ' . static::class . ' may not support it.',
443▕ );
444▕ }
445▕

+30 vendor frames
31 artisan:37
Illuminate\Foundation\Console\Kernel::handle()


Log:


[2022-12-01 11:33:35] local.ERROR: Unknown database type enum requested, Doctrine\DBAL\Platforms\MySQL80Platform may not support it. {"exception":"[object] (Doctrine\\DBAL\\Exception(code: 0): Unknown database type enum requested, Doctr>
[stacktrace]
#0 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/doctrine/dbal/src/Schema/MySQLSchemaManager.php(186): Doctrine\\DBAL\\Platforms\\AbstractPlatform->getDoctrineTypeMapping()
#1 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php(1408): Doctrine\\DBAL\\Schema\\MySQLSchemaManager->_getPortableTableColumnDefinition()
#2 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php(423): Doctrine\\DBAL\\Schema\\AbstractSchemaManager->_getPortableTableColumnList()
#3 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/doctrine/dbal/src/Schema/MySQLSchemaManager.php(66): Doctrine\\DBAL\\Schema\\AbstractSchemaManager->doListTables()
#4 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php(1651): Doctrine\\DBAL\\Schema\\MySQLSchemaManager->listTables()
#5 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/aimeos/upscheme/src/Schema/DB.php(838): Doctrine\\DBAL\\Schema\\AbstractSchemaManager->createSchema()
#6 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/aimeos/upscheme/src/Schema/DB.php(54): Aimeos\\Upscheme\\Schema\\DB->setup()
#7 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/aimeos/upscheme/src/Up.php(110): Aimeos\\Upscheme\\Schema\\DB->__construct()
#8 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/aimeos/upscheme/src/Task/Base.php(87): Aimeos\\Upscheme\\Up->db()
#9 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/aimeos/aimeos-core/setup/TypesMigrateColumns.php(147): Aimeos\\Upscheme\\Task\\Base->db()
#10 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/aimeos/aimeos-core/setup/TypesMigrateColumns.php(122): Aimeos\\Upscheme\\Task\\TypesMigrateColumns->addColumn()
#11 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/aimeos/upscheme/src/Up.php(324): Aimeos\\Upscheme\\Task\\TypesMigrateColumns->up()
#12 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/aimeos/upscheme/src/Up.php(311): Aimeos\\Upscheme\\Up->runTasks()
#13 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/aimeos/upscheme/src/Up.php(311): Aimeos\\Upscheme\\Up->runTasks()
#14 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/aimeos/upscheme/src/Up.php(170): Aimeos\\Upscheme\\Up->runTasks()
#15 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/aimeos/aimeos-core/Setup.php(84): Aimeos\\Upscheme\\Up->up()
#16 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/aimeos/aimeos-laravel/src/Aimeos/Shop/Command/SetupCommand.php(69): Aimeos\\Setup->up()
#17 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Aimeos\\Shop\\Command\\SetupCommand->handle()
#18 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#19 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#20 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod()
#21 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/laravel/framework/src/Illuminate/Container/Container.php(651): Illuminate\\Container\\BoundMethod::call()
#22 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Illuminate\\Container\\Container->call()
#23 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/symfony/console/Command/Command.php(312): Illuminate\\Console\\Command->execute()
#24 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/laravel/framework/src/Illuminate/Console/Command.php(152): Symfony\\Component\\Console\\Command\\Command->run()
#25 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/symfony/console/Application.php(1020): Illuminate\\Console\\Command->run()
#26 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/symfony/console/Application.php(312): Symfony\\Component\\Console\\Application->doRunCommand()
#27 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/symfony/console/Application.php(168): Symfony\\Component\\Console\\Application->doRun()
#28 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\\Component\\Console\\Application->run()
#29 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\\Console\\Application->run()
#30 /var/www/tatmedia/devshop.tatmedia.ru/releases/5/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle()
#31 {main}


How can I fix it?

[aimeos]

We haven't seen that before but maybe you are using an ENUM column type in your existing Laravel "users" table which Doctrine can't handle?

[vision]

We haven't seen that before but maybe you are using an ENUM column type in your existing Laravel "users" table which Doctrine can't handle?

Thank U!
I'll have a look-see.

[vision]

We haven't seen that before but maybe you are using an ENUM column type in your existing Laravel "users" table which Doctrine can't handle?

I've no ENUM column type in my existing Laravel "users" table(

[vision]

Безымянный.png (82.98 KiB) Viewed 3048 times

[aimeos]

Is there an ENUM column anywhere else in your database tables?

[vision]

Is there an ENUM column anywhere else in your database tables?

Yes, I have one.
Why Aimeos installation command changes it?
Сan I somehow avoid it?

[aimeos]

It's not Aimeos, Doctrine DBAL (which we use for schema updates) parses the complete database schema and don't understand the ENUM data type:
https://www.doctrine-project.org/projec ... html#types