/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

-2 votes110 views3 answers
Laravel when condition
PHP
7 votes122 views1 answer
Laravel if syntax
PHP
0 vote130 views1 answer
Woocommerce function traduccion label
PHP
0 vote179 views1 answer
How to list notification from database
PHP
0 vote183 views1 answer
Pass array from controller laravel with compact
PHP Laravel
6 votes96 views3 answers
Laravel unique validation
PHP
0 vote117 views1 answer
Laravel model isdirty
PHP
3 votes145 views1 answer
Validate each value from array laravel
PHP Laravel
2 votes129 views1 answer
Gd extension docker php
PHP
54 votes121 views6 answers
Php today date
PHP