Upgrading Nextcloud from 28.0.1 to 29.0.7 returns sql error - Column not found: 1054 Unknown column 'lazy' in 'field list'

What type of hardware are you using: Other(?)
What YunoHost version are you running: 12.0.6
What app is this about: Nextcloud

Describe your issue

Hello,

I am trying to upgrade my installed Nextcloud app, currently version 28.0.1~ynh1 up to 29.0.7~ynh2.
Using the frontend I am running into an SQL related error (see below) about a missing “lazy” table column.
Failing upgrade successfully rolls back to 28.0.1.
Same result with manual upgrade with command-line.

I suspect I should first upgrade to latest 28.x.y before upgrading to 29.0.7 so that column is created as it should. However I could not find a 28.x branch on Github : master already contains 29.x version and I am not certain it is possible to upgrade to a specific commit (is it?).

Another possible solution would be creating the missing column manually as indicated on some Nextcloud forums message here : Unknown column 'lazy' in 'field list' when upgrading from 28.0.1.1 to 29.0.3.4 - ℹ️ Support - Nextcloud community but I prefer asking first.

Thank you for your help!

Share relevant logs or error messages

https://paste.yunohost.org/raw/uhonanovisd

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.