/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

2 votes337 views2 answers
Laravel insert timestamp now
PHP
0 vote331 views1 answer
Phpspreadsheet
PHP
8 votes352 views6 answers
Laravel validation date
PHP
0 vote318 views1 answer
Get text field value in php
PHP
13 votes333 views4 answers
Laravel migration remove column
PHP Laravel
1 vote371 views2 answers
Regular expression for strong password in php
PHP
24 votes321 views2 answers
Clear laravel cache and clear vue
PHP
0 vote392 views1 answer
Wordpress send reset password link inside wp_new_user_notification_email
PHP Wordpress
16 votes338 views1 answer
League/omnipay v3.0.0 requires php ^7.1 -> your php version (8.0.11) does not satisfy that requirement
PHP
5 votes320 views1 answer
Check composer php version
PHP