occ db:add-missing-indices - Exact steps to resolve?

[opgailey]

Hi all,

I've just updated by NC 13 server to NC 14 using the built in updater.

'Security & Set Up Warnings' is reporting: Missing index "fs_mtime" in table "oc_filecache"

It is telling me to run 'occ db:add-missing-indices' and according to the the NC 13 documentation the specific command is: sudo -u www-data php occ db:add-missing-indices
https://docs.nextcloud.com/server/13/admin_manual/configuration_server/occ_command.html#database-add-indices-label

When I run this command via CLI as ncadmin I get the following response: Could not open input file: occ

Any ideas? Am I running this command from the wrong place? Can someone detail the exact steps / commands required to resolve this Missing index "fs_mtime" in table "oc_filecache" issue?

I am a Linux beginner so apologies if the answer is obvious.

Many thanks.

[nextcloud-bot]

GitMate.io thinks possibly related issues are #10926 (Possible DB indexes), #4625 (Missed sql index), #10656 (Configuration check - Minor typo: occ db:add-missing-indices), #10299 (Add filecache index on mtime), and #10158 (occ: user:list missing "numeric" username).

[ghost]

Did you try running this command inside your nextcloud main install folder? (Where there's the files index.php, remote.php, the occ folder, ...) It worked there for me

[opgailey]

@Jonast Oh dear. No I didn't. I was running it from the wrong location. :/

Apologies for that. I have run the command and it has worked perfectly.

Thanks for your help.

[FireEmerald]

Is it also possible to run the command from the web interface or execute a database query? Because if you do not have access to a CLI you can't run the command.

[nickvergessen]

This should be discussed in #11491

[necesitod]

I can fix it
on the path nextcloud example /var/www/html/nextcloud

I made like root (Without ")

"sudo -u www-data php ./occ add-missing-indices"

on Debian GNU/Linux 11 (bullseye)