/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 vote341 views1 answer
Laravelstart project
PHP Laravel
0 vote313 views1 answer
Laravel filter get pagiination does not flter Appending To Pagination Links
PHP Laravel
1 vote291 views3 answers
Laravel JSON query
PHP Laravel
0 vote322 views2 answers
Laravel undefined index
PHP Laravel
0 vote283 views2 answers
Php session regenerate id
PHP
0 vote341 views1 answer
Install PHP extension "amqp" not found, please install it
PHP
0 vote286 views1 answer
Enable phpmailer cpanel
PHP
20 votes290 views4 answers
Get url with php
PHP
30 votes287 views6 answers
Artisan make auth
PHP
0 vote277 views1 answer
Cakephp find_in_set
PHP