After Import

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ukliam
    Senior Member
    • Apr 2000
    • 171

    After Import

    After importing from IB2 I had one user missing so I created that user though the control panel and updated the posts but all the posts under that name are still shoing as guest.

    How can I sort this?

    TIA

    Sean
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73976

    #2
    You have to manually re-assign the posts to the new userid using a MySQL query...

    It would be something like:

    update post set userid=XX where username = "Namehere"

    Make sure to backup your database before hand so that if you screw something up, you can restore it.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    • George L
      Former vBulletin Support
      • May 2000
      • 32996
      • 3.8.x

      #3
      whoops what wayne said http://www.vbulletin.com/forum/showt...642#post308642
      Last edited by George L; Tue 18 Jun '02, 7:30pm.
      :: Always Back Up Forum Database + Attachments BEFORE upgrading !
      :: Nginx SPDY SSL - World Flags Demo [video results]
      :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

      Comment

      • ukliam
        Senior Member
        • Apr 2000
        • 171

        #4
        sweet, cheers mate
        Last edited by ukliam; Tue 18 Jun '02, 1:08pm.

        Comment

        • George L
          Former vBulletin Support
          • May 2000
          • 32996
          • 3.8.x

          #5
          Originally posted by ukliam
          sweet, cheers mate
          NP
          :: Always Back Up Forum Database + Attachments BEFORE upgrading !
          :: Nginx SPDY SSL - World Flags Demo [video results]
          :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

          Comment

          • Wayne Luke
            vBulletin Technical Support Lead
            • Aug 2000
            • 73976

            #6
            That would assign all guest posts to this guys new userid. Not sure if you want that.
            Translations provided by Google.

            Wayne Luke
            The Rabid Badger - a vBulletin Cloud demonstration site.
            vBulletin 5 API

            Comment

            • ukliam
              Senior Member
              • Apr 2000
              • 171

              #7
              I did it this way - update post set userid=XX where username = "Namehere"

              That worked fine.

              Thanks Again

              Comment

              • Raz Meister
                Senior Member
                • Jun 2001
                • 1148

                #8
                Don't forget to update your counters!
                Raz - KMC Forums

                Comment

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