Jump to content

Blesta 5.0.0 install issue


Recommended Posts

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

Link to post
Share on other sites

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.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...