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

**URL:** <https://help.nextcloud.com/t/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-cant-use-occ-command-in-shared-hosting/42976>\
**Category:** 📑 How to\
**Tags:** nc14, database, ovh, nc15\
**Created:** [December 11, 2018, 12:28pm UTC](https://help.nextcloud.com/t/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-cant-use-occ-command-in-shared-hosting/42976 "2018-12-11T12:28:05Z")\
**Posts on this page:** 1\
**Showing post:** 23

<div class="post-metadata">

**Author:** ![ffs69](https://help.nextcloud.com/letter_avatar/ffs69/32/5_5575768a8748004e209b776fc1b2916d.png) [@ffs69](https://help.nextcloud.com/u/ffs69)\
**Post date:** [December 29, 2019, 12:30pm UTC](https://help.nextcloud.com/t/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-cant-use-occ-command-in-shared-hosting/42976/23 "2019-12-29T12:30:33Z")

</div>

Hello everybody,  
First of all I wish you all very happy celebrations! 🥳🎉🎅🎊☃

I turn to you regarding the new alerts in my configuration since the update from 17.0.1 to 17.0.2:  
“Some columns in the database are missing a conversion to big int. […]”  
mounts.storage\_id  
mounts.root\_id  
mounts.mount\_id

I don’t know how to identify the characteristics to make the necessary sql commands myself, if someone can help me?

I know it should look something like this:

> ```
> ALTER TABLE `???` MODIFY `mounts.storage_id` bigint ???;
> ALTER TABLE `???` MODIFY `mounts.root_id` bigint ???;
> ALTER TABLE `???` MODIFY `mounts.mount_id` bigint ???;
> 
> ```

But I don’t know how to identify in which table (`oc_filecache`,` oc_mimetypes`, `oc_storages`, …) and what value to configure for each column (NOT NULL DEFAULT ‘0’ or NOT NULL AUTO\_INCREMENT)?

In advance thank you for your help and all wishes of happiness and good health to all 🤘😘🤗

---

_[View the full topic](https://help.nextcloud.com/t/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-cant-use-occ-command-in-shared-hosting/42976)._