/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

0 vote222 views1 answer
Laravel factory get foreign key
PHP
1 vote214 views1 answer
Behamin brequest installation on laravel
PHP Laravel
0 vote202 views1 answer
Token delete laravel
PHP
1 vote209 views2 answers
Laravel, return view with Request::old
PHP
0 vote198 views1 answer
Arr::only laravel
PHP
0 vote234 views1 answer
Php heredoc variable substitution
PHP
2 votes233 views3 answers
Laravel public static variable
PHP Laravel
0 vote248 views1 answer
Get previous url symfony 4 in formpage
PHP
2 votes269 views3 answers
Laravel web php request to redirect to another page
PHP Laravel
0 vote170 views1 answer
Laravel check if relationship has data
PHP