[borbole]

Originally Posted by SBoards

Hi folks,

I am running vbulletin 4.0.3. A few months ago, my upgrade from 4.0.1 produced bad results. I then restored my database from backup, but my backup apparently wasn't complete. Unfortunately, I had no other good backups.

I was able to salvage my users, which was a relief. But, losing thousands of posts definitely caused me to learn my lesson.

Anyhoo... I now have a crapload of threads which think they have posts in them, but they don't. Does anyone know of a SQL script I can use to delete all the postless threads? I can't mass-prune threads with zero posts, because as I said... the threads still think they have posts in them.

Any help would be appreciated. Thanks!

Do you want to delete all threads with 0 replies? If so, run this query at phpmyadmin in the cp of your host:

DELETE FROM thread WHERE replycount = 0;

If your db tables use a prefix, append it to the table name when running the query. Hope it helps.