/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

16 votes103 views6 answers
Confirm password validation laravel
PHP
0 vote94 views1 answer
Session not working php
PHP
0 vote102 views1 answer
Enhanced ecommerce data layer for woocommerce
PHP
0 vote91 views1 answer
Laravel request query logger
PHP
0 vote139 views1 answer
Wordpress disable php update required
PHP Wordpress
1 vote108 views1 answer
Search on taxonomy wordpress query
PHP Wordpress
4 votes103 views2 answers
Check request header laravel
PHP Laravel
22 votes110 views6 answers
Php write to file
PHP
0 vote80 views1 answer
Redirect with compact laravel
PHP Laravel
1 vote115 views1 answer
Laravel failed jobs retry
PHP Laravel