From 651f2747ee704b149ca59bb5dce6ec2ff05cc5b7 Mon Sep 17 00:00:00 2001
From: Sander Saarend <sander@saarend.com>
Date: Mon, 10 Jul 2023 18:20:39 +0300
Subject: [PATCH] Only update site_aggregates for local site (#3516)

---
 src/scheduled_tasks.rs | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/src/scheduled_tasks.rs b/src/scheduled_tasks.rs
index 4d3c936e..a052585e 100644
--- a/src/scheduled_tasks.rs
+++ b/src/scheduled_tasks.rs
@@ -273,7 +273,7 @@ fn active_counts(conn: &mut PgConnection) {
 
   for i in &intervals {
     let update_site_stmt = format!(
-      "update site_aggregates set users_active_{} = (select * from site_aggregates_activity('{}'))",
+      "update site_aggregates set users_active_{} = (select * from site_aggregates_activity('{}')) where site_id = 1",
       i.1, i.0
     );
     match sql_query(update_site_stmt).execute(conn) {
-- 
2.44.1