/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 vote241 views1 answer
Tailwindcss - bootstrap - vue - react
PHP
0 vote255 views1 answer
Get data from model in chunks laravel
PHP
0 vote295 views1 answer
Laravel Facades\DB update
PHP Laravel
0 vote297 views1 answer
Show sender name laravel
PHP Laravel
0 vote262 views1 answer
Laravel belongsto nested
PHP
1 vote306 views2 answers
Is home page if wordpress
PHP Wordpress
1 vote263 views1 answer
And php
PHP
10 votes257 views2 answers
Convert collection to array laravel
PHP
0 vote243 views1 answer
App\Http\Controllers\Validator not found
PHP
0 vote272 views1 answer
Indirect modification of overloaded property has no effect laravel
PHP