Tom reported some threads were showing as multi-page, even though their posts were missing (as a result of the mishap described above).
A simple MySQL query can get me the list of post IDs which exist in the phpbb_posts table but not in the phpbb_posts_text table:
Code:
mysql> SELECT a.post_id,a.topic_id FROM phpbb_posts AS a LEFT JOIN phpbb_posts_text AS b ON a.post_id = b.post_id WHERE b.post_id IS NULL;
+---------+----------+
| post_id | topic_id |
+---------+----------+
| 47427 | 5230 |
| 47428 | 5229 |
| 47429 | 5217 |
| 47430 | 5232 |
| 47431 | 5217 |
| 47432 | 5217 |
| 47433 | 5230 |
+---------+----------+
7 rows in set (0.00 sec)
And then to determine what the threads were which were affected:
Code:
mysql> SELECT topic_id,topic_title FROM phpbb_topics WHERE topic_id=5230 OR topic_id=5229 OR topic_id=5217 OR topic_id=5232;
+----------+----------------------------------+
| topic_id | topic_title |
+----------+----------------------------------+
| 5217 | GemVenture |
| 5229 | NESICIDE v? screenshots |
| 5230 | Map data interleaving, worth it? |
| 5232 | converting problem |
+----------+----------------------------------+
4 rows in set (0.01 sec)
So there you have it -- those were the 4 threads which lost some posts.
I've since deleted all of the post_ids shown in the above list.