From bc0d69a2fccb257b20436a915287e2406a542cd8 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Fri, 10 Mar 2023 14:51:28 +0100
Subject: [syslog] Fix syntax error in SQL

---
 modules-available/syslog/page.inc.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/modules-available/syslog/page.inc.php b/modules-available/syslog/page.inc.php
index cd1c9d4d..023dd965 100644
--- a/modules-available/syslog/page.inc.php
+++ b/modules-available/syslog/page.inc.php
@@ -100,7 +100,7 @@ class Page_SysLog extends Page
 		$joinClause = "";
 		if (!in_array(0, $allowedLocations)) {
 			$joinClause = "INNER JOIN machine USING (machineuuid)";
-			$whereClause .= ' locationid IN (:allowedLocations)';
+			$whereClause .= ' AND locationid IN (:allowedLocations)';
 			$qArgs['allowedLocations'] = $allowedLocations;
 		}
 
-- 
cgit v1.2.3-55-g7522