3.6.1 Patch

[Shazz]

http://www.vbulletin.com/forum/showthread.php?t=202390

A bug has been discovered in vBulletin 3.6.1 that can result in data loss when the automatic thread redirect deletion system is used.

Took me 10 secs to update it..
3 secs to download the zip and another 3 to get into the FTP and 4 to replace it

[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.

[Phaedrus]

Thank you for the link! I wouldn't have found out until later...

[Shazz]

Originally Posted by Phaedrus

Thank you for the link! I wouldn't have found out until later...

Hope everything works out