/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 vote297 views1 answer
Check array is associative laravel
PHP
0 vote311 views2 answers
How to print string plus variable in php
PHP
0 vote266 views1 answer
<?php echo do_shortcode('[gravityform id="1" title="false" description="false" ajax="true"]') ?>
PHP
0 vote284 views1 answer
Payment gateway webhook returning 302 laravel
PHP
0 vote304 views2 answers
Script inside php
PHP
2 votes386 views1 answer
Wordpress get post time
PHP Wordpress
0 vote291 views1 answer
Php show number 4 digit
PHP
4 votes338 views1 answer
Laravel relation of relation
PHP Laravel
1 vote297 views2 answers
Yii1 set flash
PHP
3 votes296 views2 answers
Seconds to minutes php
PHP