summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorSimon Rettberg2018-12-07 16:18:32 +0100
committerSimon Rettberg2018-12-07 16:18:32 +0100
commit20d6acc1dc6424421922e7c8856076f70d42e93d (patch)
tree292a3f6f80da59390d7ddb32dbfdb9ba07884f13
parent[client] Get rid of Feature checks; RPC version was bumped (diff)
downloadtutor-module-20d6acc1dc6424421922e7c8856076f70d42e93d.tar.gz
tutor-module-20d6acc1dc6424421922e7c8856076f70d42e93d.tar.xz
tutor-module-20d6acc1dc6424421922e7c8856076f70d42e93d.zip
[server] Fix query
-rw-r--r--dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java2
1 files changed, 1 insertions, 1 deletions
diff --git a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java
index 3ee4f5d3..133ce846 100644
--- a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java
+++ b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java
@@ -64,7 +64,7 @@ public class DbImage {
+ " lat.expiretime, lat.filesize, lat.isrestricted, lat.isvalid,"
+ " lat.uploaderid, lat.isprocessed, lat.createtime AS uploadtime,"
+ " perm.canlink, perm.candownload, perm.canedit, perm.canadmin,"
- + " Sum(allv.filesize) AS filesizesum, Count(allv.*) AS versioncount"
+ + " Sum(allv.filesize) AS filesizesum, Count(allv.imageversionid) AS versioncount"
+ " FROM imagebase i"
+ " LEFT JOIN imageversion lat ON (lat.imageversionid = i.latestversionid)"
+ " LEFT JOIN imageversion allv ON (allv.imagebaseid = i.imagebaseid)"