Unable to complete installation

asked Sep 13, 2016 by Dale Barnes (120 points)
Is anyone able to please help me when i try to install SeoToaster i get this message is anyone able to help me please.

 The following errors were found :

Could not make the query numbered : 42
MySQL Error No : 1071
MySQL Error : Specified key was too long; max key length is 1000 bytes

1 Answer

answered Sep 13, 2016 by seotoaster (14,180 points)
Hello Dane.

Thank you  for a question.

There is a problem with your MySQL settings.
If you are using MyISAM database engine this can be a known bug with MySQL related to MyISAM, the UTF8 character set and indexes that you can check here.
https://confluence.atlassian.com/display/FISHKB/MySQL+Database+Migration+fails+with+Specified+key+was+too+long+max+key+length+is+1000+bytes

If you are using INNODB engine, then try to enable "innodb_large_prefix"
Please launch this command from your mysql console.
mysql> set global innodb_large_prefix = ON;

If it doesn't help, feel free to contact us.
...