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,21 @@
       `);
     },
   ],
+  [
+    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());