/PHP/[Doctrine\DBAL\DBALException]Unknown database type enum requested, Doctrine\DBAL\Platforms\MySqlPlatform may not support it.

[Doctrine\DBAL\DBALException]Unknown database type enum requested, Doctrine\DBAL\Platforms\MySqlPlatform may not support it.

It is a known issue as stated in Laravel 5.1 documentation.

    Note: Renaming columns in a table with a enum column is not currently supported.

It happens when you have a enum column in your database table. Whether you are trying to rename another column, or change another column to nullable, this bug will appear. It's an issue with Doctrine\DBAL.

An easy fix for this is to just add this constructor method in your database migration file.

public function __construct()
{
    DB::getDoctrineSchemaManager()->getDatabasePlatform()->registerDoctrineTypeMapping('enum', 'string');
}

This will map all the ENUM columns to VARCHAR(), and the column will accept any string.

    This worked for me on Laravel 5.1 and Laravel 5.3. I hope this bug can be fixed soon.

Credit to @Gmatkowski's answer at https://stackoverflow.com/a/32860409/1193201

Source: stackoverflow.com

Similar codes

22 votes218 views5 answers
Update or insert in laravel
PHP Laravel
-2 votes161 views1 answer
Timestamp property in laravle
PHP
1 vote207 views1 answer
How send parameter with command in laravel
PHP
-1 vote218 views1 answer
Return true false laravel
PHP Laravel
0 vote209 views2 answers
MYSQL_ASSOC, MYSQL_NUM, et MYSQL_BOTH
PHP
0 vote195 views1 answer
Run phpcs from vs code
PHP
0 vote215 views1 answer
Twig for loop key
PHP
1 vote204 views1 answer
Php top frameworks
PHP
0 vote252 views1 answer
Laravel 8 jwt api authentication
PHP Laravel
11 votes221 views2 answers
Php filter validate email
PHP