There is no table with name 'nextcloud.oc_text_steps' in the schema

[Routhinator]

Describe the bug After Upgrading from 19.0.9 to 20.0.8 the Text app is completely broken. I was only able to get my instance to start again by disabling it.

Error:

There is no table with name 'nextcloud.oc_text_steps' in the schema. 

To Reproduce Steps to reproduce the behavior:

1. Make sure you have a 19.0.6 Nextcloud installation
2. Patch to latest 19.0.9
3. Update to 20.0.8
4. Missing table error will break upgrade at the app upgrade stage.

Expected behavior Updating Text App does not break Nextcloud.

Screenshots If applicable, add screenshots to help explain your problem.

Client details:

• OS: Nextcloud Helm deployment on Kubernetes
• Browser: Firefox, but not applicable for this issue.

Text app version: 3.1.0

Operating system: Nextcloud Docker 20.0.8-apache

Web server: Apache

Database: Postrgesql

PHP version: Nextcloud Docker 20.0.8-apache

Nextcloud version: Nextcloud Docker 20.0.8-apache

Nextcloud log (data/nextcloud.log)

Initializing nextcloud 20.0.8.1 ...
Upgrading nextcloud from 19.0.9.1 ...
Initializing finished
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
Turned on maintenance mode
Updating database schema
Updated database
Disabled incompatible app: audioplayer
Disabled incompatible app: breezedark
Disabled incompatible app: calendar
Disabled incompatible app: event_update_notification
Disabled incompatible app: files_photospheres
Disabled incompatible app: files_retention
Disabled incompatible app: groupfolders
Disabled incompatible app: impersonate
Disabled incompatible app: phonetrack
Disabled incompatible app: ransomware_protection
Disabled incompatible app: spreed
Updating <federation> ...
Updated <federation> to 1.10.1
Updating <lookup_server_connector> ...
Updated <lookup_server_connector> to 1.8.0
Updating <oauth2> ...
Updated <oauth2> to 1.8.0
Updating <password_policy> ...
Updated <password_policy> to 1.10.1
Updating <files> ...
Updated <files> to 1.15.0
Updating <activity> ...
Updated <activity> to 2.13.4
Updating <cloud_federation_api> ...
Updated <cloud_federation_api> to 1.3.0
Updating <dav> ...
Fix broken values of calendar objects

 Starting ...

Updated <dav> to 1.16.2
Updating <files_external> ...
Updated <files_external> to 1.11.1
Updating <files_sharing> ...
Updated <files_sharing> to 1.12.2
Updating <files_trashbin> ...
Updated <files_trashbin> to 1.10.1
Updating <files_versions> ...
Updated <files_versions> to 1.13.0
Updating <sharebymail> ...
Updated <sharebymail> to 1.10.0
Updating <workflowengine> ...
Updated <workflowengine> to 2.2.0
Updating <comments> ...
Updated <comments> to 1.10.0
Updating <firstrunwizard> ...
Updated <firstrunwizard> to 2.9.0
Updating <nextcloud_announcements> ...
Updated <nextcloud_announcements> to 1.9.0
Updating <notifications> ...
Updated <notifications> to 2.8.0
Updating <systemtags> ...
Updated <systemtags> to 1.10.0
Updating <theming> ...
Updated <theming> to 1.11.0
Updating <accessibility> ...
Migrate old user config

    0/0 [>---------------------------]   0% Starting ...
    0/0 [->--------------------------]   0%
 Starting ...
    3/0 [--->------------------------]   0%
 Starting ...
    7/0 [----->----------------------]   0%
 Starting ...
   12/0 [------->--------------------]   0%
 Starting ...

Updated <accessibility> to 1.6.0
Updating <contactsinteraction> ...
Updated <contactsinteraction> to 1.1.0
Updating <federatedfilesharing> ...
Updated <federatedfilesharing> to 1.10.2
Updating <files_pdfviewer> ...
Updated <files_pdfviewer> to 2.0.1
Updating <files_rightclick> ...
Updated <files_rightclick> to 0.17.0
Updating <files_videoplayer> ...
Updated <files_videoplayer> to 1.9.0
Updating <logreader> ...
Updated <logreader> to 2.5.0
Updating <photos> ...
Updated <photos> to 1.2.3
Updating <privacy> ...
Updated <privacy> to 1.4.0
Updating <provisioning_api> ...
Updated <provisioning_api> to 1.10.0
Updating <recommendations> ...
Updated <recommendations> to 0.8.0
Updating <serverinfo> ...
Updated <serverinfo> to 1.10.0
Updating <settings> ...
Updated <settings> to 1.2.0
Updating <support> ...
Updated <support> to 1.3.0
Updating <survey_client> ...
Updated <survey_client> to 1.8.0
Updating <text> ...
Doctrine\DBAL\Schema\SchemaException: There is no table with name 'nextcloud.oc_text_steps' in the schema.
Update failed
Maintenance mode is kept active
Resetting log level

[Routhinator]

Are there any workarounds for this?

[marcelklehr]

This is a weird one. I'm sorry for the delay in addressing your issue. Most likely the text app wasn't installed properly initially as it should have the text_steps table from the very first version on. I'm closing this for now as the versions you mention have been End of Life for a while now. Let me know if this is still an issue in newer versions! :hearts: