With the command 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]
Log file in debug mode.
==> nextcloud.log <==
{"reqId":"oXlrLRdcMyuunEb71Chc","level":3,"time":"2025-01-21T10:24:15+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Exception while executing
repair step Regenerating birthday calendars to use new icons and fix old birthday events without year","userAgent":"--","version":"10.14.0.3","exception":{"Exception":"OC\\DB\\Exceptions\\D
balException","Message":"An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause'","Code":1054,"Trace":[{"file"
:"/var/www/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":296,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::"},{"file":"/var/www/owncloud/lib/private
/BackgroundJob/JobList.php","line":153,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/owncloud/lib/private/BackgroundJob/JobList.php","
line":70,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/owncloud/apps/dav/lib/Migration/RegenerateBirthdayCalendars.php","line":68,"function":"add","cla
ss":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/owncloud/lib/private/Repair.php","line":127,"function":"run","class":"OCA\\DAV\\Migration\\RegenerateBirthdayCalendars","type"
:"->"},{"file":"/var/www/owncloud/core/Command/Maintenance/Repair.php","line":123,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/owncloud/3rdparty/symfony/console/Comma
nd/Command.php","line":255,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/owncloud/3rdparty/symfony/console/Application.php","line":1009
,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/owncloud/3rdparty/symfony/console/Application.php","line":273,"function":"doRunComman
d","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/owncloud/3rdparty/symfony/console/Application.php","line":149,"function":"doRun","class":"Symfony\\Compon
ent\\Console\\Application","type":"->"},{"file":"/var/www/owncloud/lib/private/Console/Application.php","line":214,"function":"run","class":"Symfony\\Component\\Console\\Application","type":
"->"},{"file":"/var/www/owncloud/console.php","line":100,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/owncloud/occ","line":11,"args":["/var/www/owncloud
/console.php"],"function":"require_once"}],"File":"/var/www/owncloud/lib/private/DB/Exceptions/DbalException.php","Line":72,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\InvalidFieldNa
meException","Message":"An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause'","Code":1054,"Trace":[{"file":
"/var/www/owncloud/3rdparty/doctrine/dbal/src/Connection.php","line":1780,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->"},{"file":"/var/www
/owncloud/3rdparty/doctrine/dbal/src/Connection.php","line":1719,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/owncloud/3rdparty/doct
rine/dbal/src/Connection.php","line":1067,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/owncloud/lib/private/DB/Connection.php"
,"line":261,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/owncloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":345,"function":"e
xecuteQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":281,"function":"execute","class":"Doctrine\\DBAL\\Query
\\QueryBuilder","type":"->"},{"file":"/var/www/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":294,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"
},{"file":"/var/www/owncloud/lib/private/BackgroundJob/JobList.php","line":153,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/owncloud/
lib/private/BackgroundJob/JobList.php","line":70,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/owncloud/apps/dav/lib/Migration/RegenerateBirthdayCalend
ars.php","line":68,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/owncloud/lib/private/Repair.php","line":127,"function":"run","class":"OCA\\DAV\\Migrat
ion\\RegenerateBirthdayCalendars","type":"->"},{"file":"/var/www/owncloud/core/Command/Maintenance/Repair.php","line":123,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www
/owncloud/3rdparty/symfony/console/Command/Command.php","line":255,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/owncloud/3rdparty/symf
ony/console/Application.php","line":1009,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/owncloud/3rdparty/symfony/console/Application
.php","line":273,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/owncloud/3rdparty/symfony/console/Application.php","line":149,"fu
nction":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/owncloud/lib/private/Console/Application.php","line":214,"function":"run","class":"Symfony\\
Component\\Console\\Application","type":"->"},{"file":"/var/www/owncloud/console.php","line":100,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/owncloud/o
cc","line":11,"args":["/var/www/owncloud/console.php"],"function":"require_once"}],"File":"/var/www/owncloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":65,"Pr
evious":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause'","Code":1054,"Trace":[{"file
":"/var/www/owncloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":94,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::"},{"file":"/var/www/owncloud/
3rdparty/doctrine/dbal/src/Connection.php","line":1057,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/owncloud/lib/private/DB/Connection
.php","line":261,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/owncloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":345,"functio
n":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":281,"function":"execute","class":"Doctrine\\DBAL\\
Query\\QueryBuilder","type":"->"},{"file":"/var/www/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":294,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type"
:"->"},{"file":"/var/www/owncloud/lib/private/BackgroundJob/JobList.php","line":153,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/ownc
loud/lib/private/BackgroundJob/JobList.php","line":70,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/owncloud/apps/dav/lib/Migration/RegenerateBirthdayC
alendars.php","line":68,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/owncloud/lib/private/Repair.php","line":127,"function":"run","class":"OCA\\DAV\\M
igration\\RegenerateBirthdayCalendars","type":"->"},{"file":"/var/www/owncloud/core/Command/Maintenance/Repair.php","line":123,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/va
r/www/owncloud/3rdparty/symfony/console/Command/Command.php","line":255,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/owncloud/3rdparty
/symfony/console/Application.php","line":1009,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/owncloud/3rdparty/symfony/console/Applic
ation.php","line":273,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/owncloud/3rdparty/symfony/console/Application.php","line":14
9,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/owncloud/lib/private/Console/Application.php","line":214,"function":"run","class":"Symf
ony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/owncloud/console.php","line":100,"function":"run","class":"OC\\Console\\Application","type":"->"},