Something went wrong while importing from PHPBB

[thedino]

I have imported without problems from PHPBB posts and users using impex.
Now when I opened the forum and made some additions I have noticed that posts are made by users who are not in the system...
I remember that I had half of the users doubled so I deleted one half and did not notice that this part was the one with posts... is there a way how to merge these users?

For example first post here webmaster-money.org/forum/urlcash-url-www-t2975.html darksorrow does not exist but he is under different ID with 0 posts webmaster-money.org/forum/member.php?u=2566

And there is total 4000+ users that posted but posts are not counted.

Can someone solve it?

--------------- Added [DATE]1272406944[/DATE] at [TIME]1272406944[/TIME] ---------------

I checked tables and it looks like I will need only to modify table "post" get there username search it in table "user" get there correct "userid" and replace userid in table "post".

Can someone help with this SQL? I can run it in phpmyadmin but there is 50k posts so it will take some time so I think the code needs to be optimized...
Same think is going on with PMs I think but this can not be fixed and I think PMs can be ignored...

[borbole]

Didi you run the options at the Update Counters section at the Maintenance after the conversion?

P.s. I think is best to post this at the Impex forum at the vbulletin.com as per the rules.

[thedino]

OK, could be moved... but in the mean time I found the query and looks like it works now...

This is what I entered and in few seconds it was fixed:

UPDATE post SET post.userid=user.userid WHERE post.username=user.username;