Press enter to see results or esc to cancel.

Specified key was too long; Max Key Length is 1000 bytes

Fixing the error SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes is a very easy thing to do. That is, if you do not need to use the MyISAM storage engine.

If you do not know the difference between MySQL’s storage engine MyISAM and InnoDB you can read about the differences here.

To fix the error all you have to do is go into Laravels config/database.php and change the default value null into innodb.

laravel tips
// before
'connections' => [
       // ...

        'mysql' => [
           // ...
            'engine' => null, // change this to 'innodb'
        ],
]

// after
'connections' => [
       // ...

        'mysql' => [
           // ...
            'engine' => 'innodb', // and done
        ],
]