Laravel db 迁移 - renameColumn 错误 - 请求了未知的数据库类型枚举

2022-01-08 00:00:00 migration php mysql laravel laravel-4

我正在使用 Laravel 4.2.我的 composer.json

I am using Laravel 4.2. I have the following library loaded in my composer.json

"doctrine/dbal": "2.4.*",

我创建了以下迁移:

class RenameDeliveryNotesColumnOnOrderHeaderTable extends Migration {

    public function up()
    {
        Schema::table('order_header', function(Blueprint $table)
        {
            $table->renameColumn('delivery_notes', 'packing_notes');
        });
    }

}

其中 delivery_notes 列类型为 text.

当我运行迁移时,我收到以下错误:

When I run the migration, I get the following error:

[DoctrineDBALDBALException] 请求的未知数据库类型枚举,DoctrineDBALPlatformsMySqlPlatform 可能不支持.

[DoctrineDBALDBALException] Unknown database type enum requested, DoctrineDBALPlatformsMySqlPlatform may not support it.

知道为什么我会收到此错误吗?我应该如何解决这个问题?我需要重命名表中的列.有没有其他方法可以重命名列?

Any idea why I am getting this error? How should I go about fixing this? I need to rename a column in my table. Are there any alternative way to rename the column?

推荐答案

Laravel 的文档 说:

注意:不支持重命名 enum 列类型.

Note: Renaming enum column types is not supported.

这里:https://github.com/laravel/framework/issues/1186

您可以找到一些解决此问题的方法.既然你说这个专栏不是enum,那就看看@upngo的评论:

You can find some workarounds about this issue. And since you said that this column is not enum, take a look at @upngo's comment:

...问题是重命名具有 enum 的表上的 ANY 列."

"...The issue is renaming ANY column on a table that has an enum."

我还发现这篇文章关注这个问题,并提出了一个可能对你有帮助的选项.

Also I found this article that focuses on this issue and suggest an option that might help you.

http://www.paulbill.com/110/laravel-unknown-database-type-enum-requested-doctrinedbalplatformsmysqlplatform-may-not-support-it

相关文章