diff options
| author | Chocobozzz <me@florianbigard.com> | 2021-02-19 09:50:13 +0100 |
|---|---|---|
| committer | Chocobozzz <me@florianbigard.com> | 2021-02-19 10:06:52 +0100 |
| commit | 9d6b9d10ef8cbef39e89bc709285abffb0d8caa1 (patch) | |
| tree | 3425b22556e00d1b15de15c72b2802cfc9374473 /server/models/utils.ts | |
| parent | fae6e4da8f516a9d6c3bad9bf6f35811ccacbad8 (diff) | |
| download | PeerTube-9d6b9d10ef8cbef39e89bc709285abffb0d8caa1.tar.gz PeerTube-9d6b9d10ef8cbef39e89bc709285abffb0d8caa1.tar.zst PeerTube-9d6b9d10ef8cbef39e89bc709285abffb0d8caa1.zip | |
Fix video comments display with deleted comments
Diffstat (limited to 'server/models/utils.ts')
| -rw-r--r-- | server/models/utils.ts | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/server/models/utils.ts b/server/models/utils.ts index 143c1a23c..5337ae75d 100644 --- a/server/models/utils.ts +++ b/server/models/utils.ts | |||
| @@ -134,7 +134,7 @@ function buildBlockedAccountSQL (blockerIds: number[]) { | |||
| 134 | const blockerIdsString = blockerIds.join(', ') | 134 | const blockerIdsString = blockerIds.join(', ') |
| 135 | 135 | ||
| 136 | return 'SELECT "targetAccountId" AS "id" FROM "accountBlocklist" WHERE "accountId" IN (' + blockerIdsString + ')' + | 136 | return 'SELECT "targetAccountId" AS "id" FROM "accountBlocklist" WHERE "accountId" IN (' + blockerIdsString + ')' + |
| 137 | ' UNION ALL ' + | 137 | ' UNION ' + |
| 138 | 'SELECT "account"."id" AS "id" FROM account INNER JOIN "actor" ON account."actorId" = actor.id ' + | 138 | 'SELECT "account"."id" AS "id" FROM account INNER JOIN "actor" ON account."actorId" = actor.id ' + |
| 139 | 'INNER JOIN "serverBlocklist" ON "actor"."serverId" = "serverBlocklist"."targetServerId" ' + | 139 | 'INNER JOIN "serverBlocklist" ON "actor"."serverId" = "serverBlocklist"."targetServerId" ' + |
| 140 | 'WHERE "serverBlocklist"."accountId" IN (' + blockerIdsString + ')' | 140 | 'WHERE "serverBlocklist"."accountId" IN (' + blockerIdsString + ')' |