Fehlende Indizes in Datenbank (kein SSH)

[tflidd]

Es geht auch manuell:

"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)

Awesome ! So to synthesize sql requests via phpmyadmin and equivalent to OCC commands it gives: Up to NC14: 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; Up to NC15: ALTER TABLE `oc_share` ADD KEY `owner_index` (`uid_owner`) USING BTREE; ALTER TABLE `oc_share` ADD KEY `initiator_index` (`uid_initiator`) USI…

(Backup nicht vergessen!)