Updating to 3.2.0 fails on SQLite installations

[PierreQ00]

⚠️ This issue respects the following points: ⚠️

• This is a bug, not a question or a configuration/webserver/proxy issue.
• This issue is not already reported on Github (I've searched it).
• Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
• Nextcloud Server is running on 64bit capable CPU, PHP and OS.
• I agree to follow Nextcloud's Code of Conduct.

Bug description

Good Morning,
I have this exception after the form update. This is the last version of Nextcloud.

Exception: Database error when running migration 030100Date20230202175747 for app forms An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1 error in table oc_forms_v2_forms after add column: incomplete input

Someone has an idea?

Thank's a lot.

Pierre.

Steps to reproduce

1.1 update the form extension
2.The sql error arrives
3.

Expected behavior

Exception: Database error when running migration 030100Date20230202175747 for app forms An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1 error in table oc_forms_v2_forms after add column: incomplete input

Installation method

Community Manual installation with Archive

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.1

Web server

Apache (supported)

Database engine version

None

Is this bug present after an update or on a fresh install?

None

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

Configuration report

ou may use your browser or the occ upgrade command to do the upgrade
{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "cloud.web-prod.be:1083",
            "192.168.1.4:1083",
            "192.168.1.4:1082",
            "cloud.web-prod.be:1082"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "sqlite3",
        "version": "25.0.4.1",
        "overwrite.cli.url": "https:\/\/cloud.web-prod.be:1083\/nextcloud",
        "installed": true,
        "app_install_overwrite": [
            "deckimportfromtrello"
        ],
        "maintenance": false,
        "theme": "",
        "loglevel": 2
    }

List of activated Apps

extcloud 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
Enabled:
  - activity: 2.17.0
  - bookmarks: 12.0.0
  - calendar: 4.2.4
  - circles: 25.0.0
  - cloud_federation_api: 1.8.0
  - comments: 1.15.0
  - contacts: 5.1.0
  - contactsinteraction: 1.6.0
  - dashboard: 7.5.0
  - dav: 1.24.0
  - deck: 1.8.3
  - event_update_notification: 2.0.0
  - federatedfilesharing: 1.15.0
  - federation: 1.15.0
  - files: 1.20.1
  - files_external: 1.17.0
  - files_pdfviewer: 2.6.0
  - files_rightclick: 1.4.0
  - files_sharing: 1.17.0
  - files_trashbin: 1.15.0
  - files_versions: 1.18.0
  - firstrunwizard: 2.14.0
  - forms: 3.1.0
  - gpxpod: 5.0.6
  - logreader: 2.10.0
  - lookup_server_connector: 1.13.0
  - nextcloud_announcements: 1.14.0
  - notes: 4.6.0
  - notifications: 2.13.1
  - oauth2: 1.13.0
  - password_policy: 1.15.0
  - photos: 2.0.1
  - privacy: 1.9.0
  - provisioning_api: 1.15.0
  - recommendations: 1.4.0
  - related_resources: 1.0.4
  - richdocuments: 7.1.1
  - richdocumentscode: 22.5.802
  - serverinfo: 1.15.0
  - settings: 1.7.0
  - sharebymail: 1.15.0
  - support: 1.8.0
  - survey_client: 1.13.0
  - systemtags: 1.15.0
  - tasks: 0.14.5
  - text: 3.6.0
  - theming: 2.0.1
  - twofactor_backupcodes: 1.14.0
  - updatenotification: 1.15.0
  - user_status: 1.5.0
  - viewer: 1.9.0
  - weather_status: 1.5.0
  - workflowengine: 2.7.0
Disabled:
  - admin_audit
  - bruteforcesettings
  - encryption
  - spreed: 15.0.4
  - suspicious_login
  - twofactor_totp
  - user_ldap

Nextcloud Signing status

No response

Nextcloud Logs

No response

Additional info

No response

[Chartman123]

@susnux @jotoeri What can we do here to solve the problem? This looks like the SQLite problem fixed in nextcloud/server#36803

[susnux]

Yes this exactly that problem, for NC25 the fix is still pending:
nextcloud/server#37003

Edit: Will be fixed in server with 25.0.5

[Chartman123]

As a workaround you could cd to your data directory, run sqlite3 owncloud.db and then execute the following statement: alter table oc_forms_v2_forms add column last_updated INTEGER;

This should add the missing column from the latest migration step. The migration should then see that the column is already there and just skip the step.

@PierreQ00 @foss- @dimpflmoser Could you please try this and report back if this fixes the problem?

[markus2330]

@Chartman123 thank you so much, this workaround fixed the problem for me! 🎆

It happened when upgrading nextcloud forms to 3.2.0.

[Chartman123]

Closed as the workaround resolves the issue and the underlying problem will be fixed with the next server release.