1071 Specified key was too long

[RocoClothing]

Hi I am using Laravel 5.6 and I am getting the following error;

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table model_has_permissions add index model_has_permissions_model_type_model_id_index(model_type, model_id))

I have added the following to my AppServiceProvider.php

use Illuminate\Support\Facades\Schema;

  public function boot()
    {
        Schema::defaultStringLength(200);
    }

However I still get the error.

Here is the code used to create the table;

Schema::create($tableNames['model_has_permissions'], function (Blueprint $table) use 
  ($tableNames) {
            $table->integer('permission_id')->unsigned();
            $table->morphs('model');

            $table->foreign('permission_id')
                ->references('id')
                ->on($tableNames['permissions'])
                ->onDelete('cascade');

            $table->primary(['permission_id', 'model_id', 'model_type']);
        });

I'm assuming the problem is in regards to the model_type column being created with the primary key, however I have no idea how to fix it?

[drbyte]

Why are you using 200 instead of 191?

https://laravel-news.com/laravel-5-4-key-too-long-error

EDIT: FYI ... v4 of this package, which adds some unique indexes in the migration, requires 125 instead of 191 if you're using MySQL 8.0. (MariaDB doesn't require any of this).

[RocoClothing]

Thank you, I hadn't realised that I had set it to 200. That seems to be the problem.

[msyadav88]

running "php artisan migrate" , which try to add unique to permissions table gives error of #1071 - Specified key was too long; max key length is 1000 bytes , even if I have set Schema::defaultStringLength(191); in appserviceprovider

[msyadav88]

Make sure that your storage engine is INNODB.
If yes, then you don't need to set Schema::defaultStringLength(200);

[SteveOwago]

200
Set the value to 125. This worked for me.
Schema::defaultStringLength(125);