Announcement

Collapse
No announcement yet.

VB 3.6 (initial release) to VB 3.6 - Usergroups

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

  • VB 3.6 (initial release) to VB 3.6 - Usergroups

    I'm trying to import the users from an old board using 3.6 to a new board using 3.6.

    These are the three steps I did:
    Check and update database
    Import usergroup
    Import user (associate users with current users was enabled)

    It shows 1156 users imported in 12 seconds.

    All of the imported users don't appear to be associated with any usergroup. Deleting the old user groups and updating the counters doesn't seem to help. I can however, go in a manually put each user in a group.
    Last edited by matt3830; Sat 26 Aug '06, 9:00am.

  • #2
    Download ImpEx, upload and overwrite :

    impex/systems/vb_36/004.php and try again.
    I wrote ImpEx.

    Blog | Me

    Comment


    • #3
      I think it's automatically choosing the source system. For instance, I have uploaded mybb, vb3 and vb3.6.x. When I click import in my vbulletin admin channel it automatically starts checking the tables with one of the systems (doesn't give me the option to choose which systems I'm importing from).

      Then when I try to import the usergroups, I get this message:
      Code:
      ImpEx Database errormysql error: Invalid SQL: 
                          SELECT fieldname, vbmandatory, defaultvalue, dictionary
                          FROM vbfields
                          WHERE tablename = 'usergroup'
                          AND product='vbulletin' 
                          ORDER BY vbmandatory
                      
      
      mysql error: Unknown column 'product' in 'where clause'
      
      mysql error number: 1054
      
      Date: Saturday 26th of August 2006 02:39:55 PM
      Database: dbname
      MySQL error:

      Comment


      • #4
        I removed all the other systems (leaving just vb 3.6.x) and tried to import the users. It's working better.

        Comment


        • #5
          What happens to duplicate usernames?

          Importing from several forums, I match the users by their email addresses. But what happens if users have different email addresses, but the same username? Does one of the usernames change? Does one username overwrite the other?

          For example, importing from three different forums:
          1st import - jason [email protected]
          2nd import - jason [email protected]
          3rd import - jason [email protected]

          These users have different email addresses, but the same username (jason). What would happen?

          Comment


          • #6
            You haven't deleted the session, the vBfield table needs to be updated.
            I wrote ImpEx.

            Blog | Me

            Comment


            • #7
              Originally posted by matt3830 View Post
              Importing from several forums, I match the users by their email addresses. But what happens if users have different email addresses, but the same username? Does one of the usernames change? Does one username overwrite the other?

              For example, importing from three different forums:
              1st import - jason [email protected]
              2nd import - jason [email protected]
              3rd import - jason [email protected]

              These users have different email addresses, but the same username (jason). What would happen?
              The username is prepended with "imported_"
              I wrote ImpEx.

              Blog | Me

              Comment


              • #8
                What happens with the third username?

                jason
                imported_jason
                imported_imported_jason?

                Comment


                • #9
                  Currently its just

                  jason
                  imported_jason
                  imported_jason

                  There was plans for :

                  jason
                  imported00_jason
                  imported01_jason
                  imported02_jason
                  ....

                  Though after review, duplicate usernames were quite rare, not all systems enforce it like vBulletin, though for the vast majority of imports happening, it wasn't an issue, so the one "imported_" was ok.
                  I wrote ImpEx.

                  Blog | Me

                  Comment


                  • #10
                    There might be a few duplicates in my system. Will this cause any problems? Is there an easy way to identify the duplicates?

                    Comment


                    • #11
                      Every duplicate will have imported_ infront of their name, find them in the admincp and merge them there, you can merge users on email in the user module and you can find them all afterwards with this SQL :

                      Code:
                      SELECT userid, username FROM user WHERE username LIKE 'imported_%';
                      I wrote ImpEx.

                      Blog | Me

                      Comment

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