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!