From ebdb612458877465717bc669b40612fa833ff0c9 Mon Sep 17 00:00:00 2001 From: Chocobozzz Date: Tue, 25 Sep 2018 16:22:48 +0200 Subject: Fix redundancy totalVideos stats --- server/models/redundancy/video-redundancy.ts | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'server/models') diff --git a/server/models/redundancy/video-redundancy.ts b/server/models/redundancy/video-redundancy.ts index 970d2fe06..58c4f354c 100644 --- a/server/models/redundancy/video-redundancy.ts +++ b/server/models/redundancy/video-redundancy.ts @@ -286,8 +286,8 @@ export class VideoRedundancyModel extends Model { raw: true, attributes: [ [ Sequelize.fn('COALESCE', Sequelize.fn('SUM', Sequelize.col('VideoFile.size')), '0'), 'totalUsed' ], - [ Sequelize.fn('COUNT', Sequelize.fn('DISTINCT', 'videoId')), 'totalVideos' ], - [ Sequelize.fn('COUNT', 'videoFileId'), 'totalVideoFiles' ] + [ Sequelize.fn('COUNT', Sequelize.fn('DISTINCT', Sequelize.col('videoId'))), 'totalVideos' ], + [ Sequelize.fn('COUNT', Sequelize.col('videoFileId')), 'totalVideoFiles' ] ], where: { strategy, -- cgit v1.2.3