SQLSTATE42000 Syntax error or access violation 1071 Specified key was too long; max key length is 10
I am adding two sollution that work for me.
- Open database.php file insde config dir/folder.
- Edit
'engine' => null,to'engine' => 'InnoDB',
This worked for me.
2nd sollution is:
- Open database.php file insde config dir/folder.
2.Edit
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
to
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
Goodluck
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.