onlyoffice-nextcloud icon indicating copy to clipboard operation
onlyoffice-nextcloud copied to clipboard

Onlyoffice App - Migration error when updating Nextcloud from 25 to 25.0.5

Open pixxelfactory opened this issue 2 years ago • 1 comments

Bug description

Just wanted to update my nextcloud installation from 24 to 24.0.5 It went smooth until i got to the step where it tried to update the onlyoffice app. I got the following message:

Update vorbereiten Log-Level auf "debug" gesetzt Wartungsmodus eingeschaltet Reparaturschritt: Repair MySQL collation Reparaturinformation: Not a mysql database -> 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 Datenbank aktualisiert

Exception: Database error when running migration 070400Date20220607111111 for app onlyoffice An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1 index share_id_index already exists

Tried it a couple of times, but it seems a bug in the migration procedure. Steps to reproduce

Get a nextcloud installation version 24(.0) with the onlyoffice app installed
Try to update to 24.0.5 via the web-based updater
Go to the step where it wants to update the onlyoffice app

Expected behavior

Just update the app and return to the administration Installation method

Community Web installer on a VPS or web space Operating system

RHEL/CentOS PHP engine version

PHP 7.4 Web server

Apache (supported) Database engine version

MariaDB Is this bug present after an update or on a fresh install?

No response Are you using the Nextcloud Server Encryption module?

Encryption is Disabled What user-backends are you using?

Default user-backend (database) LDAP/ Active Directory SSO - SAML Other

pixxelfactory avatar Sep 20 '22 08:09 pixxelfactory

Hello @pixxelfactory, we have fixed the issue and the solution will be introduced in the next connector version.

As of now, you can try to execute the following occ command to update the database to the latest indexes on Nextcloud:

occ db:add-missing-primary-keys

alexanderonlyoffice avatar Oct 04 '22 13:10 alexanderonlyoffice