some indices are missing in the database! how to add them manually
after updating to nextcloud 14 i get the following error:

some indices are missing in the database. because adding indexes to large tables may take some time, they have not been added automatically. by executing “occ db: add-missing-indices”, missing indexes can be added manually while the instance…
someone forgot to link one of the answers in the meantime.

[image]

[how can i run run occ db:add-missing-indices on shared hosting](https://help.nextcloud.com/t/how-can-i-run-run-occ-db-add-missing-indices-on-shared-hosting/36761/2) [support](/c/support)

i found a work around for this, so if anyone else finds themselves in the same boat, this is one way to resolve it.

i don’t have shel…
Please see: [How do I schedule a task to update indexes?](https://qa.mythicsoft.com/14733/how-do-i-schedule-a-task-to-update-indexes?show=14733#q14733) Here is a link to assist you.


<https://technet.microsoft.com/en-us/library/ms178078(v=sql.105).aspx>


If you had done a web search with the question you entered here, you would have found multiple sites that give you the instructions you might be able to use synchronize. if you have more than 2 tables, you will need to use it multiple times. howdy and welcome to the forum!

take a closer look at the comment on line 13…it suggests using a different method

you are incrementing enemyindex, but not quite in the correct place…it should be the final statement in your while(enemyindex…) loop

like item 1, don’t forget the instructions in the c… A trigger is not what you want.


What you need is a scheduled job.


Take a look at the official documentation on the subject:


[Scheduling Jobs with Oracle Scheduler](http://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse.htm#i1033533)


Feel free to ask more questions if you find any trouble when creating your scheduled job. hi stuti, 
index can be used with lists, not tables. 
if a variable is used as an index, it is put in the square brackets without the dollar sign and curly brackets, i.e. ${data\_list[item\_index]}. 
you can read more about using indexes with lists in the knowledge base: [https://kb.workfusion.com/disp…](https://kb.workfusion.com/display/rpae/recorder+variables#recordervariables-usingindexeswithlists) hi sheeeng.  thank you for reporting this to us.  we looked into that file and verified that there is a false detection indeed.  we have fixed this already and the fix should go out soon on the next database releases.

 

thank you again for you report! 

 

 

f-secure labs hey! your token request has been successfully added to the [accointing.com](http://accointing.com) database. it should be available today at 11:00 p.m. gmt. (7 a.m. et) it's not in the core, but you can use an app: <https://apps.owncloud.com/content/show.php/registration?content=170608> The clue is `Access denied for user 'homestead'@'localhost'`


Do you have a user called `homestead`? Have you attempted to grant them access to the database?


If you're unsure of the answers to either of those questions, I think you should re-read the documentation.