Fix-bug-invalid-modification-date inside docker

[robertofabrizi]

Hello everyone, I'm trying to fix the mess that was caused by the modification date bug by using this official guide, but it doesn't work when NC is a docker container (it doesn't have psql installed).

Is there another guide to follow?

Thank you,
RF

[isdnfan]

you can either install psql in the container (not best practice but for troubleshooting perfectly valid) or expose your DB port on the docker host and connect using your favorite tool.

take a look at this SQL query (it's built on MariaDB mayby you need to adopt for Postgres). This collects invalid files and their versions with additional data from the database and could become starting point for further recovery steps.

nextcloud-gmbh/mtime_fixer_tool_kit#23 (comment)

related to mtime_fixer_tool_kit #4016 #4188

[robertofabrizi]

But exposing the postgres port doesn't mean that I can run the script from my laptop, as the script requires not just the db but also the nextcloud files, right?

./solvable_files.sh <mysql|pgsql> <list|fix> <noscan|scan>

[github-actions]

This bug report did not receive an update in the last 4 weeks. Please take a look again and update the issue with new details, otherwise the issue will be automatically closed in 2 weeks. Thank you!

[github-actions]

This bug report is getting automatically closed due to no answer since the issue has been staled. Thank you!