/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 vote137 views1 answer
Change column name in phpmyadmin
PHP
0 vote128 views1 answer
Php dias entre dos fechas
PHP
1 vote136 views1 answer
Laravel validate enum field
PHP Laravel
17 votes158 views5 answers
?: php
PHP
0 vote120 views1 answer
Wc php order view order link
PHP
2 votes124 views2 answers
Dir name php
PHP
1 vote121 views1 answer
Php mysqli number row
PHP
0 vote131 views1 answer
Laravel 8 template favicon
PHP
-1 vote129 views1 answer
Get php to send email from form
PHP
4 votes117 views1 answer
Php artisan make:auth Command "make:auth" is not defined.
PHP