Is anyone on here experienced with vBulletin Databases?

Tro Shi

Tro Shi

New member
Sep 9, 2011
426
1
0
NC
I've got a vBulletin website running. The site is several years old, and under old administration the forum crashed. The only database is apparently 'corrupt'. I bought the site, and while there's a live version, there are about 70,000 threads in the old DB that I'd like to merge into the live site.

I've been using a local test machine to test some stuff. Obviously don't want to mess around with the live site (hosted on a VPS). I've used ImpEx to merge the old DB into a sql dump of the live site. It merges, but there are quite a few errors (skips) when importing users. However, on the live site, it shows the correct 'numbers' but all of the threads (when clicked) re-direct to an irrelevant thread. So, none of the threads work. Furthermore, quite a few users aren't liking correctly...
 


So you merged a new/live copy of the database (live) with an old (outdated) copy and are wondering why the references don't match??



Or...

Does your LIVE/new data start where the outdated left off or is it completely new like you made it sound?

Judging by the wrong forum/thread linking after the merge it sounds like the live version is a new forum/database and the ID/references started over.
 
ToddW said:
So you merged a new/live copy of the database (live) with an old (outdated) copy and are wondering why the references don't match??



Or...

Does your LIVE/new data start where the outdated left off or is it completely new like you made it sound?

Judging by the wrong forum/thread linking after the merge it sounds like the live version is a new forum/database and the ID/references started over.
Click to expand...
Thanks a ton for the response!

Here's the story. There was a vBulletin forum. The VPS it was on was deleted, and the old administration had only one local (not on the vps) backup of the site. They didn't seem to want to invest the time to figure out how to get the old Database back, and so they sold the site. However, before selling the site, they started a completely new version of the site. There are a couple thousand posts on the site now. I bought the site, and I want to get the old DB to merge into the new one (that's currently running live).

The live data on the site is completely new, although the forums are the same .

In order to fix it, I've got a (Local) test site set up. I installed vBulletin, and then used ImpEx to merge a dump of the live site. It worked fine. Then I tried to merge the OLD DB, and it didn't work.
 
it sounds like you need to PM BlogHue. I quit looking for anyone else to help me with vBulletin after my first project with him. Guy definitely knows his shit and never flakes out.
 
jorarulit said:
it sounds like you need to PM BlogHue. I quit looking for anyone else to help me with vBulletin after my first project with him. Guy definitely knows his shit and never flakes out.
Click to expand...

I PM'd him, thanks for the advice.
 
Just a quick suggestion... have you tried "Rebuild Thread Information " etc. under Maintenance > Update Counters?
 
I sent the DB to BlogHue because he offered to look at it for me. Hopefully he can point me in the right direction, but I'm still trying to get this all finished asap. If anyone else has words of wisdom that would be very helpful!
 
sounds like your new forum uses userid's/threadid's starting from 1+, rather than from the MAX of the old forum, so when trying to merge users/threads impEx is either assigning new id's to users or threads and not syncing them with the the associated data.

It'd be fairly trivial to fix the old data ready to import.

If you're not worried about the old users, I believe you can import the old threads as "guest" posts.
 
AdamC said:
sounds like your new forum uses userid's/threadid's starting from 1+, rather than from the MAX of the old forum, so when trying to merge users/threads impEx is either assigning new id's to users or threads and not syncing them with the the associated data.

It'd be fairly trivial to fix the old data ready to import.

If you're not worried about the old users, I believe you can import the old threads as "guest" posts.
Click to expand...

I think this could be the problem, but I'm not sure. I told this to my partner who's looking at it!
 
Tro Shi said:
I think this could be the problem, but I'm not sure. I told this to my partner who's looking at it!
Click to expand...

I believe I told you the id / references were off...

People telling you the same thing won't fix your problem ;)
 
You must log in or register to reply here.
Top Bottom
Back