/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

10 votes126 views4 answers
Twig dump
PHP
20 votes137 views6 answers
Php array sort by key
PHP
15 votes148 views6 answers
Laravel db transaction
PHP Laravel
0 vote178 views1 answer
Keep only n elements of array php
PHP
0 vote122 views1 answer
How to use custome functions in laravel
PHP
0 vote153 views1 answer
Php remove utf non breaking space
PHP
0 vote156 views1 answer
Laravel-medialibrary packagist
PHP Laravel
0 vote131 views1 answer
Enque scripts from plugin
PHP
40 votes142 views6 answers
Php remove element from array
PHP
0 vote141 views3 answers
Laravel validation alphanumeric with spaces
PHP