onlyoffice-nextcloud
onlyoffice-nextcloud copied to clipboard
Onlyoffice App - Migration error when updating Nextcloud from 25 to 25.0.5
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
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