Upgrade error: database constraint collision

[spontex]

Hi,

I get the following error when trying to update from Nextcloud 28.0.14 to Nextcloud 29.0.10 (on the path to 30):

~/web/nextcloud$ php-8.3 occ upgrade
Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
Setting log level to debug
Updating database schema
Updated database
InvalidArgumentException: Index name "share_id_index" for table "b8sx_onlyoffice_permissions" collides with the constraint on table "b8sx_federated_reshares".
Update failed
Maintenance mode is kept active
Resetting log level

How can I solve this database problem? Thanks

[spontex]

@spontex

Index name "share_id_index" for table "b8sx_onlyoffice_permissions" collides with the constraint on table "b8sx_federated_reshares"

Solved using this comment:

InvalidArgumentException: Index name "share_id_index" for table "NQo3N_onlyoffice_permissions" collides with the constraint on table "NQo3N_federated_reshares"

I have exactly the same problem, I posted a separate report as requested by Nextcloud as it went through the update process, and like most of you here, I have had no one come back and explain what seems to be the problem. I did find this on Git though: Hi @AndreasB92 , I had the exact same issue. I resolved it by running the following query against my database (MariaDB): DROP INDEX share_id_index ON oc_onlyoffice_permissions; This query, drops the index for table oc_onlyoffice_permissions. …

so by running this SQL request:

DROP INDEX share_id_index ON oc_onlyoffice_permissions;