Announcement

Collapse
No announcement yet.

one problem after import

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

  • one problem after import

    Hello Everyone

    After importing/merging another site with mine

    I seem to have a problem

    In this thread http://www.tech-unity.com/forums/showthread.php?p=19906
    Actually all users created by this user from the old site dont have a user id so I cant merge them with the correct user.

    Yes, I did the associate the user, and the post count got updated, you can see the user its supposed to be here
    http://www.tech-unity.com/forums/member.php?u=225

    but for some reason this username did not get deleted and posts moved.

    Can someone help me with this.

    I'm thinking an SQL query that looks for this username inside of posts and threads and modifys the results with the correct username and or userid.

    But truthfully I haven't got a clue how to do this.

    This does seem to be the only user out of 100 or so with this problem for some crazy reason

    The software that was merged was SMF http://www.simplemachines.org/ if that helps
    My Website
    My vBulletin Installation

  • #2
    So you had an origional site, that was vBulletin already up and running.

    Then, you imported a simple machines forum into it ?

    Yes, this can be done, though you'll have to mod the impex code to merge on email address/username.

    Just ensuring what is going on first.
    I wrote ImpEx.

    Blog | Me

    Comment


    • #3
      Yes, Existing vbulletin site, and merged in a Simple Machines forum.

      Everything seemed to go perfectly except this one user.

      Other then the one, email addresses and everything associated perfectly.

      So, I'm curious, is there a quick little script I can run, or a SQL query, that will change the posts and threads for this one non-user account to the correct account.

      Basically a search and replace of some type

      Thanks in advance for any help on this Jerry
      My Website
      My vBulletin Installation

      Comment


      • #4
        All the posts should have userid 0 to come up as a guest post as they are, so its going to be SQL to link them to your user.

        Code:
        UPDATE post SET userid = 5 WHERE userid = 0
        Where your user id is 5, so set that to what ever yours is.
        I wrote ImpEx.

        Blog | Me

        Comment


        • #5
          Yes, they are set to 0

          Thank you very much
          My Website
          My vBulletin Installation

          Comment


          • #6
            well

            In showthread it worked perfectly
            http://www.tech-unity.com/forums/showthread.php?t=4389

            but, in forumdisplay it still shows the wrong user
            http://www.tech-unity.com/forums/forumdisplay.php?f=193

            I figured out with what you gave me, that I could change it a little
            from what you gave me to this
            Code:
             UPDATE thread SET postuserid = 225 WHERE postuserid = 0
            and now when you click on that wrong name, it goes to the correct profile, Yeah, I'm getting there

            what the heck, lets try one more,

            I thought, doing this would work
            Code:
             UPDATE thread SET postusername = LadyNred WHERE postusername = imported_LadyNred
            But that didn't work

            any ideas?
            My Website
            My vBulletin Installation

            Comment


            • #7
              Well I did say :

              Where your user id is 5, so set that to what ever yours is.
              Using 5 was just an example.

              Its not going to work now as all the posts what were set to 0 would of been set to 5, so when you changed the SQL and tried to set all the 0 posts to 225, there wern't any as they were all set to 5.

              How about re-doing the post import then running :

              Code:
               UPDATE thread SET postuserid = 225 WHERE postuserid = 0
              I wrote ImpEx.

              Blog | Me

              Comment

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