From 8b3f623d29e7228115441d4824e2893a1585fe15 Mon Sep 17 00:00:00 2001 From: Alexandre Alapetite Date: Sat, 15 Apr 2017 23:42:10 +0200 Subject: [PATCH] ANY_VALUE in mod/admin The query was not standard, not deterministic, and was not doing what its description says. The patch makes it more standard and a bit more deterministic. The returned protocol type is still undeterministic. --- mod/admin.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/mod/admin.php b/mod/admin.php index 2652b33c12..093f7c8012 100644 --- a/mod/admin.php +++ b/mod/admin.php @@ -290,7 +290,8 @@ function admin_page_federation(App $a) { foreach ($platforms as $p) { // get a total count for the platform, the name and version of the // highest version and the protocol tpe - $c = qu('SELECT COUNT(*) AS `total`, `platform`, `network`, `version` FROM `gserver` + $c = qu('SELECT COUNT(*) AS `total`, ANY_VALUE(`platform`), + ANY_VALUE(`network`), MAX(`version`) FROM `gserver` WHERE `platform` LIKE "%s" AND `last_contact` >= `last_failure` ORDER BY `version` ASC;', $p); $total = $total + $c[0]['total']; -- 2.39.5