/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 vote333 views1 answer
Radio button select in php
PHP
0 vote297 views6 answers
Use varable on all site pages laravel
PHP
8 votes338 views4 answers
Session unset
PHP
0 vote315 views1 answer
Pcntl_fork php mysql "MySQL server has gone away"
PHP
1 vote320 views1 answer
Static function model laravel
PHP
0 vote332 views1 answer
Laravel where search like with space
PHP Laravel
0 vote298 views1 answer
Get my account orders page url woocommerce
PHP
0 vote296 views1 answer
Parent directory in php
PHP
0 vote284 views1 answer
Search bar php progress
PHP
0 vote314 views4 answers
Today date to ago for the date in php
PHP