summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorIrina Gómez <irinagomez@us.es>2021-02-18 09:09:31 +0100
committerIrina Gómez <irinagomez@us.es>2021-02-18 09:09:31 +0100
commit63a84b0236bfad36666946976dccc99096193541 (patch)
treecb5d9d4aadfddd59c3114dda5505182f6276afb6
parente55d6c26f37c7ce83a48c67105d136283795a856 (diff)
#1031 Admin console: in the SQL query the ambiguity in the field 'inremotepc' is removed.
(Reported by Ramón Gómez - US).
-rw-r--r--admin/WebConsole/principal/estadisticas.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/admin/WebConsole/principal/estadisticas.php b/admin/WebConsole/principal/estadisticas.php
index ced1cc58..b0e12c86 100644
--- a/admin/WebConsole/principal/estadisticas.php
+++ b/admin/WebConsole/principal/estadisticas.php
@@ -74,7 +74,7 @@ SELECT *
FROM (SELECT nombrecentro AS ou,
COUNT(DISTINCT idaula) AS labs,
COUNT(DISTINCT IF(idordprofesor > 0, idaula, NULL)) AS hasprof,
- COUNT(DISTINCT IF(inremotepc = 1, idaula, NULL)) AS remotelab,
+ COUNT(DISTINCT IF(aulas.inremotepc = 1, idaula, NULL)) AS remotelab,
COUNT(idordenador) AS clients,
COUNT(numserie) AS hasconfig,
COUNT(IF(idrepositorio > 0, 1, NULL)) AS hasrepo,