/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

4 votes124 views2 answers
Laravel collection random
PHP Laravel
0 vote105 views1 answer
Installing Maatwebsite excel import export package
PHP
10 votes117 views2 answers
Format date in laravel using carbon
PHP Laravel
53 votes249 views6 answers
Laravel join
PHP Laravel
24 votes86 views2 answers
Php ifelse
PHP
6 votes103 views5 answers
Laravel collection map
PHP
0 vote114 views1 answer
Laravel withcount change name
PHP Laravel
7 votes101 views3 answers
Wordpress custom loop
PHP
8 votes129 views1 answer
If any error in blade laravel
PHP Laravel
-2 votes96 views4 answers
Codeigniter 3 update
PHP