Blesta 5.0.0 install issue

[kerryw92]

Hi,

I am getting the following error while trying to install Blesta 5.0.0:

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes 

I have tried changing the character set to just utf8 in the install.php file, blesta-new.php file and the database.php file however it still happens.

Bear in mind this is on a shared hosting platform so I am limited as to what I can alter config wise.

Thanks,

Kerry

[Michael]

Hi there this is due to the version of MySQL or MariaDB you have:

https://docs.blesta.com/display/user/Upgrading+Blesta#UpgradingBlesta-ErrorsDuringUpgrade

Quote

 

This error occurs when the collation is updated from utf8 to utf8mb4 when a varchar 255 field has more than 767 bytes. In MySQL 5.7.7 and MariaDB 10.2.2, this value was increased to 3072 bytes. We would recommend upgrading your database and re-attempting the upgrade. As an alternative, you can try running this query prior to re-attempting an upgrade:

SET @@global.innodb_large_prefix = 1;

 

You'll have to contact your web provider and also restore your database before you continue.