Problem config folder

nemo87 · May 15, 2025, 9:21pm

pi@raspberrypi:/var/www/nextcloud $ sudo -u www-data php occ upgrade -vv
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
2025-05-15T21:18:17+00:00 Setting log level to debug
2025-05-15T21:18:17+00:00 Exception: Updates between multiple major versions and downgrades are unsupported.
2025-05-15T21:18:17+00:00 Update failed
2025-05-15T21:18:17+00:00 Maintenance mode is kept active
2025-05-15T21:18:17+00:00 Resetting log level
pi@raspberrypi:/var/www/nextcloud $ sudo -u www-data php updater/updater.phar
Nextcloud Updater - version: v25.0.11-5-g06c1bad

Current version is 25.0.13.

No update available.

Nothing to do.
pi@raspberrypi:/var/www/nextcloud $ sudo -u www-data php occ maintenance:repair
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

Repair MySQL collation

All tables already have the correct collation → nothing to do

Repair mime types

Clean tags and favorites

0 tags of deleted users have been removed.

0 tags for delete files have been removed.

0 tag entries for deleted tags have been removed.

0 tags with no entries have been removed.

Repair invalid shares

Move .step file of updater to backup location

Add move avatar background job

Add background job

ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘argument_hash’ in ‘WHERE’

Add preview cleanup background jobs

Migrate oauth2_clients table to nextcloud schema

oauth2_clients table does not exist.

Fix potential broken mount points

No mounts updated

Repair language codes

Changed 0 setting(s) from “bg_BG” to “bg” in preferences table.

Changed 0 setting(s) from “cs_CZ” to “cs” in preferences table.

Changed 0 setting(s) from “fi_FI” to “fi” in preferences table.

Changed 0 setting(s) from “hu_HU” to “hu” in preferences table.

Changed 0 setting(s) from “nb_NO” to “nb” in preferences table.

Changed 0 setting(s) from “sk_SK” to “sk” in preferences table.

Changed 0 setting(s) from “th_TH” to “th” in preferences table.

Add log rotate job

ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘argument_hash’ in ‘WHERE’

Clear frontend caches

Image cache cleared

WARNING: Unable to clear the frontend cache

Clear every generated avatar

WARNING: Unable to clear the avatar cache

Add preview background cleanup job

ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘argument_hash’ in ‘WHERE’

Queue a one-time job to cleanup old backups of the updater

ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘argument_hash’ in ‘WHERE’

Cleanup invalid photocache files for carddav

ERROR: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘owncloud.oc_filecache_extended’ doesn’t exist

Add background job to cleanup login flow v2 tokens

ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘argument_hash’ in ‘WHERE’

Remove potentially over exposing share links

No need to remove link shares.

Clear access cache of projects

ERROR: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘owncloud.oc_collres_accesscache’ doesn’t exist

Reset generated avatar flag

Keep legacy encryption enabled

Check encryption key format

Remove old dashboard app config data

Add job to cleanup the bruteforce entries

ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘argument_hash’ in ‘WHERE’

Queue a one-time job to check for user uploaded certificates

ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘argument_hash’ in ‘WHERE’

Repair DAV shares

Repaired DAV group shares

Add background job to set the lookup server share state for users

ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘argument_hash’ in ‘WHERE’

Add token cleanup job

ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘argument_hash’ in ‘WHERE’

Clean up abandoned apps

Add possibly missing system config

Fix component of birthday calendars

1 birthday calendars updated.

Regenerating birthday calendars to use new icons and fix old birthday events without year

Adding background jobs to regenerate birthday calendar

ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘argument_hash’ in ‘WHERE’

Fix broken values of calendar objects
0 [->--------------------------]

Registering building of calendar search index as background job

Add background job

ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘argument_hash’ in ‘WHERE’

Register building of social profile search index as background job

Registering background jobs to update cache for webcal calendars

Added 0 background jobs to update webcal calendars

Registering building of calendar reminder index as background job

Add background job

ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘argument_hash’ in ‘WHERE’

Clean up orphan event and contact data

ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘c.calendartype’ in ‘WHERE’

Remove activity entries of private events

Removed 0 activity entries

Clean up old calendar subscriptions from deleted users that were not cleaned-up
0 [----->----------------------]

0 calendar subscriptions without an user have been cleaned up

Remove invalid object properties

0 invalid object properties removed.

Update OAuth token expiration times

ERROR: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘owncloud.oc_oauth2_access_tokens’ doesn’t exist

Initialize migration of background images from dashboard to theming app

ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘argument_hash’ in ‘WHERE’

Add background job to check for backup codes

ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘argument_hash’ in ‘WHERE’

Populating added database structures for workflows

