Mysql MariaDB - Error 10071(42000) when updating NC

Hello,

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 :

[mysqld]
innodb_large_prefix=on
innodb_file_format=Barracuda

Restart MariaDB.

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