Find and move vBulletin orphan threads

[zylstra]

Here are some useful MySQL queries if you want to find and move your orphan threads to a forum where you can moderate them further.

Find:
SELECT thread.*
FROM thread
LEFT JOIN
forum as forum
ON (forum.forumid = thread.forumid)
WHERE ISNULL(forum.forumid)


Move to forum 490:
UPDATE thread
LEFT JOIN
forum
ON forum.forumid = thread.forumid
SET thread.forumid = 490
WHERE ISNULL(forum.forumid)



Or, if you would like to move threads that exist in forums that are disallowed to contain threads:

Find:
SELECT thread.threadid, thread.forumid, forum.title, thread.visible
FROM thread AS thread
LEFT JOIN
forum as forum
ON (forum.forumid = thread.forumid)
WHERE NOT (forum.options & 4)



Move from orphan status to forum number 491:
UPDATE thread
LEFT JOIN
forum
ON forum.forumid = thread.forumid
SET thread.forumid = 491
WHERE NOT (forum.options & 4)