/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 vote163 views1 answer
How can get attribute without getter in laravel
PHP Laravel
5 votes147 views3 answers
Laravel permission denied storage log
PHP Laravel
0 vote151 views1 answer
Wordpress translate specific text php
PHP Wordpress
0 vote143 views1 answer
Check value falls between in two range in php
PHP
1 vote149 views2 answers
Wp cli command activate plugin
PHP
0 vote165 views1 answer
Menyimpan get di laravel
PHP Laravel
9 votes133 views6 answers
Php add days to date
PHP
0 vote139 views2 answers
Readable var dump php
PHP
0 vote197 views1 answer
Merge Cell phpoffice phpexcel
PHP
8 votes166 views6 answers
Laravel validation date
PHP Laravel