If this query:
SELECT count( DISTINCT TOPIC_ID )
FROM ubbt_POSTS
WHERE TOPIC_ID NOT
IN (
SELECT TOPIC_ID
FROM ubbt_TOPICS
)
Gives you a result >0 you have posts in your database that are not referenced anymore by any existing topic. Attached scripts will salvage those topics to a predefined forum (YOU HAVE TO SET THIS MANUALLY IN THE SCRIPT BEFORE USING IT).
This script and above query require MySQL >= v4.10
Enjoy your cleaned up database
