Db migration error on Mariadb Database


  • Used Zammad version: 3.4
  • Used Zammad installation source: (source, package, …) package
  • Operating system: Centos7
  • Database: mariadb 10.1.x
  • DB Charset: utf8_unicode_ci

Expected behavior:

  • rake db:migrate running successfully

Actual behavior:

  • throws error Specified key was too long; max key length is 767 bytes: CREATE INDEX `index_smime_certificates_on_modulus` ON `smime_certificates`

Steps to reproduce the behavior:

  • updating Zammad with MariaDB as Database

Did someone else had the same Problem?


I had to activate larg index keys.

SET GLOBAL innodb_default_row_format = dynamic;
SET GLOBAL innodb_large_prefix = 1;

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.