kerryw92 Posted January 14, 2021 Report Posted January 14, 2021 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 Quote
Michael Posted January 14, 2021 Report Posted January 14, 2021 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. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.