/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

100 votes279 views6 answers
Replace in php
PHP
3 votes165 views4 answers
Magento Fatal error: Allowed memory size of 134217728 bytes exhausted
PHP
0 vote181 views1 answer
How to superscript th in php date
PHP
14 votes191 views4 answers
Laravel set timezone dynamically
PHP Laravel
0 vote184 views1 answer
PHP (WordPress) - Increase Maximum Upload File Size
PHP Wordpress
3 votes327 views2 answers
Index.php in codeigniter
PHP CodeIgniter
1 vote164 views1 answer
User-agent cURL php
PHP
0 vote164 views1 answer
Including ACF in a custom theme or plugin
PHP
0 vote168 views1 answer
Regex get text between braces
PHP
0 vote213 views6 answers
Update codeigniter
PHP CodeIgniter