/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 vote289 views1 answer
Eloquent self foreign key
PHP
4 votes341 views2 answers
On update current timestamp laravel migration
PHP Laravel
0 vote301 views1 answer
Drupal sync directory in settings.php
PHP
0 vote289 views1 answer
Magento colloction query
PHP
1 vote311 views1 answer
Isset blade laravel
PHP
1 vote299 views1 answer
Remove all attributes from HTML tags in PHP
PHP
0 vote293 views1 answer
If condition view page of laravel
PHP
0 vote290 views1 answer
This domain is not registered with Tiny Cloud. Please see the quickstart guide or create an account.
PHP
1 vote293 views1 answer
Check network connection php
PHP
0 vote315 views1 answer
Variable "$id" is not defined by operation "GetPost".
PHP