post table and thread table question

[Rastus]

As I have upgraded over time, first from phpbb to Vbulletin and then later versions of Vbulletin, I have noticed some posts from the early years are missing in my forum. I've looked in the DB and I can see all posts from post #1 in the post table. However the thread table begins with threadid 4307. Is there anyway to fix this so all post will show up, or what would be a way to fix this so I can have all the posts back in the forum? my current install of Vbulletin is 3.6.8.


one thought I had and was suggested to post here is

"what about writing a query or to add those threadid's back into the DB? Would that fix it or crash the DB? I can setup my test site and try it, but if you know offhand it would save me the time and trouble of testing it."

any thoughts on this and or suggestions on how to write the proper query?

thanks
Kenny

[Dismounted]

Admin CP > Forums & Moderators > Forum Manager > Edit Forum > Thread Cut-Off Time > Beginning

[Rastus]

in 3.6.8 it shows "Default View Age (Default date cut-off for thread display)" and that is already set to "show all threads"

the post table and the thread table in the DB do not match, the post table starts at 1 and the thread table starts at 4307. I'm trying to add 1-4306 back to the thread table.

thanks
Kenny

[Lynne]

If someone deleted all those threads, then they are just gone. When you look at the posts table, are some of the posts associated with threadids that are less than 4307? I wonder if you can write a query to just put all the 'stranded' posts into some 'catchall' thread.

[Rastus]

the threads were not deleted. Well, I say there were not deleted, the threadid's are no longer there. I am trying to do a query to add the thread id's from 4306 down to 1 back. Don't know if I will be successful or not. I've got two pretty good Sql Admins I am waiting on to see if they can help me out, only time will tell. It's not a real major issue, but I would like to have those posts \ threads back on the forum. Lots of good stuff in there, plus the sentimental value. at least I still have the posts.

A catchall section is not really something I would want. good idea, tho.