diff options
| author | Hamza Mahjoubi <hamzamahjoubi221@gmail.com> | 2024-08-27 14:07:28 +0200 |
|---|---|---|
| committer | Hamza Mahjoubi <hamzamahjoubi221@gmail.com> | 2024-08-27 14:08:29 +0200 |
| commit | 6361edb8641cc38bac66f1cd19f9b1b58621c9ea (patch) | |
| tree | b41f72d6831cc8c67ff418762143f19bcb564bd6 /core/Command/Maintenance | |
| parent | 829642c9e504813bad55e39be7527abe70e488cc (diff) | |
| download | nextcloud-server-6361edb8641cc38bac66f1cd19f9b1b58621c9ea.tar.gz nextcloud-server-6361edb8641cc38bac66f1cd19f9b1b58621c9ea.zip | |
fix: optimise getWrongShareOwnership query
Signed-off-by: Hamza Mahjoubi <hamzamahjoubi221@gmail.com>
Diffstat (limited to 'core/Command/Maintenance')
| -rw-r--r-- | core/Command/Maintenance/RepairShareOwnership.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/core/Command/Maintenance/RepairShareOwnership.php b/core/Command/Maintenance/RepairShareOwnership.php index 71bc50b0bb8..a24be53b00e 100644 --- a/core/Command/Maintenance/RepairShareOwnership.php +++ b/core/Command/Maintenance/RepairShareOwnership.php @@ -85,7 +85,7 @@ class RepairShareOwnership extends Command { $brokenShares = $qb ->select('s.id', 'm.user_id', 's.uid_owner', 's.uid_initiator', 's.share_with', 's.file_target') ->from('share', 's') - ->join('s', 'filecache', 'f', $qb->expr()->eq('s.item_source', $qb->expr()->castColumn('f.fileid', IQueryBuilder::PARAM_STR))) + ->join('s', 'filecache', 'f', $qb->expr()->eq($qb->expr()->castColumn('s.item_source', IQueryBuilder::PARAM_INT), 'f.fileid')) ->join('s', 'mounts', 'm', $qb->expr()->eq('f.storage', 'm.storage_id')) ->where($qb->expr()->neq('m.user_id', 's.uid_owner')) ->andWhere($qb->expr()->eq($qb->func()->concat($qb->expr()->literal('/'), 'm.user_id', $qb->expr()->literal('/')), 'm.mount_point')) |