php - 航海者 php artisan 航海者 :install --with-dummy error

Question

[Illuminate\Database\QueryException] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes ( SQL: alter table translations add unique translations_table_name_column_name_foreign_key_locale_unique(table_
name, column_name, foreign_key, locale))

[Doctrine\DBAL\Driver\PDOException] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes

[PDOException] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes

AppServiceProvider.php 这种方式不起作用我无法修复此错误有什么方法可以修复它吗？

use Illuminate\Support\Facades\Schema;

public function boot() 
{
    Schema::`defaultStringLength`(191); 
}

Answer 1

当我尝试安装 voyager 时，就发生了这种情况。经过一番挖掘后，我发现这两个答案有效。

解决方案01

* /config/database.php *

'mysql' => [
    ...,
    ...,
    'engine' => 'InnoDB',
 ] 

解决方案02
编辑config文件夹中的database.php文件。(与上面答案中的相同文件)只需编辑，

'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci', 

到

'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',

我从Laravel Migration Error: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes找到这些问题答案。因此，所有功劳都应归功于@dexterb 和@Koushik Das