/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

8 votes326 views6 answers
Laravel collection sum
PHP Laravel
2 votes354 views1 answer
Set session after login with laravel
PHP
1 vote336 views1 answer
Check email exist or not wordpress
PHP
20 votes376 views6 answers
Object to array in php
PHP
0 vote340 views1 answer
How to check if a url has a certain word in laravel
PHP
19 votes339 views2 answers
Typeof php
PHP
0 vote347 views1 answer
Delete record without a page refresh with ajax in php
PHP
0 vote327 views1 answer
How to check my server use cgi, fcgi or fpm.
PHP
-1 vote276 views1 answer
How to get the y-m-d using laravel carbon
PHP
0 vote332 views1 answer
Use php artisan command through controller
PHP