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 : Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
What can I do?
Thank you all!
you have to prepare your mariadb server to be able to create indexes greater than 767 bytes (keyword:
This is also part of the manual to enable 4 byte support for your nextcloud database.
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!
This is the right place to ask questions.