diff --git a/keyserver/src/database/migration-config.js b/keyserver/src/database/migration-config.js
--- a/keyserver/src/database/migration-config.js
+++ b/keyserver/src/database/migration-config.js
@@ -499,6 +499,19 @@
       `);
     },
   ],
+  [
+    43,
+    () =>
+      dbQuery(SQL`
+      UPDATE threads
+      SET pinned_count = (
+        SELECT COUNT(*) 
+        FROM messages 
+        WHERE messages.thread = threads.id 
+          AND messages.pinned = 1
+      )
+    `),
+  ],
 ]);
 const newDatabaseVersion: number = Math.max(...migrations.keys());