Missing Post Broken Threads
To find threads where the "first post" is missing from the mybb_posts table, you need to compare the firstpost ID recorded in the mybb_threads table against the actual records in the mybb_posts table. When MyBB creates a thread, it stores the ID of the starting post in mybb_threads.firstpost . If that post was deleted or failed to write during a database operation, the thread becomes "broken." SQL Query to List Broken Threads Run this query in your SQL manager (like phpMyAdmin) to find all threads where the associated first post does not exist: SQL SELECT t.tid, t.subject, t.firstpost, t.dateline FROM mybb_threads t LEFT JOIN mybb_posts p ON t.firstpost = p.pid WHERE p.pid IS NULL ; Explanation of the Query LEFT JOIN : This looks at every row in your threads table and tries to find a matching ID in the posts table. WHERE p.pid IS NULL : This filters the results to show only the threads where the matching post record was not found. t.tid & t.subje...