SQLSTATE42000 Syntax error or access violation 1071 Specified key was too long; max key length is 10

@ahmadkhan · 2018-06-28 13:41 · laravel

I am adding two sollution that work for me.

1st sollution is:

  1. Open database.php file insde config dir/folder.
  2. Edit 'engine' => null, to 'engine' => 'InnoDB',

This worked for me.

2nd sollution is:

  1. Open database.php file insde config dir/folder.
    2.Edit
    'charset' => 'utf8mb4',
    'collation' => 'utf8mb4_unicode_ci',
    to

'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',


https://youtu.be/dsUlfKXdljU Goodluck

#laravel #error
Payout: 0.000 HBD
Votes: 4
More interactions (upvote, reblog, reply) coming soon.