Error 4.6.2 -> 4.7 1071 Specified key was too long; max key length is 767 bytes

Lukas · February 2, 2022, 10:45am

Hallo,

Das klingt nach demselben Bug wie

github.com/matomo-org/matomo

4.7.0-b2 Update fails with MySQL 5.5

opened 07:11AM - 02 Feb 22 UTC

closed 09:14AM - 03 Feb 22 UTC

Geddo

Bug not-in-changelog Regression

## Expected Behavior Updating to 4.7.0-b2 via Webupdater shouldnt be a thing … ## Current Behavior Fatal error: `matomo/core/Updates/4.7.0-b2.php: Error trying to execute the migration 'ALTER TABLE `matomo_changes` ADD UNIQUE KEY unique_plugin_version_title (`plugin_name`, `version`, `title`);'. The error was: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes` ## Possible Solution I guess it works with MySQL 5.7, but as 5.5 is still supported in general, it should work

Ich werde mich hier melden, wenn mehr dazu bekannt ist.