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

Support intro

Sorry to hear you’re facing problems :slightly_frowning_face:

help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.

In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:

example

Or for longer, use three backticks above and below the code snippet:

longer
example
here

Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can :heart:

Nextcloud version (eg, 20.0.5): i wanted to update the server software to 29.0.0 from 28
Operating system and version (eg, Ubuntu 20.04): replace me
Apache or nginx version (eg, Apache 2.4.25): Apache I believe (All Inkl Business Hosting)
PHP version (eg, 7.4): 8.1

The issue you are facing:

Is this the first time you’ve seen this error? (Y/N): Y

Steps to replicate it:

  1. run updaten
  2. get the error

The output of your Nextcloud log in Admin > Logging:

29.0.0

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

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

The output of your Apache/nginx/system log in /var/log/____:

i am no expert. dont know where to get this

Output errors in nextcloud.log in /var/www/ or as admin user in top right menu, filtering for errors. Use a pastebin service if necessary.

i am no expert. dont know where to get this

because i think that nobody can explain me clearly what is to do i loaded a backup and deinstalled the openoffice app and tried it again but still the same error comes.

Now I loaded again the backup and hope that someone can explain me, who doesnt know how to start a console etc, how to solve this problem.

It is the same here [Bug]: Error when updating to Nextcloud Version 29: InvalidArgumentException: Index name "share_id_index" for table "oc_onlyoffice_permissions" collides with the constraint on table "oc_federated_reshares". · Issue #45271 · nextcloud/server · GitHub