/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 vote153 views1 answer
Laravel get all vendor files
PHP
2 votes141 views3 answers
Name of today php
PHP
2 votes133 views1 answer
Check if value is not null in db laravel
PHP
1 vote126 views1 answer
How to take last entry in database in laravel Method ONe
PHP
71 votes132 views6 answers
Convert string to int php
PHP
0 vote232 views1 answer
Schema key issue laravel
PHP Laravel
0 vote118 views1 answer
Web servers supported by php
PHP
1 vote158 views1 answer
Laravel get next record
PHP Laravel
3 votes90 views1 answer
Php location
PHP
13 votes121 views5 answers
Remove empty array elements php
PHP