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

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

Jake Bunce

XenForo moderator
Staff member
#6
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';