Help Installing Wave!
Hi, guys, i'm having some issues installing wave, while i'm making de migrations, i'm having the next error message
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))
I try the fix this with google and i found this code use
Illuminate\Support\Facades\Schema; public function boot() { Schema::defaultStringLength(191); }
in the app/Providers/AppServiceProvider.php file, but it didn't work, I also upgrade my mysql version, because I had 5.7 mysql now i'm 8, but still i'm having the issue. Hope you guys can help me! thanks for your help!
Hi there,
What I could suggest trying is to set your default database engine to InnoDB, to do that edit the config/database.php file and under the mysql section change the engine from null to InnoDB:
'mysql' => [
...,
'engine' => 'InnoDB',
]
Then clear your cache:
php artisan config:cache
And after that try again.
Let me know how it goes!