MyBB Community Forums

I merged our forum from vB not too long ago, and a member reported an error when visiting the page below. It looks like some blank thread ideas got into the SQL, but I'm not positive. We used version 1.4 Beta 5 of the merge system. Any ideas?

http://tpforums.org/forum/forumdisplay.p...&order=asc

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',,,,4806,4371,4282,3910,4859,5069,5292,5718,5719,3941,4391,4749,5037)' at line 1
Query:
    SELECT tid,uid FROM posts WHERE uid='417' AND tid IN (5702,4403,,,,,,4806,4371,4282,3910,4859,5069,5292,5718,5719,3941,4391,4749,5037) 

I had the same problem - it is not a mybb problem, it is just garbage from the "old" vb forum.
There were Threads on the vb forums which had no posts assigned to it. After convertig this to mybb you get this error message in mybb.

Locate the Threads and delete them from the database.

Thanks for the info Nifty. The following query worked for me:

DELETE FROM threads WHERE tid NOT IN (SELECT DISTINCT tid FROM posts)