Help Installing Wave!

sanderkdna

Oct 19th, 2020 08:01 PM

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!

bobbyiliev

Oct 19th, 2020 09:12 PM

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!