/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

6 votes159 views2 answers
Get size files in laravel
PHP
8 votes141 views3 answers
Php get timezone
PHP
0 vote145 views1 answer
Php only includable file
PHP
1 vote149 views1 answer
Append single qoute arounf variable in php string
PHP
0 vote213 views1 answer
How to set cookie expire time in php
PHP
0 vote190 views1 answer
Codeigniter sms send
PHP CodeIgniter
-1 vote165 views3 answers
Fore install debian 10 php 7.3
PHP
4 votes164 views2 answers
Php move file
PHP
0 vote186 views1 answer
Use multiple pagination in same page laravel
PHP Laravel
0 vote148 views2 answers
Take file data in variable php
PHP