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

đź“‘ How to
, , ,
4

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.

3 Likes