From af2c309ffecdbbcc46145811a4ab4c8baf401ce2 Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@gmail.com>
Date: Sun, 13 Oct 2024 10:28:04 +0200
Subject: [PATCH] www/dbq/dbq.php

---
 etc/dbq/data.php | 2 +-
 www/dbq/dbq.php  | 1 -
 2 files changed, 1 insertion(+), 2 deletions(-)

diff --git a/etc/dbq/data.php b/etc/dbq/data.php
index 75101c65..c622b29b 100644
--- a/etc/dbq/data.php
+++ b/etc/dbq/data.php
@@ -13,7 +13,7 @@ $DBQ['data'] = [
 						,max(updated) as last_updated
 						,min(updated) as first_updated
 						,(SELECT count(val) FROM host_info path WHERE path.host=hi.host AND path.key LIKE '%.path') as repos
-						,max((SELECT DISTINCT val FROM host_info ex WHERE ex.host=hi.host AND ex.key LIKE '%.exit_code' LIMIT 1)) as exit
+						,(SELECT max(CAST(val as INTEGER)) FROM host_info ex WHERE ex.host=hi.host AND ex.key LIKE '%.exit_code') as exit
 						 FROM host_info hi
 						 GROUP BY host ORDER BY host
 "),
diff --git a/www/dbq/dbq.php b/www/dbq/dbq.php
index 9834a0de..0e8dc26a 100644
--- a/www/dbq/dbq.php
+++ b/www/dbq/dbq.php
@@ -418,7 +418,6 @@ class DbQ extends nb {
 
 			$this->db->__construct($connect);
 			$this->db->connect();
-# NB 11.06.18 			return $this->db;
 		} else {
 
 			// Re use
-- 
2.47.3