/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

12 votes251 views4 answers
Wordpress get post thumbnail
PHP Wordpress
0 vote154 views2 answers
Wp menu declaration
PHP Wordpress
1 vote135 views1 answer
Add a year php
PHP
6 votes95 views1 answer
Get current year laravel blade
PHP
0 vote179 views1 answer
Como leer archivos .env php
PHP
0 vote220 views1 answer
Wordpress highlight text excerpt
PHP Wordpress
3 votes137 views1 answer
Phpcs
PHP
28 votes136 views3 answers
Remove array values php
PHP
13 votes139 views3 answers
Laravel string
PHP Laravel
0 vote169 views2 answers
Octobercms mail
PHP