Problem with update version 19.0.2, mariadb

Good evening everyone,
excuse me, but I’m not very good and I really need your competent help! I have an update problem. I tried to upgrade my server with Ubuntu 18.04 server, Apache, mariadb, PHP 7.4, but it gives me this error message:
Doctrine \ DBAL \ Exception \ DriverException: An exception occurred while executing ‘ALTER TABLE oc_addressbooks CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;’: SQLSTATE [42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

What can I do?
Thank you all!

Renzo

1 Like

Hello,
you have to prepare your mariadb server to be able to create indexes greater than 767 bytes (keyword: innodb_large_prefix).
This is also part of the manual to enable 4 byte support for your nextcloud database.
See: https://docs.nextcloud.com/server/19/admin_manual/configuration_database/mysql_4byte_support.html#mariadb-support

1 Like

Thank you very much for your reply!
I don’t know where I was wrong, but by translating the page and going over point by point, I did it!
Thanks again and sorry if I’m so inexperienced! :blush:

No problem.
This is the right place to ask questions. :slightly_smiling_face:

1 Like