/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 vote151 views1 answer
Login with email or username codeigniter 4
PHP
0 vote191 views1 answer
Woocommerce mini cart ajax count
PHP
1 vote212 views3 answers
Php hide errors
PHP
3 votes191 views2 answers
Get the string after a character in php
PHP
1 vote192 views1 answer
Path to php cli moodle in moodle
PHP
1 vote213 views1 answer
Laravel not finding asset files in public directory
PHP Laravel
0 vote170 views1 answer
Add floater to open a modal in wordpress
PHP
0 vote191 views1 answer
Php print array new line
PHP
7 votes191 views3 answers
Carbon get today's month
PHP
2 votes185 views3 answers
In PackageManifest.php line 122: Undefined index: name
PHP