Error upgrading to 15.0.7

[micaldas1]

Nextcloud version (eg, 15.0.6):
Operating system and version (Debian 10):
Apache version (Apache 2.4.25):
PHP version (eg, 7.0.33):

The issue you are facing:

I downloaded the version through nextcloud’s application and, after downloading and getting back to my install, I clicked on the upgrade button.
I got the following 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

Detailed logs

Preparing update

Set log level to debug

Turned on maintenance mode

Repair step: Repair MySQL collation

Repair info: Change row format for oc_addressbooks …

Repair info: Change collation for oc_addressbooks …

Repair info: Change row format for oc_authtoken …

Repair info: Change collation for oc_authtoken …

Repair info: Change row format for oc_bookmarks_tags …

Repair info: Change collation for oc_bookmarks_tags …

Repair info: Change row format for oc_calendarobjects …

Repair info: Change collation for oc_calendarobjects …

Repair info: Change row format for oc_calendars …

Repair info: Change collation for oc_calendars …

Repair info: Change row format for oc_calendarsubscriptions …

Repair info: Change collation for oc_calendarsubscriptions …

Repair info: Change row format for oc_dav_shares …

Repair info: Change collation for oc_dav_shares …

Repair info: Change row format for oc_migrations …

Repair info: Change collation for oc_migrations …

Repair info: Change row format for oc_mimetypes …

Repair info: Change collation for oc_mimetypes …

Repair info: Change row format for oc_systemtag_group …

Repair info: Change collation for oc_systemtag_group …

Repair info: Change row format for oc_trusted_servers …

Repair info: Change collation for oc_trusted_servers …

Repair step: Repair SQLite autoincrement

Repair step: Copy data from accounts table when migrating from ownCloud

Repair step: Drop account terms table when migrating from ownCloud

Updating database schema

Updated database

Checking for update of app “apporder” in appstore

Checked for update of app “apporder” in appstore

Checking for update of app “bookmarks” in appstore

Checked for update of app “bookmarks” in appstore

Checking for update of app “calendar” in appstore

Checked for update of app “calendar” in appstore

Checking for update of app “cloud_federation_api” in appstore

Checked for update of app “cloud_federation_api” in appstore

Checking for update of app “contacts” in appstore

Checked for update of app “contacts” in appstore

Checking for update of app “dav” in appstore

Checked for update of app “dav” in appstore

Checking for update of app “drawio” in appstore

Checked for update of app “drawio” in appstore

Checking for update of app “end_to_end_encryption” in appstore

Checked for update of app “end_to_end_encryption” in appstore

Checking for update of app “federatedfilesharing” in appstore

Checked for update of app “federatedfilesharing” in appstore

Checking for update of app “files” in appstore

Checked for update of app “files” in appstore

Checking for update of app “files_mindmap” in appstore

Checked for update of app “files_mindmap” in appstore

Checking for update of app “files_pdfviewer” in appstore

Checked for update of app “files_pdfviewer” in appstore

Checking for update of app “files_rightclick” in appstore

Checked for update of app “files_rightclick” in appstore

Checking for update of app “files_sharing” in appstore

Checked for update of app “files_sharing” in appstore

Checking for update of app “files_texteditor” in appstore

Checked for update of app “files_texteditor” in appstore

Checking for update of app “files_trashbin” in appstore

Checked for update of app “files_trashbin” in appstore

Checking for update of app “files_versions” in appstore

Checked for update of app “files_versions” in appstore

Checking for update of app “files_videoplayer” in appstore

Checked for update of app “files_videoplayer” in appstore

Checking for update of app “gallery” in appstore

Checked for update of app “gallery” in appstore

Checking for update of app “logreader” in appstore

Checked for update of app “logreader” in appstore

Checking for update of app “lookup_server_connector” in appstore

Checked for update of app “lookup_server_connector” in appstore

Checking for update of app “mail” in appstore

Checked for update of app “mail” in appstore

Checking for update of app “metadata” in appstore

Checked for update of app “metadata” in appstore

Checking for update of app “news” in appstore

Checked for update of app “news” in appstore

Checking for update of app “notes” in appstore

Checked for update of app “notes” in appstore

Checking for update of app “notifications” in appstore

Checked for update of app “notifications” in appstore

Checking for update of app “oauth2” in appstore

Checked for update of app “oauth2” in appstore

Checking for update of app “phonetrack” in appstore

Checked for update of app “phonetrack” in appstore

Checking for update of app “provisioning_api” in appstore

Checked for update of app “provisioning_api” in appstore

Checking for update of app “sharebymail” in appstore

Checked for update of app “sharebymail” in appstore

Checking for update of app “support” in appstore

Checked for update of app “support” in appstore

Checking for update of app “tasks” in appstore

Checked for update of app “tasks” in appstore

Checking for update of app “theming” in appstore

Checked for update of app “theming” in appstore

Checking for update of app “theming_customcss” in appstore

Checked for update of app “theming_customcss” in appstore

Checking for update of app “twofactor_backupcodes” in appstore

Checked for update of app “twofactor_backupcodes” in appstore

Checking for update of app “updatenotification” in appstore

Checked for update of app “updatenotification” in appstore

Checking for update of app “workflowengine” in appstore

Checked for update of app “workflowengine” in appstore

Repair step: Repair MySQL collation

Repair info: Change row format for oc_addressbooks …

Repair info: Change collation for oc_addressbooks …

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

I tried upgrading again but it goes directly to the same error.
Now I can’t access the server in the browser.
I have idea how to proceed as I’m very new to nextcloud.
Any help would be greatly appreciated.

[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