Announcement

Collapse
No announcement yet.

vBulletin Moved - Signatures Lost / Members Renumbered

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • vBulletin Moved - Signatures Lost / Members Renumbered

    A forum was moved to a new server. But the old posts do not have the signatures. The old posts have n/a instead of the number of posts. And the reputation was lost. And they do not show a signature.

    All the new posts have the signatures and have the correct number of posts. When you search for a specific user, you only see posts from the day of the cutover. However, the all the posts are being seen in all the forums. I have done the 'Rebuild Thread Information', 'Rebuild Forum Information' and a few others.

    The thing I did see is I used to have ID 519, now I have 25473.

    Any direction at this point would be great. I know it is vBulletin 3.6.8 Patch Level 2

  • #2
    Sounds like you ran the user import module of ImpEx multiple times. This is the only thing that would account for new member IDs being generated. Normally when you move from one server to another, there is no need to run ImpEx for any reason.

    To restore this, you would have to restore your backup from before the move or manually change User IDs in the database.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.

    Comment


    • #3
      how exactly did you move?

      Comment


      • #4
        I did see that ImpEx were listed on all the "old" users / moderators / admins Wayne

        Zachery - I am actually posting for the vBulletin License holder (David). I (Corey Bryant) used to have an honorary membership since I was administer / moderator on a lot of vBulletin forums but that seems to have changed.

        Anyway, in the event that ImpEx was ran - what needs to be done to fix it? I think he has a complete back up of the database before the move on / about 9 Mar

        Comment


        • #5
          Restore the backup and use it, optherwise theres nothing.

          Comment


          • #6
            Thanks Zachary - I'll let him know and see what we can do

            Comment


            • #7
              I have also asked him to see if he can maybe copy the vBulletin code to another folder / domain first to test that DB before we make the change. I would just like to know the old one will work properly. I am hoping that is "ok" in the vBulletin eyes. I know they made a few changes on their licensing, etc

              Comment


              • #8
                One more idea...

                Do you think it is possible to just run a query where we search for one user id and replace it with the one we want to keep? I was thinking and I thought it just might work.

                Comment


                • #9
                  I don't know of any way to make that work. Sorry.
                  Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                  Change CKEditor Colors to Match Style (for 4.1.4 and above)

                  Steve Machol Photography


                  Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                  Comment


                  • #10
                    We have contact Houston!!

                    OK, we got it!! I am posting this just in case anyone else has had this problem and is looking for a solution. It is not the easiest one in the world, but it does work. In the event that you have 2 user id's per person and the board is only showing results and signatures on the new post with the new id, you will need to run this script.

                    UPDATE `forum`.`dbopost` SET `userid` = '31582' WHERE `dbopost`.`userid` ='6644';

                    the first user id is the newest id, and the second userid is the old one.

                    I have used this on my board and it works perfect.

                    Thanks for all the input on this matter.

                    Dave

                    Comment


                    • #11
                      You will also need to update the relevant userid in every other table that has a userid field.
                      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                      Change CKEditor Colors to Match Style (for 4.1.4 and above)

                      Steve Machol Photography


                      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                      Comment

                      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                      Working...
                      X