/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 vote306 views1 answer
Using php, how to create a folder in another folder
PHP
0 vote322 views1 answer
Validate rule if row exist laravel
PHP
0 vote332 views1 answer
Edit a row from databse using php
PHP
3 votes320 views2 answers
Default port for laravel
PHP Laravel
0 vote430 views1 answer
Supprimer automatiquement les mots courts des URL pour un meilleur SEO dans WordPress
PHP Wordpress
0 vote333 views1 answer
Composer require rtconner/laravel-tagging
PHP
7 votes372 views2 answers
Laravel carbon get month number
PHP Laravel
0 vote364 views2 answers
Notice: Trying to get property 'NAME' of non-object in
PHP
0 vote450 views1 answer
How to retrieve data from database using select option in laravel
PHP Laravel
0 vote331 views2 answers
Laravel allow all fillable
PHP