Maintenance commands for Nextcloud

docker exec -it -u www-data nextcloud_app_1 ./occ files:scan --all

Update checksum ("The downloaded file does not match the checksum" in Nextcloud)

$ docker exec -it nextcloud_db_1 mariadb -u nextcloud -pPASSWORD nextcloud --execute "UPDATE oc_filecache SET checksum = '' WHERE COALESCE (checksum, '') <> '';"

Unlock files (https://github.com/pn11/OkaHome/blob/master/docker/nextcloud/unlock-files.sh)

code: sh

docker-compose exec -T db mysql -v -u root -penoj3dfjadklJLKFHJE nextcloud <<EOF

DELETE FROM oc_file_locks WHERE oc_file_locks.\lock\ <> 0;

EOF

#Nextcloud