/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 vote210 views1 answer
Laravel store mail driver info in database
PHP
103 votes605 views6 answers
Php str_replace
PHP
0 vote227 views1 answer
Remove repeated columns laravel
PHP
0 vote192 views3 answers
Laravel pagination with search filter
PHP
0 vote270 views1 answer
Laravel joins eloquent model
PHP Laravel
1 vote230 views1 answer
Laravel pagination publish command
PHP
0 vote183 views2 answers
Php add to array in loop
PHP
0 vote312 views1 answer
Wordpress logout redirect to home
PHP
1 vote182 views1 answer
Get the category wp
PHP
5 votes179 views1 answer
Wordpress get taxonomy of a post
PHP