log of merged user while import?

[efendi]

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

 

[AndyB]

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

 

[efendi]

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

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

thanks

 

[Jake Bunce]

unfortunately i marked auto merge while the import and now i have a problem with user and their login

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

 

[efendi]

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

i know about this way. but i don't know:

• how many user merged and
• what's about the postings

thank you and greetings

 

[Jake Bunce]

Run this db query:

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:

SELECT COUNT(DISTINCT new_id) AS newCount, COUNT(*) AS oldCount
FROM final_archived_import_log
WHERE content_type = 'user';