After updating to nextcloud 14 I get the following error:
Some indices are missing in the database. Because adding indexes to large tables may take some time, they have not been added automatically. By executing “occ db: add-missing-indices”, missing indexes can be added manually while the instance is running. Once the indexes have been added, queries to these tables are usually faster.
Missing index “share_with_index” in the “oc_share” table.
Missing index “parent_index” in the “oc_share” table.
Missing index “fs_mtime” in the “oc_filecache” table.
Using a shared hosting I can not launch the occ command.
How can I add these values manually? thank you so much
And finally the prompt should show something like this:
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 mtime index to the filecache table, this can take some time…
Filecache table updated successfully.
Followed the instructions to address similar message with a NC 16.0.3 / NCP install. Solved the issues highlighted. As an aside my security reating increased from A to A+ with https://scan.nextcloud.com and https://www.ssllabs.com. Thank you.