Changeset 682d504 in Klonkt

Timestamp:

06/16/2026 06:49:32 PM (3 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

62b899d

Parents:

1be21ba

Message:

Circle: remove cached posts on outdated + exclude outdated sites from header

An outdated source (proto mismatch) kept its previously cached remote_posts
→ they remained (buggy) visible in the feed. markOutdated now removes those
posts. The header only shows active circle links (outdated/error are
excluded).

Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@…>

Location:

src

Files:

• routes/circle.js (modified) (1 diff)
• services/CircleService.js (modified) (1 diff)

src/routes/circle.js

@@ -58 +58 @@
   });
 
-  // Sites in de cirkel (alleen succesvol gesyncte = proto-compatibel) — voor de
-  // grafische header met avatars.
-  const sites = db.prepare('SELECT name, url, avatar FROM remote_actors ORDER BY name')
-    .all()
+  // Sites in de cirkel — alleen actieve links (outdated/error vallen weg, net als
+  // hun posts). Voor de grafische header met avatars.
+  const sites = db.prepare(`
+    SELECT a.name, a.url, a.avatar
+    FROM remote_actors a
+    JOIN circle_links l ON l.remote_actor_id = a.id
+    WHERE l.status = 'active'
+    ORDER BY a.name
+  `).all()
     .map((s) => ({
       name: s.name || 'Onbekend',

src/services/CircleService.js

@@ -31 +31 @@
 // melding van kan maken i.p.v. een generieke fout.
 function markOutdated(link, msg) {
+  // Gecachte posts van deze bron weghalen: we kunnen ze niet meer verifiëren of
+  // verversen (proto-mismatch), dus ze horen niet meer in de cirkel-feed.
+  if (link.remote_actor_id) {
+    try { db.prepare('DELETE FROM remote_posts WHERE actor_id = ?').run(link.remote_actor_id); } catch {}
+  }
   db.prepare("UPDATE circle_links SET status='outdated', last_error=?, last_synced=CURRENT_TIMESTAMP WHERE id=?")
     .run(String(msg).slice(0, 300), link.id);