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

database
ovh
nc15
nc14

#21

mostly I got it back, one error left

occ $ maintenance:mimetype:update-db
In Loader.php line 130:

Failed to get mimetype id for application/illustrator after trying to store
it

maintenance:mimetype:update-db [–repair-filecache]
occ $

I have only occ web or database access via phpadmin. Can help anyone?

Micha


#22

For those using PostgreSQL:

ALTER TABLE oc_filecache
    ALTER COLUMN mtime SET DATA TYPE bigint,
    ALTER COLUMN storage_mtime SET DATA TYPE bigint;
CREATE INDEX initiator_index ON oc_share USING btree (uid_initiator);
CREATE INDEX owner_index ON oc_share USING btree (uid_owner);