Forum Corrupted Database = Many Issues: Only one to discuss in this thread
 

I've got the rest of them under control, but I may need assistance with this one.

Long story short... I messed up and wiped a very large amount of posts out of our database without having a good backup.

I know, I know... the basics of upgrading should have made me check, and double-check my backup, but I didn't.

I ended up reinstalling vB from scratch, and used impex to import as much info as I could from the old database. So here's my issue:

I have a huge amount of threads which think they have posts in them, but they don't. I want to prune all threads that have been affected by this, but I can't figure out how I need to specify a mass-prune. Since these threads think they have posts in them, I can't prune threads with 0 posts.

I'd rather not have to delete over 50,000 threads individually. Any ideas?

http://www.thescoreboards.com/forums/forum.php