Mysql MariaDB - Error 10071(42000) when updating NC


In case you are stuck with this error when updating your NC server:

Specified key was too long; max key length is 767 bytes » Error 10071(42000)

You can solve it by editing the file: ( or equivalent, depending of your distro )

etc/mysql/mariadb.conf.d/50-mysqld_large.cnf :


Restart MariaDB.

Restart the NC update:
sudo -u www-data php occ upgrade