I have my Nextcloud FFMPEG up and running but have two issues. Bearing in mind that I am very much new to Unraid and Linux so using the Terminal and entering commands is something thats new to me hence me struggling.

 

Issue #1 is that I have an error on my nextcloud stating "The database is missing some indexes. Due to the fact that adding indexes on big tables could take some time they were not added automatically. By running "occ db:add-missing-indices" those missing indexes could be added manually while the instance keeps running. Once the indexes are added queries to those tables are usually much faster. Missing optional index "schedulobj_lastmodified_idx" in table "schedulingobjects"." Now I am struggling to find where to run that command and get it to work, I have used the main terminal and entered it and I have also clicked on Nextcloud-FFMpeg in docker and clicked console and entered it there but get "bash: occ: command not found"

 

Issue #2 is I cant get the Cron jobs to work. I have Cron (Recommended) selected and I just see "Last job execution ran 2 days ago. Something seems wrong." at the top. I have tried to download the nextcloud-cronjob app and when I try to download it I just get:

"docker run
  -d
  --name='Nextcloud-cronjob'
  --net='bridge'
  -e TZ="Europe/London"
  -e HOST_OS="Unraid"
  -e HOST_HOSTNAME="NAS"
  -e HOST_CONTAINERNAME="Nextcloud-cronjob"
  -e 'NEXTCLOUD_CONTAINER_NAME'='Nextcloud-ffmpeg'
  -e 'NEXTCLOUD_CRON_MINUTE_INTERVAL'='15'
  -e 'NEXTCLOUD_EXEC_USER'='www-data'
  -e 'NEXTCLOUD_EXEC_SHELL'='bash'
  -l net.unraid.docker.managed=dockerman
  -l net.unraid.docker.icon='https://github.com/kilrah/unraid-docker-templates/raw/main/icons/nextcloud-cronjob.png'
  -v '/var/run/docker.sock':'/var/run/docker.sock':'ro'
  -v '':'/cron-scripts':'ro' 'rcdailey/nextcloud-cronjob'

docker: invalid spec: :/cron-scripts:ro: empty section between colons.
See 'docker run --help'.

The command failed."

 

I am leaving the settings on defaults as to be honest I dont understand it all that much. Does anyone have any info on how I can solve either of these issues? I can provide any info if needed

 

Thanks

you can install unraid user script plugin then create new script below

 

#for nextcloud Cron jobs

docker exec -u 99 Nextcloud php -f /var/www/html/cron.php

 

#for missing indexes

docker exec -u 99 Nextcloud php ./occ db:add-missing-indices

 

you can separate these 2 command for it own schedule 

 

edit if your nextcloud container name Nextcloud-ffmpeg just change Nextcloud to Nextcloud-ffmpeg in script above 

 

Edited September 14, 20241 yr by Gvon