/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

2 votes351 views2 answers
Laravel foreach first
PHP Laravel
1 vote325 views2 answers
Laravel 8 login logout
PHP Laravel
23 votes302 views2 answers
Take 10 character from string using php
PHP
12 votes327 views6 answers
Run seeder in migration laravel
PHP
1 vote300 views2 answers
Update php version using htaccess
PHP
0 vote321 views1 answer
Laravel inverse one to many relationship
PHP
3 votes362 views3 answers
Laravel collection combine
PHP Laravel
5 votes334 views3 answers
Return view controller laravel
PHP
0 vote302 views1 answer
Update query in codeigniter using where condition
PHP
0 vote288 views1 answer
Drupal 9 entity.repository load entity by UUID
PHP