/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 vote319 views1 answer
How get query logs in laravel
PHP Laravel
0 vote274 views2 answers
Codeigniter 4 limit query
PHP
0 vote328 views1 answer
Edit items in Laravel collection
PHP Laravel
0 vote263 views1 answer
Hirudhi
PHP
1 vote266 views1 answer
Get today date magento 2 object manager
PHP
0 vote261 views1 answer
Php if simple
PHP
16 votes255 views2 answers
Php print object
PHP
0 vote239 views1 answer
Advantages of php
PHP
0 vote264 views1 answer
Heroku mysql
PHP
0 vote351 views1 answer
How get last item in foreach in laravel
PHP Laravel