From 63a84b0236bfad36666946976dccc99096193541 Mon Sep 17 00:00:00 2001 From: Irina Gómez Date: Thu, 18 Feb 2021 09:09:31 +0100 Subject: #1031 Admin console: in the SQL query the ambiguity in the field 'inremotepc' is removed. (Reported by Ramón Gómez - US). MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- admin/WebConsole/principal/estadisticas.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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, -- cgit v1.2.3-18-g5258