No mtime in database

[laziedimer]

Thank you very much for this script!

When running the script for the first time, an error occurred in the mysql command. I needed to change lines 56 and 86 to the following syntax (compatible with my installation):

nextcloud.mysql-client

> nextcloud.mysql-client \
>        --skip-column-names \
>        --silent \
>        --host="$db_host" \
>        --user="$db_user" \
>        --password="$db_pwd" \
>        --default-character-set=utf8 \
>        --execute="\

Adjusted the script, now when executing in each read file, the following warning occurs:

WARNING: cgroup v2 is not fully supported yet, proceeding with partial confinement
mysql: [Warning] Using a password on the command line interface can be insecure.
No mtime in database. File not indexed. Skipping /var/snap/nextcloud/common/nextcloud/data/bruno/files/dir/dir/sample.xlsx

And at the end of the scan no files are fixed.

I've also run the command below to scan all files:
# nextcloud.occ files:scan --all
Did not solve this problem.

Any tips on how I can go about fixing the Incorrect Date issue in files?

Note: my NextCloud installation was created via Snapcraft.

Nextcloud Version: 23.0.3 (Snap)
Database: mysql
Linux Fedora 31

[mhaendler]

Same issue here using pgsql Database...

Any update on this issue or how to resolve this error?

Thansk in Advance :)