3.6.1 Patch

[Paul M]

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 ;

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.