Missing Indices on NC15

[Schmu]

Indices:

"The database is missing some indexes." and "Some columns in the database are missing a conversion to big int." with phpmyadmin and-or CRON job (can't use occ command in shared hosting)

Hello, queries to run for fixing the issues: ALTER TABLE `oc_share` ADD KEY `owner_index` (`uid_owner`) USING BTREE; ALTER TABLE `oc_share` ADD KEY `initiator_index` (`uid_initiator`) USING BTREE; I updated my system to NC15 and still trying to fix some performance issues. I will write down my findings since the system is running.

Big Int:

"The database is missing some indexes." and "Some columns in the database are missing a conversion to big int." with phpmyadmin and-or CRON job (can't use occ command in shared hosting)

Hello, with the following queries you can modify the database field type from int(11) to bigint(20): ALTER TABLE `oc_filecache` MODIFY `mtime` bigint NOT NULL DEFAULT '0'; ALTER TABLE `oc_filecache` MODIFY `storage_mtime` bigint NOT NULL DEFAULT '0'; This will solve the “occ db: convert-filecache-bigint” part.