/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 vote232 views1 answer
How to create table for every user in laravel
PHP Laravel
0 vote196 views1 answer
Yii2 GridView Filtering on Relational Column
PHP
0 vote213 views1 answer
Symfony form get errors
PHP Symfony
9 votes208 views3 answers
Laravel enum migration
PHP Laravel
0 vote241 views1 answer
Comment php laravel template blade
PHP
23 votes206 views6 answers
Laravel model insert
PHP Laravel
7 votes176 views3 answers
Php artisan serve port
PHP
0 vote258 views1 answer
Php money_format currency symbol
PHP
0 vote178 views1 answer
Regenerate session ID and remove all session data
PHP
0 vote185 views1 answer
Throws php
PHP