1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

log of merged user while import?

Discussion in 'Installation, Upgrade, and Import Support' started by efendi, May 15, 2013.

  1. efendi

    efendi Member

    hello,

    is there a log of merged user while import from vB 3?
    unfortunately i marked auto merge while the import and now i have a problem with user and their login :)

    thank you
     
  2. AndyB

    AndyB Well-Known Member

    There is a log table created. Check the database using phpmyadmin.
     
  3. efendi

    efendi Member

    of course, i checked the database, but i see only a lot of numbers.

    thanks
     

    Attached Files:

    • db.png
      db.png
      File size:
      8.9 KB
      Views:
      7
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    If they don't know which username survived the merge then they can also login using their email address.
     
  5. efendi

    efendi Member

    i know about this way. but i don't know:
    • how many user merged and
    • what's about the postings

    thank you and greetings
     
  6. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Run this db query:

    Code:
    SELECT COUNT(DISTINCT new_id) AS newCount, COUNT(*) AS oldCount
    FROM xf_import_log
    WHERE content_type = 'user';
    
    That will return the old and new user counts. The difference between the two will be the number of merged users.

    edit - your log table has a different name, so use this:

    Code:
    SELECT COUNT(DISTINCT new_id) AS newCount, COUNT(*) AS oldCount
    FROM final_archived_import_log
    WHERE content_type = 'user';
    
     
    efendi likes this.

Share This Page