From da28cda496ffee4997b27bc5e3d3bf49c8cf0ee2 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Roland=20H=C3=A4der?= <roland@mxchange.org>
Date: Fri, 25 Aug 2023 21:41:11 +0200
Subject: [PATCH] Continued: - exclude NULL values for detection_mode

---
 nodeinfo.sh | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/nodeinfo.sh b/nodeinfo.sh
index cdeaa8f..16baaee 100755
--- a/nodeinfo.sh
+++ b/nodeinfo.sh
@@ -26,7 +26,7 @@ then
 	MODE="detection"
 elif [ "$1" = "--no-auto" ]
 then
-	DOMAINS=$(sqlite3 blocks.db "SELECT domain FROM instances WHERE detection_mode != 'AUTO_DISCOVERY' ORDER BY last_updated ASC;")
+	DOMAINS=$(sqlite3 blocks.db "SELECT domain FROM instances WHERE detection_mode IS NOT NULL AND detection_mode != 'AUTO_DISCOVERY' ORDER BY last_updated ASC;")
 	MODE="noauto"
 elif [ "$1" = "--no-auto2" ]
 then
-- 
2.39.5