Laravel migration [ErrorException]未定义索引:index_type

Question

我正在尝试迁移我的laravel项目。

但是当我输入迁移命令时，我得到这个错误。我不明白为什么它给我这个错误，当我试图迁移我的项目。

[ErrorException]             
  Undefined index: index_type  

Exception trace:
 () at /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/MySqlSchemaManager.php:75
 IlluminateFoundationBootstrapHandleExceptions->handleError() at /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/MySqlSchemaManager.php:75
 DoctrineDBALSchemaMySqlSchemaManager->_getPortableTableIndexesList() at /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/AbstractSchemaManager.php:193
 DoctrineDBALSchemaAbstractSchemaManager->listTableIndexes() at /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/AbstractSchemaManager.php:286
 DoctrineDBALSchemaAbstractSchemaManager->listTableDetails() at /var/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/Grammar.php:320
 IlluminateDatabaseSchemaGrammarsGrammar->getChangedDiff() at /var/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/Grammar.php:302
 IlluminateDatabaseSchemaGrammarsGrammar->compileChange() at /var/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php:107
 IlluminateDatabaseSchemaBlueprint->toSql() at /var/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php:82
 IlluminateDatabaseSchemaBlueprint->build() at /var/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:229
 IlluminateDatabaseSchemaBuilder->build() at /var/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:130
 IlluminateDatabaseSchemaBuilder->table() at /var/www/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:237
 IlluminateSupportFacadesFacade::__callStatic() at /var/www/database/migrations/2016_10_25_222438_update_relationships_for_employee.php:20
 IlluminateSupportFacadesSchema::table() at /var/www/database/migrations/2016_10_25_222438_update_relationships_for_employee.php:20
 UpdateRelationshipsForEmployee->up() at /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:373
 IlluminateDatabaseMigrationsMigrator->IlluminateDatabaseMigrations{closure}() at /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:380
 IlluminateDatabaseMigrationsMigrator->runMigration() at /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:162
 IlluminateDatabaseMigrationsMigrator->runUp() at /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:130
 IlluminateDatabaseMigrationsMigrator->runMigrationList() at /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:97
 IlluminateDatabaseMigrationsMigrator->run() at /var/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:66
 IlluminateDatabaseConsoleMigrationsMigrateCommand->fire() at n/a:n/a
 call_user_func_array() at /var/www/vendor/laravel/framework/src/Illuminate/Container/Container.php:508
 IlluminateContainerContainer->call() at /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php:169
 IlluminateConsoleCommand->execute() at /var/www/vendor/symfony/console/Command/Command.php:256
 SymfonyComponentConsoleCommandCommand->run() at /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php:155
 IlluminateConsoleCommand->run() at /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php:185
 IlluminateConsoleCommand->call() at /var/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/RefreshCommand.php:66
 IlluminateDatabaseConsoleMigrationsRefreshCommand->fire() at n/a:n/a
 call_user_func_array() at /var/www/vendor/laravel/framework/src/Illuminate/Container/Container.php:508
 IlluminateContainerContainer->call() at /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php:169
 IlluminateConsoleCommand->execute() at /var/www/vendor/symfony/console/Command/Command.php:256
 SymfonyComponentConsoleCommandCommand->run() at /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php:155
 IlluminateConsoleCommand->run() at /var/www/vendor/symfony/console/Application.php:820
 SymfonyComponentConsoleApplication->doRunCommand() at /var/www/vendor/symfony/console/Application.php:187
 SymfonyComponentConsoleApplication->doRun() at /var/www/vendor/symfony/console/Application.php:118
 SymfonyComponentConsoleApplication->run() at /var/www/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php:121
 IlluminateFoundationConsoleKernel->handle() at /var/www/artisan:36

我的迁移文件在下面

<?php
use IlluminateSupportFacadesSchema;
use IlluminateDatabaseSchemaBlueprint;
use IlluminateDatabaseMigrationsMigration;
class UpdateRelationshipsForEmployee extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        //
        Schema::table('employee',function ($table){
            $table->integer('retail_id')->unsigned()->index()->change();
        });
    }
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('employee', function ($table){
            $table->integer('retail_id')->change();
        });
        //
    }
}

Answer 1

只需删除整个数据库并运行该命令PHP artisan migrate:refresh——seed

你也可以维护你的数据库。只需复制您的模型和迁移信息。然后删除。删除后重新创建模型和表。

。转到数据库迁移表。删除员工行。现在。删除员工表。

现在只是终端命令php artisan migrate

Answer 2

检查您的操作系统区域设置或php区域设置，

无法在laravel使用的依赖库中正确转换大写，因为您的语言环境与en_us不同。use UTF8

试

setlocale (LC_CTYPE en_US.UTF8);

使用en_us。