# Occ error after update 14

**URL:** <https://help.nextcloud.com/t/occ-error-after-update-14/39110>\
**Category:** ℹ️ Support\
**Tags:** update\_problems, nc14\
**Created:** [October 14, 2018, 10:28am UTC](https://help.nextcloud.com/t/occ-error-after-update-14/39110 "2018-10-14T10:28:14Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![neo76](https://help.nextcloud.com/letter_avatar/neo76/32/5_5575768a8748004e209b776fc1b2916d.png) [@neo76](https://help.nextcloud.com/u/neo76)\
**Post date:** [October 14, 2018, 11:46am UTC](https://help.nextcloud.com/t/occ-error-after-update-14/39110/2 "2018-10-14T11:46:00Z")

</div>

Update\>

For my this solution work perfect:

> [@DB missing index on NC 14](https://help.nextcloud.com/t/db-missing-index-on-nc-14/37048):
>
> I’ve updated to NC14 and I need to run occ db:add-missing-index but I am on Synology NAS and don’t have the ability to run occ command How can I do ? How can I add those indexes with SQL request ? Index "share\_with\_index" missing on table "share" Index "parent\_index" missing on table "share" Index "fs\_mtime" missing on table "filecache" Thanks Regards, Delor3an

I not use tablename  
`" __nextcloud__"`

simple add directley in myadmin  
 ![](https://i.imgur.com/KhkkOM7.png)

```
ALTER TABLE oc_share ADD INDEX share_with_index (share_with) USING BTREE;
ALTER TABLE oc_share ADD INDEX parent_index (parent) USING BTREE;
i added this:
ALTER TABLE oc_filecache ADD INDEX fs_mtime (mtime) USING BTREE;

```

---

_[View the full topic](https://help.nextcloud.com/t/occ-error-after-update-14/39110)._