/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

8 votes247 views2 answers
How to debug in php
PHP
0 vote202 views1 answer
Withsuccess laravel
PHP
0 vote219 views2 answers
PHP $argv echo with number of words
PHP
19 votes219 views4 answers
Php read sql
PHP
0 vote247 views1 answer
Length shorter
PHP
4 votes245 views3 answers
Laravel 7 eloquent on delete set null schema
PHP
0 vote255 views1 answer
Laravel Can't write image data to path Image::make($image)->resize
PHP Laravel
1 vote232 views1 answer
Get category post in wordpress
PHP
3 votes254 views2 answers
Laravel collection concat
PHP Laravel
0 vote189 views1 answer
If is gutenberg page php wp
PHP