summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorSimon Rettberg2025-12-04 11:11:43 +0100
committerSimon Rettberg2025-12-04 11:12:33 +0100
commit89812c2ca8c7abc136629642111cba1ed4d3af51 (patch)
treeaad2761273c13b204f2ce27c1e08f15e29024c3a
parent[locations] Fix falsy checks (diff)
downloadslx-admin-89812c2ca8c7abc136629642111cba1ed4d3af51.tar.gz
slx-admin-89812c2ca8c7abc136629642111cba1ed4d3af51.tar.xz
slx-admin-89812c2ca8c7abc136629642111cba1ed4d3af51.zip
[exams] Fix incorrect count() clause
Again found by tests created by Junie AI
-rw-r--r--modules-available/exams/inc/exams.inc.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/modules-available/exams/inc/exams.inc.php b/modules-available/exams/inc/exams.inc.php
index 73278b16..b82526bf 100644
--- a/modules-available/exams/inc/exams.inc.php
+++ b/modules-available/exams/inc/exams.inc.php
@@ -41,8 +41,8 @@ class Exams
{
$res = Database::simpleQuery("SELECT
e.description AS examtitle, e.starttime AS estart, e.endtime AS eend,
- l.displayname AS lecturetitle, l.starttime AS lstart, l.endtime AS lend,
- Count(*) AS machines
+ l.displayname AS lecturetitle, l.starttime AS lstart, l.endtime AS lend,
+ Count(m.machineuuid) AS machines
FROM exams e
LEFT JOIN sat.lecture l USING (lectureid)
LEFT JOIN exams_x_location exl USING (examid)