Hello,
I update my server since NC13. I am on a shared hosting by OVH.
Since the update to NC15, I have new alerts in the Administration> Overview section:
The database is missing some indexes. Due to the fact that they added indexes on big tables they were not added automatically. By running âocc db: add-missing-indicesâ those missing indexes could be added manually while the instance kept running. Once the indexes are added, they are usually much faster.
Missing index "owner_index" in table "oc_share".
Missing index "initiator_index" in table "oc_share".
Some columns in the database are missing a conversion to big int. They were not changed automatically. By running âocc db: convert-filecache-bigintâ those pending changes could be applied manually. This operation needs to be made while the instance is offline. For more details read the documentation page about this.
filecache.mtime
filecache.storage_mtime
In the past, and not having access to OCC Commands, I had found a solution to execute these commands via phpmyadmin which had worked during the transition to NC14 (previous different alerts):
ALTER TABLE oc_share
ADD KEY share_with_index
(share_with
) USING BTREE;
ALTER TABLE oc_share
ADD KEY parent_index
(parent
) USING BTREE;
ALTER TABLE oc_filecache
ADD KEY fs_mtime
(mtime
) USING BTREE;
Can someone write me phpmyadmin commands to fix these new errors:
occ db: add-missing-indices
-> âowner_indexâ in table âoc_shareâ
-> âinitiator_indexâ in table âoc_shareâ
occ db: convert-filecache-bigint
-> filecache.mtime
-> filecache.storage_mtime
Maybe itâs also possible with a CRON job? But I do not know the formula to execute either.
I use PHP 7.3.
And maybe itâs a problem of the update and we have to wait for a fix?
Thanks a lot in advance