Announcement

Collapse
No announcement yet.

After Import

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

  • 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

  • #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 customization and demonstration site.
    vBulletin 5 Documentation - Updated every Friday. Report issues here.
    vBulletin 5 API - Full / Mobile
    I am not currently available for vB Messenger Chats.

    Comment


    • #3
      whoops what wayne said http://www.vbulletin.com/forum/showt...642#post308642
      Last edited by George L; Tue 18th 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


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

        Comment


        • #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


          • #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 customization and demonstration site.
            vBulletin 5 Documentation - Updated every Friday. Report issues here.
            vBulletin 5 API - Full / Mobile
            I am not currently available for vB Messenger Chats.

            Comment


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

              That worked fine.

              Thanks Again

              Comment


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

                Comment

                Loading...
                Working...
                X