Skip to content

Upgrade process stops with an error #25598

Description

@bjadel

Intended to upgrade with Web-Updater from
Nextcloud 19.0.8 -> Nextcloud 20.0.7
But stops with an error.

Update vorbereiten
Log-Level auf "debug" gesetzt
Wartungsmodus eingeschaltet
Reparaturschritt: Repair MySQL collation
Reparaturinformation: All tables already have the correct collation -> nothing to do
Reparaturschritt: Repair SQLite autoincrement
Reparaturschritt: Copy data from accounts table when migrating from ownCloud
Reparaturschritt: Drop account terms table when migrating from ownCloud
Das Datenbankschema wird aktualisiert
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'ALTER TABLE oc_authtoken CHANGE password_invalid password_invalid TINYINT(1) DEFAULT '0'': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

What happend before the Upgrade?

  • Made Upgrades from 19.0.0 up to 19.08 without problems
  • used 1 occ commands as told from nextcloud for mysql database optimization (bigint and so on)
sudo -u www-data php /var/www/nextcloud/occ db:convert-filecache-bigint

Operating system:
Raspberry Pi 3

Web server:
Apache

Database:
MySQL

PHP version:
PHP 7.3.25-1+020201130.73+debian91.gbp042074

What can I do now? Thanks in advance.

Activity

  1. added
    0. Needs triagePending check for reproducibility or if it fits our roadmap
    on Feb 12, 2021
  2. kesselb commented on Feb 12, 2021

    @kesselb
    Contributor

    Thank you for reporting this issue 👍 Please check #15058 for more details.

    Usually there are two ways to fix this:

    A) Configure your database server to support utf8mb4 (https://docs.nextcloud.com/server/latest/admin_manual/configuration_database/mysql_4byte_support.html).

    B) If the database server does not support utf8mb4 disable it by setting 'mysql.utf8mb4' => false in your config.php (emojis in filename, calendar events, etc. are not possible than and you have to accept the warning).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    0. Needs triagePending check for reproducibility or if it fits our roadmapbug

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions