User Import problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • RussDMC
    New Member
    • Oct 2006
    • 4
    • 3.6.x

    User Import problem

    Hi,
    My company is taking over a forum community from another company. We have received the user list from the previous company but not the post content from the other forum.
    I have successfully installed the forum software and have imported all the tables I "thought" we needed for the user data. I received the following tables:
    user
    useractivation
    userban
    userfield
    usergroup
    usergroupleader
    usergrouprequest
    usernote
    userpromotion
    usertextfield
    usertitle
    I am able to login and manage users, and have removed the Administrator accounts (leaving my new Admin acct).

    However I am having a database error now when new users try to register.

    Database error in vBulletin 3.6.2:

    Invalid SQL:
    INSERT INTO wnforum_userfield
    (userid)
    VALUES
    (2331);

    MySQL Error : Duplicate entry '2331' for key 1 Error Number : 1062
    Date : Tuesday, October 31st 2006 @ 10:42:30 AM
    Script : http://forum.worldniche.com/register.php?do=addmember
    Referrer : http://forum.worldniche.com/register.php?do=register
    IP Address : 206.116.62.59
    Username : russtesterman
    Classname : vb_database

    Are there additional data tables I need related to users in addition to the tables I have already imported?

    Thanks,
    Russ C
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    Do the following tables have the same number of rows?

    user
    userfiled
    usertextfield
    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

    • RussDMC
      New Member
      • Oct 2006
      • 4
      • 3.6.x

      #3
      Hi,
      I checked and the tables have the following counts:
      user 2326
      userfield 2333
      usertextfield 2333


      Any thoughts on how to re-index these?
      Thanks,

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        That's the likely problem. These three table need to have the same number of rows and users. I suggest looking at the user table and removing and userids that do not appear in the other two tables.
        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

        • RussDMC
          New Member
          • Oct 2006
          • 4
          • 3.6.x

          #5
          Thanks very much, I will give that a shot.

          Comment

          • RussDMC
            New Member
            • Oct 2006
            • 4
            • 3.6.x

            #6
            Yup, tht was the problem. We received the tables in two dumps, there were 7 new signups that were in the other two tables and not in the users table.

            Thanks very much for your help!

            Comment

            • Steve Machol
              Former Customer Support Manager
              • Jul 2000
              • 154488

              #7
              Glad you got it working.
              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...