Nextcloud

fix Missing index “fsstoragepathprefix” in table “ocfilecache”

docker compose exec --user www-data nextcloud php occ db:add-missing-indices

This will install imagemagick(for SVG previews) and postgresql client for backups. Without needing a custom image.

command: -c "apk add --no-cache postgresql-client imagemagick; /entrypoint.sh php-fpm"

The command for cron container

command: -c "apk add --no-cache imagemagick postgresql-client; /cron.sh"

sources: https://github.com/nextcloud/docker/issues/1414#issuecomment-884711124

https://github.com/nextcloud/backup/issues/175#issuecomment-1058245708