/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 vote201 views3 answers
Laravel public ParseError syntax error, unexpected '$conversion' (T_VARIABLE), expecting ',' or ')' /
PHP Laravel
0 vote173 views1 answer
Clean function in php
PHP
18 votes256 views5 answers
Create model, controller and migration in single command laravel
PHP Laravel
1 vote179 views1 answer
Laravel validation required_if one parameter exist
PHP
0 vote258 views2 answers
Php select from database into array
PHP
0 vote173 views1 answer
The posts pagination
PHP
0 vote195 views2 answers
Polymorphism in php
PHP
1 vote194 views1 answer
Webstorm copy file url
PHP
0 vote186 views3 answers
Run queue after x minutes laravel
PHP
0 vote178 views1 answer
Php utc time
PHP