Upgrade error: here is no table with name “nextcloud.oc_openregister_objects” in the schema

[rcfa]

The latest update forces an upgrade which results in this error message in the web interface:

Update to 30.0.1

Exception: Database error when running migration 1Date20241019205009 for app openregister There is no table with name “nextcloud.oc_openregister_objects” in the schema.

Detailed logs

Preparing update
Set log level to debug
Turned on maintenance mode
Repair step: Repair MySQL collation
Repair info: All tables already have the correct collation → nothing to do
Repair step: Copy data from accounts table when migrating from ownCloud
Repair step: Drop account terms table when migrating from ownCloud
Updating database schema
Updated database

Exception: Database error when running migration 1Date20241019205009 for app openregister There is no table with name “nextcloud.oc_openregister_objects” in the schema.

The update was unsuccessful. Please report this issue to the [Nextcloud community](https://github.com/nextcloud/server/issues).

if I use occ, then I get this, which is essentially the same:

# 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
Updating <openregister> ...
Exception: Database error when running migration 1Date20241019205009 for app openregister
There is no table with name "nextcloud.oc_openregister_objects" in the schema.
Update failed
Maintenance mode is kept active
Resetting log level

[rjzondervan]

Hi @rcfa,

Thank you for filing this issue. We are looking into it.

I have one question on this subject: This app has not reached a stable status yet, and therefore migrations can change. Does this error persist if you remove the app and reinstall it?

[rcfa]

I tried to remove it both from the web UI and with the occ command, and reinstall it, with similar/same results:

# occ app:remove openregister
openregister is not installed

# occ app:install openregister
Error: Database error when running migration 1Date20241019205009 for app openregister
There is no table with name "nextcloud.oc_openregister_objects" in the schema.

So while I can remove the app, I can’t remove whatever leads to the error upon upgrade/install