1800 Users have imported_ as a prefix

[abufaisal]

After importing to a new Vb from Phpbb2 and have 19300+ users now I have 20400+ users 1800+ is prefixed by imported (http://alyaseer.net/vb/member.php?find=lastposter&t=4721)_ .

I noticed that the are duplicated, userx and imported (http://alyaseer.net/vb/member.php?find=lastposter&t=4721)_userx have the same email and the same No. of threads.


Any Idea why and how to solve this ?

[Colin F]

It seems you imported some of them doubled, which caused this.
Add a new usergroup, and then run this query to move all the imported_* users to that usergroup:

UPDATE user SET usergroupid = X WHERE username LIKE 'imported_%';

You can then prune that usergroup.

[abufaisal]

You are fast Colin , thanks

I am not that much on PHP so could you please please explain more:
I will creat a usergroup called IMP then :

1-from where to run this ?
2- what shall I do to get the threads to the original user?

[Colin F]

1. You can run queries either in phpMyAdmin, or in the
AdminCP -> Maintenance -> Execute SQL Query
menu.

2. If the threads/posts are associated with the imported_* user, you might want to merge the imported_* user with the actual user.

[abufaisal]

I get a message that I am Unautherized to run sql commands from within CP so I will do it fro PHPmyadmin.

So It would be:
UPDATE user SET usergroupid = IMP WHERE username LIKE 'imported_%';

Correct ?

How to do the merge thing?

[Colin F]

Not quite, instead if IMP you'd want to put the usergroupid number. You can find this on the Usergroup Manager overview.

[abufaisal]

I think I will do the merge , this is teh Only way to make sure I am not losing any thing