Update unsuccessful when upgrading from 20.0.2 => 20.0.6.1

axxies · February 2, 2021, 8:47pm

This is not the UTF8MB4 issue. The DB is just UTF-8.

================

Nextcloud version : Updating from 20.0.2 => 20.0.6.1
Operating system and version : Debian 9.13
Apache or nginx version : Apache/2.4.25 (Debian)
PHP version : 7.4.14

The issue you are facing:

Is this the first time you’ve seen this error? No, retried the update


    The output of your config.php file in `/path/to/nextcloud`:

<?php $CONFIG = array ( 'instanceid' => '', 'passwordsalt' => 'FFFFFFFFFFFFFF', 'secret' => 'secret', 'trusted_domains' => array ( 0 => '', ), 'datadirectory' => '/var/www/clients/client1//web/data', 'dbtype' => 'mysql', 'version' => '20.0.6.1', 'overwrite.cli.url' => 'https://', 'dbname' => '', 'dbhost' => 'localhost', 'dbport' => '', 'dbtableprefix' => 'oc_', 'dbuser' => '', 'dbpassword' => '', 'installed' => true, 'maintenance' => false, 'mail_from_address' => 'no.reply', 'mail_smtpmode' => 'smtp', 'mail_sendmailmode' => 'smtp', 'mail_domain' => '', 'mail_smtphost' => '', 'mail_smtpport' => '25', 'mail_smtpauthtype' => 'LOGIN', 'mail_smtpauth' => 1, 'mail_smtpname' => 'no.reply@', 'mail_smtppassword' => '', 'theme' => '', 'loglevel' => 2, 'app_install_overwrite' => array ( 0 => 'ojsxc', 1 => 'flowupload', ``` The output of your Apache/nginx/system log in `/var/log/____`: ``` PASTE HERE ``` Nextcloud update log: ## Update to 20.0.6 Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'CREATE UNIQUE INDEX UNIQ_options ON oc_polls_options (poll_id, poll_option_text, timestamp)': 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: All tables already have the correct collation -> nothing to do 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 Repair step: Fix component of birthday calendars Repair info: 9 birthday calendars updated. Repair step: Regenerating birthday calendars to use new icons and fix old birthday events without year Repair info: Repair step already executed Repair step: Fix broken values of calendar objects [0 / 0]: Fix broken values of calendar objects Repair step: Registering building of calendar search index as background job Repair info: Repair step already executed Repair step: Registering background jobs to update cache for webcal calendars Repair info: Added 0 background jobs to update webcal calendars Repair step: Registering building of calendar reminder index as background job Repair info: Repair step already executed Repair step: Clean up orphan event and contact data Repair info: 0 events without a calendar have been cleaned up Repair info: 0 properties without an events have been cleaned up Repair info: 0 changes without a calendar have been cleaned up Repair info: 0 cached events without a calendar subscription have been cleaned up Repair info: 0 changes without a calendar subscription have been cleaned up Repair info: 0 contacts without an addressbook have been cleaned up Repair info: 0 properties without a contact have been cleaned up Repair info: 0 changes without an addressbook have been cleaned up Repair step: Remove activity entries of private events Repair info: Removed 0 activity entries Updated "dav" to 1.16.2 Updated "files_accesscontrol" to 1.10.2 Repair step: Fix the share type of guest shares when migrating from ownCloud Repair step: Copy the share password into the dedicated column Repair step: Set existing shares as accepted Updated "files_sharing" to 1.12.2 Updated "richdocuments" to 3.7.14 Updated "workflow_pdf_converter" to 1.5.1 Updated "workflow_script" to 1.5.1 Repair step: Add read permissions for existing announcements [0 / 0]: Add read permissions for existing announcements Updated "announcementcenter" to 4.0.1 Updated "event_update_notification" to 1.2.0 Repair step: Update hook for Appointments app Repair info: running appointments UpdateHook for 11 users Repair info: appointments UpdateHook finished Updated "appointments" to 1.8.1 Repair step: Deduplicate shared bookmark folders Repair info: Removed 0 duplicate shares Repair step: Remove superfluous shared bookmark folders Repair info: Removed 0 superfluous shares Repair step: Remove orphaned bookmark shares Repair info: Removed 0 orphaned shares Repair info: Removed 0 orphaned public links Repair step: Remove orphaned bookmark tree items Repair info: Removed 0 orphaned bookmarks entries Repair info: Removed 0 orphaned folders entries Repair info: Removed 0 orphaned children entries Repair info: Removed 0 orphaned bookmark folders Repair info: Removed 0 orphaned bookmarks Repair step: Update bookmark group shares Repair info: Removed 0 users and added 0 users to 0 groups Repair info: Removed 0 shares Updated "bookmarks" to 4.0.8 Updated "breezedark" to 20.0.3 Repair step: Update name of the stored view Updated "calendar" to 2.1.3 Updated "contacts" to 3.4.3 Updated "cospend" to 1.2.9 Repair step: Delete orphaned ACL rules Updated "deck" to 1.2.3 Repair step: Copy default images to the app data directory Repair info: Icon external.svg already exists Repair info: Icon external-dark.svg already exists Repair info: Icon settings.svg already exists Updated "external" to 3.7.2 Updated "extract" to 1.3.0 Updated "federatedfilesharing" to 1.10.2 Updated "files_photospheres" to 1.20.1 Updated "forms" to 2.1.0 Updated "nextbackup" to 21.1.0 Repair step: Repair Passwords Database Objects Repair info: Checking 0 tag revisions [0 / 0]: Repair Passwords Database Objects Repair info: Fixed 0 tag revisions Repair info: Checking 0 folder revisions [0 / 0]: Repair Passwords Database Objects Repair info: Fixed 0 folder revisions Repair info: Checking 0 password revisions [0 / 0]: Repair Passwords Database Objects Repair info: Fixed 0 password revisions Repair info: Checking 0 tag models [0 / 0]: Repair Passwords Database Objects Repair info: Fixed 0 tag models Repair info: Checking 0 folder models [0 / 0]: Repair Passwords Database Objects Repair info: Fixed 0 folder models Repair info: Checking 0 password models [0 / 0]: Repair Passwords Database Objects Repair info: Fixed 0 password models Repair info: Checking 0 password tag relations [0 / 0]: Repair Passwords Database Objects Repair info: Fixed 0 password tag relations Updated "passwords" to 2020.12.2 Updated "photos" to 1.2.3 Repair step: Delete duplicates Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'CREATE UNIQUE INDEX UNIQ_options ON oc_polls_options (poll_id, poll_option_text, timestamp)': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes The update was unsuccessful. Please report this issue to the Nextcloud community ======== END ===========================

axxies · February 2, 2021, 8:49pm

Gosh! Is there no way to format the text? I thought it was.