/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

32 votes168 views4 answers
Php json encode
PHP
0 vote181 views2 answers
How to use php in laravel blade
PHP
0 vote217 views1 answer
Nginx phpmyadmin subdirectory
PHP
0 vote219 views1 answer
Codeigniter form open
PHP
0 vote204 views1 answer
Axios post not sending data php
PHP
1 vote151 views1 answer
Laravel model find one
PHP Laravel
80 votes290 views6 answers
Php to int
PHP
0 vote155 views3 answers
Laravel load relationship
PHP
1 vote202 views1 answer
Laravel command parameter optional
PHP Laravel
12 votes171 views3 answers
Get featured image url
PHP