/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 vote208 views1 answer
Laravel inline if else if
PHP
0 vote240 views1 answer
Http error code php
PHP
4 votes254 views1 answer
How to check query execution time in laravel
PHP
11 votes298 views3 answers
Require password confirm laravel
PHP Laravel
21 votes269 views6 answers
Laravel route parameters
PHP Laravel
0 vote241 views2 answers
Laravel validation exact string length
PHP
0 vote256 views1 answer
Composer update php mbstring.so missing
PHP
35 votes253 views6 answers
For loop php
PHP
0 vote281 views1 answer
Create or update laravel 5.8 stackoverflow
PHP Laravel
2 votes247 views3 answers
In PackageManifest.php line 122: Undefined index: name
PHP