Missing-index

[TinTinMar515]

Hi,
I recently upgrade my server from Nextcloud 13 to 14 and the warning security configuration told me to run : occ db: add-missing-index
but the command appears to be not the good one.
I ran :
sudo -u www-data php occ db:add-missing-indices
After it was done, everything seems to be ok.
Sorry for my English and thank you for your work,

[nextcloud-bot]

GitMate.io thinks possibly related issues are #11167 (occ db:add-missing-indices - Exact steps to resolve?), #10926 (Possible DB indexes), #4820 (Asturian language is missing), #866 (Calendar Share Functionality missing), and #10656 (Configuration check - Minor typo: occ db:add-missing-indices).

[Gabuzomeuh]

I ran into the same issue when updating from 13.0.6 to 14.0.1

Used phpmyadmin to add the missing index with :

ALTER TABLE oc_filecache ADD INDEX fs_mtime (mtime) USING BTREE;

[MorrisJobke]

but the command appears to be not the good one.
I ran :
sudo -u www-data php occ db:add-missing-indices
After it was done, everything seems to be ok.
Sorry for my English and thank you for your work,

Thanks for this feedback. The command then gives you more hints, because depending on your setup the user you need to run this under could be named differently. So I would leave this as it is, because the occ command gives you further and more correct hints what to do.

[TinTinMar515]

Yes but the errors is the proposal :
occ db: add-missing-index
instead of :
occ db:add-missing-indices

There is a space betwen bd: and add
and its index instead of indices.
Sorry to insist.

[kesselb]

When you report issues with translations it might be good to report the language you use for nextcloud. I did grep -R "add-missing-index" but could not find any place. I guess this has been solved but not released yet. Thank you for reporting 👍

[MorrisJobke]

When you report issues with translations it might be good to report the language you use for nextcloud. I did grep -R "add-missing-index" but could not find any place. I guess this has been solved but not released yet. Thank you for reporting 👍

Same here - I could not find it in the code.