/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

6 votes176 views2 answers
Php string cut first x characters
PHP
0 vote185 views1 answer
Alert in php after header location
PHP
5 votes152 views1 answer
Php date + one day
PHP
0 vote135 views1 answer
How to pass js formdata to php
PHP
0 vote171 views1 answer
Wp_query order by taxonomy
PHP
1 vote174 views1 answer
Php check if its a name
PHP
3 votes187 views1 answer
Php urlencodedtext
PHP
2 votes174 views1 answer
Laravel model quard
PHP
0 vote168 views1 answer
Ph address format
PHP
0 vote216 views3 answers
Symfony project directory
PHP Symfony