VB 3.6 (initial release) to VB 3.6 - Usergroups

[matt3830]

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.

[Jerry]

Download ImpEx, upload and overwrite :

impex/systems/vb_36/004.php and try again.

[matt3830]

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:

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:

[matt3830]

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

[matt3830]

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 jason@yahoo.com
2nd import - jason jason@hotmail.com
3rd import - jason jason@aol.com

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

[Jerry]

You haven't deleted the session, the vBfield table needs to be updated.

[Jerry]

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 jason@yahoo.com
2nd import - jason jason@hotmail.com
3rd import - jason jason@aol.com

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

The username is prepended with "imported_"

[matt3830]

What happens with the third username?

jason
imported_jason
imported_imported_jason?

[Jerry]

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.

[matt3830]

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

[Jerry]

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 :



SELECT userid, username FROM user WHERE username LIKE 'imported_%';