Changeset abdcf33 in Klonkt for src/routes

Timestamp:

06/27/2026 09:46:03 PM (2 months ago)

Author:

Robin Genis <roboburr@…>

Branches:

main

Children:

d2b7247

Parents:

3746f6a

Message:

chore(cleanup): remove the dead comments_moderation_mode column + handling

Native comments are gone; this column was set but never read. Removed from the site
INSERT (admin-sites create) and UPDATE (save) in lockstep (column + placeholder + value),
from ensurePrimarySite's seed INSERT, the ensureColumn in database.js, and the 3 unused
i18n keys (asite.comment_moderation / moderation_trust / moderation_moderate, x3 langs).
No DROP — the column stays in existing DBs as harmless dead data. require_login_to_comment
is kept (still used by PermissionsService).

File:

• src/routes/admin-sites.js (modified) (5 diffs)

src/routes/admin-sites.js

@@ -222 +222 @@
       language, palette, accent, profile_photo,
       is_public, robots_index, require_login_to_comment, enable_audio_player,
-      feed_view_default, comments_moderation_mode
-    ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
+      feed_view_default
+    ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
   `).run(
     siteId, slug,
@@ -239 +239 @@
     (f.enable_audio_player !== undefined ? (f.enable_audio_player ? 1 : 0) : 1),
     f.feed_view_default === 'timeline' ? 'timeline' : 'grid',
-    f.comments_moderation_mode === 'trust' ? 'trust' : 'moderate',
   );
 
@@ -280 +279 @@
 
   const f = req.body;
-  const moderationMode = f.comments_moderation_mode === 'moderate' ? 'moderate' : 'trust';
   const feedViewDef = f.feed_view_default === 'grid' ? 'grid' : 'timeline';
   const profileLinksJson = buildProfileLinks(f);
@@ -300 +298 @@
       is_public = ?, robots_index = ?, require_login_to_comment = ?,
       enable_audio_player = ?,
-      comments_moderation_mode = ?,
       feed_view_default = ?, feed_view_switch = ?,
       show_search = ?, show_archive_link = ?,
@@ -321 +318 @@
     f.require_login_to_comment ? 1 : 0,
     f.enable_audio_player ? 1 : 0,
-    moderationMode,
     feedViewDef,
     f.feed_view_switch ? 1 : 0,