1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Is anyone on here experienced with vBulletin Databases?

Discussion in 'General Scripting Chat' started by Troshi, Aug 8, 2013.

  1. Troshi

    Troshi Senior Member

    Joined:
    Aug 19, 2011
    Messages:
    862
    Likes Received:
    105
    Occupation:
    Your job
    Location:
    Where you live
    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...
     
  2. DarkPixel

    DarkPixel Jr. VIP Jr. VIP Premium Member

    Joined:
    Oct 4, 2011
    Messages:
    1,328
    Likes Received:
    1,239
    Location:
    ↓↓↓↓
    Home Page:
    Maybe you are using a different vBulletin version, that isn't compatible with the old DB structure.
     
  3. cryptons

    cryptons Jr. VIP Jr. VIP Premium Member

    Joined:
    Jun 12, 2013
    Messages:
    1,226
    Likes Received:
    447
    Occupation:
    Developer,social marketer
    which version do u use?
     
  4. Troshi

    Troshi Senior Member

    Joined:
    Aug 19, 2011
    Messages:
    862
    Likes Received:
    105
    Occupation:
    Your job
    Location:
    Where you live
    I'm almost positive its the same version. The old DB says in the settings=templateversion (Sql table) that its 4.2.0 and the site DB I'm merging it to is 4.2.0
     
  5. kingbrend

    kingbrend Regular Member Premium Member

    Joined:
    Feb 12, 2008
    Messages:
    427
    Likes Received:
    113
    Home Page:
    Probably best to go to vBulletin.org and ask for assistance.. or vBulletin.com which you can hire someone to fix the site for you.
     
  6. bartosimpsonio

    bartosimpsonio Jr. VIP Jr. VIP Premium Member

    Joined:
    Mar 21, 2013
    Messages:
    8,862
    Likes Received:
    7,467
    Occupation:
    ZLinky2Buy SEO Services
    Location:
    ⇩⇩⇩⇩⇩⇩⇩⇩⇩⇩⇩⇩
    Home Page:
    You can probably start a new installation and "import" the old one. Downtime is just the time it takes to import the data.
     
  7. Troshi

    Troshi Senior Member

    Joined:
    Aug 19, 2011
    Messages:
    862
    Likes Received:
    105
    Occupation:
    Your job
    Location:
    Where you live
    I've done this, and haven't really gotten any help... I'd rather not pay for someone to fix it, as I'd like to know how to do it..

    As I said in the OP, I have a local test machine that I'm trying it on before I try it on the real site.. for obvious reasons, because the Import has not worked on the local test machine. As I also said in the OP, the problem is that all the links are broken and they link to incorrect threads.
     
  8. mteun

    mteun Newbie

    Joined:
    Jul 12, 2013
    Messages:
    19
    Likes Received:
    1
    It's better for you to get support directly from vBulletin.org.