Error upgrading to 15.0.7

[j-ed]

@micaldas1

ALTER TABLE oc_addressbooks CONVERT TO CHARACTER SET utf8mb4 …

Searching the forum and Github pointed me to the following postings which should help you getting the problem fixed:

"CONVERT TO CHARACTER SET utf8mb4"

[SOLVED] 'Specified key was too long' when enabling MySQL 4-byte support in Nextcloud 14

After a notification showed up in my Nextcloud (14) pointing me to enabling MySQL 4-byte support. I did a Snapshot of my System and followed the instructions including the additional steps for MariaDB (v 10.3 or later). Everything worked fine until the php occ maintenance:repair step. Before finishing, it threw the following errors: In AbstractMySQLDriver.php line 115: An exception occurred while executing '…

[SOLVED] Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

ERROR MESSAGE: An exception occurred while executing ‘ALTER TABLE [TABLE_NAME] 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 SOLUTION: $ sudo mysql -u root -p MariaDB [(none)]> use nextcloud; MariaDB [nextcloud]> set global innodb_large_prefix=on; MariaDB [nextcloud]> set global innodb_file_format=Barracuda; $ sudo -u www-data php occ maintenance:repair