Anyone know of a SQL script I can use?

[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!

[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.

[SBoards]

thanks for the suggestion!

the problem I'm having is that my thread table still has reply counts. it's the post table that is missing the info associated with those reply counts.

[borbole]

Originally Posted by SBoards

thanks for the suggestion!

the problem I'm having is that my thread table still has reply counts. it's the post table that is missing the info associated with those reply counts.

The reply count is not defined at the post table but the thread table. But you can also get the title or the id''s oth those threads that you want deleted and delete them directly from the db.

One more thing, a bit off topic, but I think it is best to upgrade your forum to the latest version as there are several known security issues from the version you are having.

[SBoards]

that's the problem I'm having. the thread table thinks there's replies because that is where the reply count is defined. this causes me to have no idea which threads I want to delete due to a lack of corresponding posts in the post table.

If you look at this thread for example... the opening post isn't even there. But if you back out to the forum, and locate the thread, it claims to have four replies. I can't figure out how to define the threads that don't actually, physically have posts in them.

I agree... and I would love to upgrade to the latest and greatest, but I'm reading nothing but bad things about 4.0.5. I'm hoping they'll soon release a version that more people are happy with.

[borbole]

Originally Posted by SBoards

that's the problem I'm having. the thread table thinks there's replies because that is where the reply count is defined. this causes me to have no idea which threads I want to delete due to a lack of corresponding posts in the post table.

If you look at this thread for example... the opening post isn't even there. But if you back out to the forum, and locate the thread, it claims to have four replies. I can't figure out how to define the threads that don't actually, physically have posts in them.

I agree... and I would love to upgrade to the latest and greatest, but I'm reading nothing but bad things about 4.0.5. I'm hoping they'll soon release a version that more people are happy with.

Can you check the db and see if that threads contains the posts there? If it does, can you go to your Apc->Maintenance->Update Counters-> and run Rebuild Thread Information and Rebuild Forum Information?

Don''t believe all you read. There is nothing wrong with vb 4.0.5.

[SBoards]

'tis true... I read a lot of silly comments from people who don't know what they're talking about in threads about mods for vb. I suppose I should apply the same logic to threads about actual vb. lol

I've tried that, and it didn't update my thread replies field. I was surprised to see that it didn't, since the point of that is to correct these types of issues.