运行时，Laravel迁移在“重命名列”上失败

Question

我有大约30个迁移文件。

当它到达包含重命名列的迁移时：

Schema::table('table', function (Blueprint $table) {
 $table->renameColumn('old_field', 'new_field');
});

它只会在迁移时出错（比如说，第15个）。它可以正常运行所有其他迁移。如果我对此进行评论，那么它将按预期完成。

我运行php artisan migrate或php artisan migrate:fresh

我得到以下错误：

 ErrorException  : The "name" column option is not supported, setting it is deprecated and will cause an error in Doctrine 3.0

  at /Volumes/Workspace/new-app-backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Column.php:85
    81|                 @trigger_error(sprintf(
    82|                     'The "%s" column option is not supported,' .
    83|                     ' setting it is deprecated and will cause an error in Doctrine 3.0',
    84|                     $name
  > 85|                 ), E_USER_DEPRECATED);
    86| 
    87|                 continue;
    88|             }
    89|             $this->$method($value);

  Exception trace:

  1   trigger_error("The "name" column option is not supported, setting it is deprecated and will cause an error in Doctrine 3.0")
      /Volumes/Workspace/new-app-backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Column.php:85

  2   Doctrine\DBAL\Schema\Column::setOptions()
      /Volumes/Workspace/new-app-backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Column.php:67

PHP-v给了我这个：

PHP 7.3.14 (cli) (built: Jan 24 2020 03:04:31) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.3.14, Copyright (c) 1998-2018 Zend Technologies
    with Xdebug v2.9.2, Copyright (c) 2002-2020, by Derick Rethans
    with Zend OPcache v7.3.14, Copyright (c) 1999-2018, by Zend Technologies

MySQL-v给了我这个：

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 323
Server version: 5.7.29 Homebrew

我使用的是“条令/dbal”：“~2.3”

此错误仅在本地计算机上运行迁移时发生。在我的docker-compose堆栈和Vagant框中按预期完成。所有版本都相同。为什么这只发生在我的mac上？

Answer 1

这似乎在v2中得到了解决。7[bug]不要跳过列选项#3089

2.7中断mysql 5.7#3091中重命名列

使用composer update doctor/dbal升级软件包版本。

Answer 2

解决方法我在网上找到的

Schema::table('table', function (Blueprint $table) {
    \DB::statement("ALTER TABLE table_name
CHANGE COLUMN old_column_name new_column_name data_type;");
});

我希望这有帮助。

参考文献

1. 在迁移中重命名列失败
2. 在MySQL中重命名列