search

nextcloud-gmbh / mtime_fixer_tool_kit

Tool kit to fix the mtime issue on the server state
15 stars 7 forks source link

SQL Error when using pgsql and groufolders #14

Closed neumantm closed 2 years ago

neumantm commented 2 years ago

For me solvable_files.sh fails with 

ERROR:  syntax error at or near "base64"
LINE 4: ...mdzdGVjaG5pay9mdy1kdF9LYXBpdGVsMDhfMDFfMjAucGRm, 'base64'), ...
                                                             ^

I'm using pgsql and have groupfolders.

The error seems to occur in the groupfolder branch.

There (line 73) the quoting of the SQL statetment seems wrong to me. It is definitively different than the version for normal users.

After changing the quoting to be similar to the case for normal users, I don't get any errors anymore.

artonge commented 2 years ago

Thanks for reporting, can you confirm that this PR solved it for you: https://github.com/nextcloud-gmbh/mtime_fixer_tool_kit/pull/15

neumantm commented 2 years ago

Ah sorry, didn't see your comment/PR in time. As your PR is exactly the same as mine: Yes that fixes it.

artonge commented 2 years ago

I merged yours as you put more information in the PR, thanks again :)