ERROR: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘owncloud.oc_flow_operations’ doesn’t exist
pi@raspberrypi:/var/www/nextcloud $ sudo -u www-data php occ db:add-missing-indices
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
Check indices of the share table.
Adding additional parent index to the share table, this can take some time…
Share table updated successfully.
Adding additional owner index to the share table, this can take some time…
Share table updated successfully.
Adding additional initiator index to the share table, this can take some time…
Share table updated successfully.
Check indices of the filecache table.
Adding additional mtime index to the filecache table, this can take some time…
Filecache table updated successfully.
Adding additional size index to the filecache table, this can take some time…
Filecache table updated successfully.
Adding additional size index to the filecache table, this can take some time…
Filecache table updated successfully.
Adding additional path index to the filecache table, this can take some time…
Filecache table updated successfully.
Adding additional parent index to the filecache table, this can take some time…
Filecache table updated successfully.
Check indices of the twofactor_providers table.
Check indices of the login_flow_v2 table.
Check indices of the whats_new table.
Check indices of the cards table.
Renaming addressbookid_uri_index index to cards_abiduri in the cards table, this can take some time…
Adding cards_abid index to the cards table, this can take some time…
cards table updated successfully.
Check indices of the cards_properties table.
Adding cards_prop_abid index to the cards_properties table, this can take some time…
cards_properties table updated successfully.
Check indices of the calendarobjects_props table.
Check indices of the schedulingobjects table.
Adding schedulobj_principuri_index index to the schedulingobjects table, this can take some time…
schedulingobjects table updated successfully.
Check indices of the oc_properties table.
Adding properties_path_index index to the oc_properties table, this can take some time…

In SchemaException.php line 87:

There is no column with name ‘userid’ on table ‘oc_properties’.

db:add-missing-indices [–dry-run]

jtr · May 15, 2025, 9:41pm

Looks like the last revision or two to the Owncloud migration docs may need some adjusting. v25 is hardcarded to expect 10.13.x.

github.com/nextcloud/server

version.php

30fb8a53b


      
          	'owncloud' => [
          		'10.13' => true,
          	],

Looks like someone just reported this last week:

github.com/nextcloud/documentation

Owncloud migration documentation: Add hints to edit version.php, and to trigger background migrations after each upgrade step

opened 01:11PM - 05 May 25 UTC

altruizine

bug 0. Needs triage manual: admin

The [Owncloud migration documentation](https://docs.nextcloud.com/server/latest/…admin_manual/maintenance/migrating_owncloud.html) is helpful and mostly works, but it is missing two crucial hints: 1. The migration documentation advertises compatibility with Owncloud versions 10.13.x, 10.14.x, and 10.15.x, but only works out of the box with Owncloud version 10.13.x. The reason is that Nextcloud 25.0.13 declares itself compatible with Owncloud 10.13.x only in version.php. Changing this file allows the migration to proceed. As it's impossible to file bugs against this unsupported old Nextcloud version, the migration documentation should explain how to change the version.php file. 2. As documented in [How to upgrade](https://docs.nextcloud.com/server/latest/admin_manual/maintenance/upgrade.html#approaching-upgrades), we must wait for all background migrations to complete before taking the next upgrade step. The Owncloud migration documentation neither advises to pause and wait for background migrations to happen (or to trigger them manually), nor does it link to the latter page that explains the matter. Thus, it's easy to miss when going through the 25 → 26 → 27 → 28 → 29 → 30 → 31 upgrades. This is in fact what happened to me during a recent upgrade: Several background migrations were missed or aborted, leading to an inconsistent database schema. I suggest adding an explicit hint to the migration documentation.

nemo87 · May 17, 2025, 5:05pm

I reinstalled owncloud version 10.13.2, and re-ran the migration, at the beginning via web same error message previously indicated, I tried from terminal to give the command: sudo -E -u www-data php occ upgrade

pi@raspberrypi:/var/www/nextcloud $ sudo -E -u www-data 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

Updating database schema

Updated database

Disabled incompatible app: diagnostics

Disabled incompatible app: files_texteditor

Disabled incompatible app: market

Updating …

Updated to 1.20.1

Updating …

Updated to 2.17.0

Updating …

Fix broken values of calendar objects

Done

0/0 [->--------------------------] 0%

Clean up old calendar subscriptions from deleted users that were not cleaned-up

Done

0/0 [----->----------------------] 0%

Updated to 1.24.0

Updating …

Updated to 1.15.0

Updating <files_pdfviewer> …

Updated <files_pdfviewer> to 2.6.0

Updating <provisioning_api> …

Updated <provisioning_api> to 1.15.0

Starting code integrity check…

Finished code integrity check

Update successful

Turned off maintenance mode

Resetting log level

now via wbe i can log in and i have all my data

system · August 15, 2025, 5:05pm

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