Unknown enum database type in migration file / Doctrine issue

[warrenca]

I used an enum database type and when i run php artisan migration, i got this error

[Doctrine\DBAL\DBALException]
  Unknown database type enum requested, Doctrine\DBAL\Platforms\MySqlPlatform may not support it.

There's a solution to register the enum like this $platform->registerDoctrineTypeMapping('enum', 'string'); here http://wildlyinaccurate.com/doctrine-2-resolving-unknown-database-type-enum-requested but I wonder where to put that in Illuminate.

I tried to put that in Doctrine/DBAL/Schema/MySqlSchemaManager.php and it worked. Is there a better solution?

Line 113 $this->_platform->registerDoctrineTypeMapping('enum', 'string');
Line 114 $type = $this->_platform->getDoctrineTypeMapping($dbType);

[duellsy]

Was there ever an elegant solution to this found rather than modifying MySqlSchemaManager.php file?

[ejunker]

I ran into a similar issue with a legacy database that uses enum. I think I found a way to register the enum type and I put this in start/global.php but it is not working.

$platform = DB::getDoctrineSchemaManager()->getDatabasePlatform();
$platform->registerDoctrineTypeMapping('enum', 'string');

$platform = DB::getDoctrineConnection()->getDatabasePlatform();
$platform->registerDoctrineTypeMapping('enum', 'string');

Anybody gotten this to work?

[endel]

Maybe this could help you out: #1186 (comment)

[duellsy]

👍 Good work

[fero]

Set the engine to InnoDb:

$table->engine = 'InnoDB';

[Saif-hub24]

I am using laravel 5.2 but it still not working. Any help is much appreciated.

[farzamtm]

I ran into a similar issue with a legacy database that uses enum. I think I found a way to register the enum type and I put this in start/global.php but it is not working.

$platform = DB::getDoctrineSchemaManager()->getDatabasePlatform();
$platform->registerDoctrineTypeMapping('enum', 'string');

$platform = DB::getDoctrineConnection()->getDatabasePlatform();
$platform->registerDoctrineTypeMapping('enum', 'string');

Anybody gotten this to work?

Yes. It worked for me.

[infostreams]

To do this in Laravel 7 you can create a file app\Providers\EnumServiceProvider.php with the following contents

<?php
namespace App\Providers;

use Illuminate\Support\Facades\DB;
use Illuminate\Support\ServiceProvider;

class EnumServiceProvider extends ServiceProvider {
    public function boot() {
        // see https://github.com/laravel/framework/issues/1346
        $platform = DB::getDoctrineSchemaManager()->getDatabasePlatform();
        $platform->registerDoctrineTypeMapping('enum', 'string');

        $platform = DB::getDoctrineConnection()->getDatabasePlatform();
        $platform->registerDoctrineTypeMapping('enum', 'string');
    }
}

and then add App\Providers\EnumServiceProvider::class to the "providers" array in config/app.php to get it to run on boot.

[n3storm]

To do this in Laravel 7 you can create a file app\Providers\EnumServiceProvider.php with the following contents

<?php
namespace App\Providers;

use Illuminate\Support\Facades\DB;
use Illuminate\Support\ServiceProvider;

class EnumServiceProvider extends ServiceProvider {
    public function boot() {
        // see https://github.com/laravel/framework/issues/1346
        $platform = DB::getDoctrineSchemaManager()->getDatabasePlatform();
        $platform->registerDoctrineTypeMapping('enum', 'string');

        $platform = DB::getDoctrineConnection()->getDatabasePlatform();
        $platform->registerDoctrineTypeMapping('enum', 'string');
    }
}

and then added App\Providers\EnumServiceProvider::class to the "providers" array in config/app.php to get it to run on boot.

This works on Laravel 6 too.

[fttx]

To do this in Laravel 7 you can create a file app\Providers\EnumServiceProvider.php with the following contents

<?php
namespace App\Providers;

use Illuminate\Support\Facades\DB;
use Illuminate\Support\ServiceProvider;

class EnumServiceProvider extends ServiceProvider {
    public function boot() {
        // see https://github.com/laravel/framework/issues/1346
        $platform = DB::getDoctrineSchemaManager()->getDatabasePlatform();
        $platform->registerDoctrineTypeMapping('enum', 'string');

        $platform = DB::getDoctrineConnection()->getDatabasePlatform();
        $platform->registerDoctrineTypeMapping('enum', 'string');
    }
}

and then add App\Providers\EnumServiceProvider::class to the "providers" array in config/app.php to get it to run on boot.

This solution fixes the enum issue with filament