/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 vote113 views2 answers
Php bulk insert mysql
PHP
1 vote124 views1 answer
Select sum in laravel
PHP Laravel
1 vote184 views4 answers
Laravel flash message
PHP Laravel
0 vote111 views1 answer
Php insert in array
PHP
3 votes139 views2 answers
Remove admin bar wordpress front end
PHP Wordpress
0 vote124 views1 answer
Generate unique order id in php
PHP
0 vote78 views1 answer
How to remove one element from array
PHP
0 vote116 views1 answer
Replace key name in associative array
PHP
0 vote108 views1 answer
Access-control-allow-origin php laravel
PHP
0 vote117 views1 answer
Php isset multiple
PHP