/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

19 votes212 views3 answers
Check if array is empty php
PHP
40 votes183 views10 answers
Php array append
PHP
0 vote189 views1 answer
Cakephp extract array
PHP
2 votes201 views1 answer
Return back in blade laravel
PHP Laravel
3 votes179 views3 answers
Laravel get a url using name
PHP
0 vote194 views2 answers
Date 3 months ago for a particular date php
PHP
28 votes215 views12 answers
Laravel middleware
PHP Laravel
2 votes209 views1 answer
Livewire not working
PHP
10 votes197 views2 answers
Try and catch laravel
PHP
0 vote200 views1 answer
Stripe cb test
PHP