/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

1 vote245 views1 answer
Laravel parent child same table
PHP Laravel
3 votes201 views1 answer
Delete mysql php
PHP
-1 vote228 views1 answer
Laravel merge two arrays helper
PHP
1 vote177 views1 answer
Types of looping directives in laravel
PHP
1 vote195 views2 answers
Laravel collection isNotEmpty
PHP Laravel
0 vote195 views1 answer
Php function crop image
PHP
1 vote161 views1 answer
Phpunit test
PHP
0 vote172 views1 answer
Php is object
PHP
0 vote195 views1 answer
Laravel group concat values showing duplicate
PHP Laravel
31 votes165 views5 answers
Php remove last newline from string
PHP