/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 vote110 views1 answer
Print prety php
PHP
6 votes100 views5 answers
Php new object
PHP
0 vote105 views1 answer
Token delete laravel
PHP
0 vote131 views1 answer
How to remove array index from json in php
PHP
1 vote133 views2 answers
Laravel maximum execution time of 30 seconds exceeded
PHP Laravel
0 vote94 views1 answer
Laravel string capitalize in view
PHP
33 votes127 views6 answers
Laravel query builder
PHP Laravel
0 vote68 views1 answer
Warning: sprintf(): too few arguments in c:laragonwwwglobalallianceregisterwp-adminincludesclass-bulk-upgrader-skin.php on line 152
PHP
14 votes159 views6 answers
Wordpress get user by id
PHP Wordpress
3 votes113 views3 answers
Count sql query in php
PHP