Laravel 8 Migration - change enum values

Question

I'm trying to change an enum value in database with Laravel migrations.

In first, i have tried this classic change :

Schema::table('questionnaires', function ($table) {
    $table->enum('type', ['image', 'sound', 'video'])->nullable()->default('image')->change();
});

But I got the following error :

Unknown database type enum requested, Doctrine\DBAL\Platforms\MySQL57Platform may not support it

I solved my problem by doing SQL directly :

DB::statement("ALTER TABLE questionnaires MODIFY COLUMN type ENUM('image', 'sound', 'video') DEFAULT 'image'");

But it does not seem optimal to me...

Is there a solution more in "agreement" with Laravel 8, without going through pure SQL?

Thanks

Take a look at github.com/doctrine/dbal/issues/3161#issuecomment-542814085 — apokryfos
– apokryfos, Commented Oct 26, 2020 at 10:01

lyyka · Accepted Answer · 2020-10-26 10:37:40Z

11

Explanation

To elaborate a little bit more on this subject.

As noted here ENUMs cannot be reverse engineered into a certain type. Each ENUM is a value of it's own. Hence, you must specifically say to Laravel which type the ENUMs are.

This seems to be an issue with all versions of Laravel

In documentation for each version, i.e. https://laravel.com/docs/8.x/migrations#renaming-columns, you can find that changing enum fields is not supported. As noted here the DB statement inside your migration is the best workaround for now.

DB::statement("ALTER TABLE questionnaires MODIFY COLUMN type ENUM('image', 'sound', 'video') DEFAULT 'image'");

Migration files fix

This option is the above commented GitHub link which advises you to put this line of code before the actual migration inside up() method of migration file.

DB::connection()->getDoctrineSchemaManager()->getDatabasePlatform()->registerDoctrineTypeMapping('enum', 'string');

Models/enum types fix

I think this one is a lot less straightforward then the above mentioned, but still exists as a valid option, so I will put it here,

You can read an official doctrine-project website page here which shows you how to this thing from within models / enum types.

edited Oct 26, 2020 at 10:37

answered Oct 26, 2020 at 10:10

lyyka

5603 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Noweh Over a year ago

Thank you for your return. But with this, I have this error : Unknown column type "enum" requested. Any Doctrine type that you use has to be registered with \Doctrine\DBAL\Types\Type::addType(). You can get a list of all the known types with\Doctrine\DBAL\Types\Type::getTypesMap()

lyyka Over a year ago

Which Laravel version are you using?

Noweh Over a year ago

I'm trying on Laravel 8.9. I also tried on a Laravel 6.6 with the same result

lyyka Over a year ago

Yes, going through Laravel docs it seems that each version has this problem. Going with DB statements is the best workaround for now, I've updated my answer to point that out.

Collectives™ on Stack Overflow

Laravel 8 Migration - change enum values

1 Answer 1

Explanation

This seems to be an issue with all versions of Laravel

Migration files fix

Models/enum types fix

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Explanation

This seems to be an issue with all versions of Laravel

Migration files fix

Models/enum types fix

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related