/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

3 votes166 views3 answers
Foreach date php
PHP
0 vote167 views1 answer
Controller run
PHP
48 votes165 views6 answers
Laravel join table
PHP
0 vote236 views1 answer
S how to store jwt in http cookie laravel
PHP Laravel
0 vote160 views1 answer
Echo all php global variables
PHP
0 vote155 views1 answer
Php hook function
PHP
3 votes221 views1 answer
Laravel back button
PHP Laravel
1 vote157 views1 answer
Laravel use references in other tables
PHP
1 vote167 views1 answer
Php random float number with 2 decimal places
PHP
0 vote226 views1 answer
Delete Query with Where Condition in Codeigniter
PHP