/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 vote121 views1 answer
Model json laravel accessor to convert to array
PHP
3 votes100 views1 answer
Php nested array contains
PHP
17 votes102 views6 answers
Laravel Routing
PHP
0 vote116 views1 answer
Php rechercher dans une chaine
PHP
0 vote107 views1 answer
Update button
PHP
0 vote126 views1 answer
Controller class does not exist laravel
PHP Laravel
0 vote109 views1 answer
Laravel blank page
PHP
0 vote110 views1 answer
Type casting in php
PHP
0 vote100 views2 answers
Php codeigniter unit testing
PHP
8 votes114 views3 answers
Eloquent using last()
PHP