diff options
author | Chocobozzz <me@florianbigard.com> | 2020-06-09 15:59:35 +0200 |
---|---|---|
committer | Chocobozzz <chocobozzz@cpy.re> | 2020-06-10 14:02:41 +0200 |
commit | f046e2fa5c2af98f378056206ef65347f4b29b8d (patch) | |
tree | c2cffab0541c9fb0c29e02c7011fe74e108274d3 /server/models/video/video.ts | |
parent | 5fb2e2888ce032c638e4b75d07458642f0833e52 (diff) | |
download | PeerTube-f046e2fa5c2af98f378056206ef65347f4b29b8d.tar.gz PeerTube-f046e2fa5c2af98f378056206ef65347f4b29b8d.tar.zst PeerTube-f046e2fa5c2af98f378056206ef65347f4b29b8d.zip |
Fix video follow SQL
Diffstat (limited to 'server/models/video/video.ts')
-rw-r--r-- | server/models/video/video.ts | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/server/models/video/video.ts b/server/models/video/video.ts index 344bfc929..5aa40220e 100644 --- a/server/models/video/video.ts +++ b/server/models/video/video.ts | |||
@@ -1366,7 +1366,7 @@ export class VideoModel extends Model<VideoModel> { | |||
1366 | // Instances only share videos | 1366 | // Instances only share videos |
1367 | const query = 'SELECT 1 FROM "videoShare" ' + | 1367 | const query = 'SELECT 1 FROM "videoShare" ' + |
1368 | 'INNER JOIN "actorFollow" ON "actorFollow"."targetActorId" = "videoShare"."actorId" ' + | 1368 | 'INNER JOIN "actorFollow" ON "actorFollow"."targetActorId" = "videoShare"."actorId" ' + |
1369 | 'WHERE "actorFollow"."actorId" = $followerActorId AND "videoShare"."videoId" = $videoId ' + | 1369 | 'WHERE "actorFollow"."actorId" = $followerActorId AND "actorFollow"."state" = \'accepted\' AND "videoShare"."videoId" = $videoId ' + |
1370 | 'LIMIT 1' | 1370 | 'LIMIT 1' |
1371 | 1371 | ||
1372 | const options = { | 1372 | const options = { |