Unknown database type enum requested
Forum rules
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Unknown database type enum requested
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?
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?
Re: Unknown database type enum requested
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?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
Re: Unknown database type enum requested
Is there an ENUM column anywhere else in your database tables?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
Re: Unknown database type enum requested
Yes, I have one.
Why Aimeos installation command changes it?
Сan I somehow avoid it?
- Attachments
-
- unnamed1.png (103.48 KiB) Viewed 3273 times
Re: Unknown database type enum requested
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
https://www.doctrine-project.org/projec ... html#types
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star