Specified key was too long;max key length is 1000 bytes

[ardakocaktr]

I got this error

mysql version : MariaDB 10.2.8
php version : 7.0.22

and Tried this code in AppServiceProvider . still didnt work :
Schema::defaultStringLength(191);

[lildigiman]

I am getting this error as well when trying to migrate the tracker DB:

[Illuminate\Database\QueryException]
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table tracker_agents add unique tracker_agents_name_unique(name)) (SQL: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table tracker_agents add unique tracker_agents_name_unique(name)))

[antonioribeiro]

We have some new migrations in place to help fixing this error, did you try them?

[oppenheimer]

I found the same issue but it was not fixed with the "Schema::defaultStringLength(191);" added to the AppServiceProvider.php.
I changed the DB storage from MyISAM to InnoDB and it worked.

[devWaleed]

I faced this issue as well. The best solution to solve this (imo) is to use InnoDB engine for tracker tables. By default all tables will use MyISAM.

        'tracker' => [
            'strict' => false, 
            'engine' => 'InnoDB', // this bit
        ]

[vishrantgupta]

Check this answer: https://stackoverflow.com/questions/8746207/1071-specified-key-was-too-long-max-key-length-is-1000-bytes/50689604#50689604

[i-emek]

I've got the same error, tryr the solution of devWaleed.

[alshoja]

Getting the same issue on the shared server, can I get a fix on this?

Traces
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table tracker_languagesadd uniquetracker_languages_preference_language_range_unique(preference, language-range)) (SQL: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table tracker_languagesadd uniquetracker_languages_preference_language_range_unique(preference, language-range)))

[alshoja]

I got the Error fixed by changing the tracker database

 'strict' => true,          
 'engine' => 'InnoDB',