/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 vote245 views2 answers
Wpdb get results foreach
PHP
0 vote247 views1 answer
Fuelphp authentication
PHP
1 vote241 views1 answer
How show pice of text in php
PHP
0 vote265 views1 answer
How unique field in table in phpmyadmin
PHP
0 vote254 views1 answer
The "App\Entity\ entity has a repositoryClass set to but this is not a valid class.
PHP
15 votes324 views3 answers
Laravel target class does not exist
PHP Laravel
6 votes370 views1 answer
Get domain from url cakephp
PHP CakePHP
0 vote239 views3 answers
Laravel collection sort
PHP Laravel
0 vote288 views1 answer
Query without chaining not working - Laravel
PHP Laravel
0 vote325 views1 answer
Laravel catch TokenMismatchException
PHP Laravel