在Laravel 5.4上使用php artisan make:auth迁移错误
[Illuminate\Database\QueryException] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter tabl e users add unique users_email_unique(email)) [PDOException] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
当前回答
尝试使用默认字符串长度125 (MySQL 8.0)。
defaultStringLength (125)
其他回答
与其设置长度限制，我建议以下方法，这对我来说很有效。
内部:
配置/ database.php
将这一行替换为mysql:
'engine' => 'InnoDB ROW_FORMAT=DYNAMIC',
:
'engine' => null,
正如迁移指南中所概述的那样，你所要做的就是编辑app/Providers/AppServiceProvider.php文件，并在boot方法中设置默认字符串长度:
use Illuminate\Support\Facades\Schema;
public function boot()
{
Schema::defaultStringLength(191);
}
注意:首先你必须从数据库中删除(如果你有)users表，password_resets表，并从迁移表中删除users和password_resets条目。
要运行所有未完成的迁移，执行migrate Artisan命令:
php artisan migrate
在那之后，一切都应该正常工作。
如前所述，我们在App/Providers中添加到AppServiceProvider.php
use Illuminate\Support\Facades\Schema; // add this
/**
* Bootstrap any application services.
*
* @return void
*/
public function boot()
{
Schema::defaultStringLength(191); // also this line
}
你可以在下面的链接中看到更多细节(搜索“索引长度& MySQL / MariaDB”) https://laravel.com/docs/5.5/migrations
BUT WELL THAT's not what I published all about! the thing is even when doing the above you will likely to get another error (that's when you run php artisan migrate command and because of the problem of the length, the operation will likely stuck in the middle. solution is below, and the user table is likely created without the rest or not totally correctly) we need to roll back. the default roll back will not work. because the operation of migration didn't like finish. you need to delete the new created tables in the database manually.
我们可以这样做使用修补器如下所示:
L:\todos> php artisan tinker
Psy Shell v0.8.15 (PHP 7.1.10 — cli) by Justin Hileman
>>> Schema::drop('users')
=> null
我自己有一个问题与用户表。
之后你就可以开始了
PHP artisan migrate:回滚
PHP工匠迁移
对于不想更改AppServiceProvider.php的人。 (在我看来，仅仅为了迁移而更改AppServiceProvider.php是一个坏主意)
您可以将数据长度添加回database/migrations/下的迁移文件，如下所示:
create_users_table.php
$table->string('name',64);
$table->string('email',128)->unique();
create_password_resets_table.php
$table->string('email',128)->index();
腔:
添加到。env文件
DB_ENGINE=InnoDB
