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

in laravel •  7 years ago 

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',




Goodluck

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

Congratulations! This post has been upvoted from the communal account, @minnowsupport, by ahmad from the Minnow Support Project. It's a witness project run by aggroed, ausbitbank, teamsteem, theprophet0, someguy123, neoxian, followbtcnews, and netuoso. The goal is to help Steemit grow by supporting Minnows. Please find us at the Peace, Abundance, and Liberty Network (PALnet) Discord Channel. It's a completely public and open space to all members of the Steemit community who voluntarily choose to be there.

If you would like to delegate to the Minnow Support Project you can do so by clicking on the following links: 50SP, 100SP, 250SP, 500SP, 1000SP, 5000SP.
Be sure to leave at least 50SP undelegated on your account.