/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 votes165 views2 answers
Wordpress theme The link you followed has expired.
PHP
0 vote156 views1 answer
Laravel: get last id
PHP Laravel
0 vote206 views1 answer
Laravel create registration bootstrap
PHP Laravel
0 vote141 views2 answers
Yyyymmdd to yyyy-mm-dd php
PHP
1 vote151 views1 answer
Get elasticsearch data magento 2
PHP
1 vote137 views2 answers
Php get data from url
PHP
0 vote143 views1 answer
Php check valid time format
PHP
8 votes157 views3 answers
Validate time in laravel
PHP Laravel
3 votes147 views1 answer
Laravel web.php auth Undefined type 'Auth'.
PHP
0 vote151 views1 answer
Bootswatch import theme into laravell vuejs
PHP