/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 vote437 views1 answer
How to stop laravel server
PHP Laravel
2 votes281 views3 answers
Laravel get input from request
PHP
6 votes293 views4 answers
Install laravel on windows
PHP
16 votes334 views5 answers
Laravel blade for loop
PHP Laravel
25 votes242 views4 answers
ERROR 1071 (42000) at line 76: Specified key was too long; max key length is 767 bytes laravel
PHP
0 vote309 views1 answer
Laravel-medialibrary change name of file
PHP Laravel
1 vote298 views1 answer
Get post order by meta value int
PHP
0 vote294 views1 answer
Douzo definition
PHP
4 votes292 views3 answers
Laravel use config
PHP
0 vote278 views1 answer
How to check where function defined in php
PHP