/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

1 vote178 views1 answer
Php check if function exists
PHP
1 vote222 views1 answer
Problem 1 - phpspec/prophecy is locked to version 1.13.0 and an update of this package was not requested. - phpspec/prophecy 1.13.0 requires php ^7.2 || ~8.0, <8.1 -> your php version (8.1.2) does not satisfy that requirement.
PHP
51 votes310 views2 answers
Display errors in codeigniter
PHP CodeIgniter
1 vote225 views1 answer
Php mysql prepare query
PHP
1 vote175 views1 answer
Php temp directory
PHP
1 vote235 views1 answer
Laravel difference between fill and update
PHP Laravel
12 votes215 views2 answers
Php code to check if variable is null
PHP
5 votes240 views3 answers
Laravel validation time hours minutes format
PHP Laravel
-2 votes136 views1 answer
Laravel custom rule
PHP
0 vote177 views1 answer
Open phpstorm from terminal
PHP