Update Nextcloud 28.0.1(installed by Softaculous) to 29.0.7 (Manually) Fails

[EternalRookie]

Support intro

Sorry to hear you’re facing problems

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

Nextcloud version (eg, 29.0.7): 29.0.7
Operating system and version (eg, Ubuntu 24.04): CloudLinux(?) 3.10.0-962.3.2.lve1.5.80.el7.x86_64
Apache or nginx version (eg, Apache 2.4.25): 2.4.62
PHP version (eg, 8.3): 8.1

The issue you are facing:

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

Steps to replicate it:
As I couldn’t update from 28.0.x to 30.x (the only option that Softaculous allowed), I attempted to update manually, so:

1. Uploaded and unzipped the 29.0.7 files to public_html
2. Renamed existing installation as “_old”
3. Changed file permissions on new install as shown in manual update instructions and renamed new install to the original name.
4. Copied config.php from old to new
5. Ran “php occ upgrade”

Got the following output:

php 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
Turned on maintenance mode

In DbalException.php line 71:

  An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lazy' in 'field list'


In ExceptionConverter.php line 67:

  An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lazy' in 'field list'


In Exception.php line 28:

  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lazy' in 'field list'


In Statement.php line 130:

  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lazy' in 'field list'


upgrade

The output of your Nextcloud log in Admin > Logging:

Not available - when trying to get to the app by browser, a non-themed page comes up showing all of the updates that will be done, and at the bottom, the following lines: 
Please make sure that the database, the config folder and the data folder have been backed up before proceeding.
"Start update"
To avoid timeouts with larger installations, you can instead run the following command from your installation directory:
./occ upgrade
Detailed logs
Nextcloud – a safe home for all your data

Note - the "Start update" button does nothing, and running occ upgrade again gives the same issue, with the errors about column 'lazy' as before.
 

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

PASTE HERE

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

No access to this for me on server - I use a shared server from a webhosting company.

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.

As above, no access

[j-ed]

There is a nice search function, which can be accessed by clicking on the magnifying glass in the upper right corner

Unknown column 'lazy' in 'field list' when upgrading from 28.0.1.1 to 29.0.3.4

I am using Docker I have used this process Step 1: Identify Your Database Container First, you need to identify the name of your database container. Run the following command to list all running Docker containers: docker ps Look for your Nextcloud database container, typically named something like nextcloud-db or mysql. Step 2: Access the Database Container Use the docker exec command to access the shell of your database container. For example, if your container is named nextcloud-db: docke…

[EternalRookie]

Manually adding the “Lazy” field via phpMyAdmin allowed the update to complete just far enough for Softaculous to recognise the new version, and allow a further upgrade via the web client to 30.0.0

Can’t thank you enough for pointing me back to a topic that I’d already read and discarded!

[EternalRookie]

@j-ed

There is a nice search function, which can be accessed by clicking on the magnifying glass in the upper right corner

I used that exact function to look for the info and found the same post as you’ve sent me to. Unfortunately, this is a web server and not running docker, so I’d skipped that topic. I’ve had another look at it though, and it DOES look like I might be able to do the mySQL steps using phpmyadmin and try again…

Thanks - I’ll get back to you!

[j-ed]

Docker is an environment in which Nextcloud is running. The software itself and the reported issues are still the same