Yes.
A bit unfortunate that bug.
I ran a query to find how many threads records were missing on our forum - fortunately only two atm (I can't patch until tomorrow).
I have daily backups of the thread table so I can easily recover the missing rows.
The query I used, if anyone is interested, is ;
Quote:
SELECT post.threadid, post.username, post.title FROM post LEFT JOIN thread USING (threadid) WHERE thread.threadid IS NULL AND post.dateline > 1158000000 GROUP BY post.threadid ORDER BY post.dateline DESC
|
I had to add the dateline test because I seem to have a quite a few orphaned posts from the past (which is odd .....) and the query took forever without it.